block-4.js

block-4.js

function deleteRecord(payload, done) {
  payload.record = payload.data;
  payload.record.form_id = "{FULCRUM SECOND FORM ID}";
  // this sets up the record id from the original form to the text field in the 2nd form
  payload.record.form_values['{FULCRUM ELEMENT KEY}'] = payload.record.form_values['{FULCRUM ELEMENT KEY 2}'];
  delete payload.data;
  
  var query = encodeURIComponent("SELECT _record_id AS fulcrum_id FROM \"Table Name\" WHERE my_record_id= '" + payload.record.form_values['FULCRUM ELEMENT KEY'] + "'");
    
  request({
    method: 'GET',
    url: 'https://api.fulcrumapp.com/api/v2/query/?format=json&q=' + query,
    headers: {
      'X-ApiToken': '{API TOKEN}',
      'User-Agent': 'request'
    }
  },
  function (err, httpResponse, body) {
    console.log(err, body);
    console.log('before', body);
    body = JSON.parse(body);
    console.log('after', body);
    if (body['rows'][0] && body['rows'][0]['fulcrum_id']){
      request({
        method: 'DELETE',
        url: 'https://api.fulcrumapp.com/api/v2/records/' + body['rows'][0]['fulcrum_id'] + '.json',
        json: payload.record,
        headers: {
          'X-ApiToken': '{API TOKEN}'
        }
      },
      function (err, httpResponse, body) {
        console.log('DELETE', body);
      });
    };
    done();
  });
}