Can different records go to different branches

Integrator.io
, , ,
1

Question: how can I, when receiving multiple records through a webhook, send them through the flow one at a time or branch off when one of the records is incorrect?

I have a webhook that is receiving shipment data to send load information to our TMS which comes through a WebHook with multiple records. When a record comes through that is missing data, I want to branch off that bad record.

Originally, instead of a webhook, we were using individual files. In that scenario, if one file had missing data, then it would error and the other files would process successfully.

Now, we're switching to a series of API's due to how the data comes out of the WMS software. For that process, I have one flow that is pulling the data from the WMS (that looks like the below) and then sending parsed contents of the into a webhook process flow.

5301043caa20740200000001-0158f3d4be4e4c46a9a4db94af03a7ad.png
5301043caa20740200000001-0158f3d4be4e4c46a9a4db94af03a7ad.png797×113 7.79 KB

Since it's coming through a WebHook, I'm not able to break the records up and send them one at a time from what I can tell, but that's what I need it to do. I have all of the flow steps set to “Parse One to Many” but the branch received all of the records at once.

2

@jackharris this is possible to do, but you'll need a preSavePage script. For other sources, like HTTP and FTP, they have a “path to records” field, which is what you're needing in this case, however webhook sources don't have this field. So in your preSavePage script, you take each record which could be 2, then output 3. Can you send a complete XML sample? Here is a sample script though to give direction:

function preSavePage(options) {
  const updatedData = options.data.map(record => {
    if (record['soap:Body'] && record['soap:Body'].GetOrderStatusDetail_Result && record['soap:Body'].GetOrderStatusDetail_Result.pxXMLDoc) {
      const pxXMLDoc = record['soap:Body'].GetOrderStatusDetail_Result.pxXMLDoc;
      if (Array.isArray(pxXMLDoc)) {
        return pxXMLDoc.map(doc => {
          return doc;
        });
      } else {
        return pxXMLDoc;
      }
    }
    return record;
  }).flat();

return updatedData;

}

5301043caa20740200000001-9a1d2e5725234c938541f365a0160aa5.png
5301043caa20740200000001-9a1d2e5725234c938541f365a0160aa5.png2511×1253 236 KB

3

@jackharris you're preSavePage script on the lookup would be this. Notice it checks for array or object because with XML parsing if it only sent 1 confirmation, then it would parse as an object, but if there are multiple then it parses into an Array of multiple.

function preSavePage (options) {
  const newData = [];
  options.data.forEach(record => {
    if (Array.isArray(record.ShipmentConfirmationAdvice)) {
      record.ShipmentConfirmationAdvice.forEach(advice => {
        newData.push(advice);
      });
    } else {
      newData.push(record.ShipmentConfirmationAdvice);
    }
  });
  return {
    data: newData,
    errors: options.errors,
    abort: false,
    newErrorsAndRetryData: []
  };
}

For the given XML:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

  
    XXX
    ANON123456
    
    SHIP12345
    01/16/2025
    01/20/2025
    01/22/2025
    
    
      ANONCODE
      ANON NAME
      
      ANON ADDRESS
      
      ANON CITY
      XX
      00000
      XX
    
    
      ANON
      ANON NAME
    
    
      ANONCARRIER
      ANON CARRIER
    
    
    WHXX
    ANON
    0
    
      ANONCODE
      ANON NAME
      ANON ADDRESS
      
      ANON CITY
      XX
      00000
      XX
    
    0.00
    
    
    
    
    XXX
    ANON
    0
    0
    0.00
    
      ITEM0001
      40
      0
      ANON
      ANON ITEM
      
      
      
      
      
      
      
      
      XX
      
      
      
      
      
      0000.0
4

Thank you so very much. This is going to come greatly in handy for us moving forward!