Calls returning data ID vs actual data

You would need to use code to match everything back up efficiently. It’s hard to offer more specific advice without seeing the data structure returned from the API calls. 

Are you making these calls with Zapier’s webhook actions or building something more custom in developer.zapier.com? 
 

Hi

I’m using webhook to bring in the items.

The data structure really isn’t that complicated, as below.

 

data:
1:
    customerId: 1067303
    startDateTime: 2022-01-19T09:00
    endDateTime: 2022-01-19T22:00


2:
    customerId: 1067304
    startDateTime: 2022-01-19T12:00
    endDateTime: 2022-01-19T22:00

and

data:
1: 
    id: 1067303
    firstName: Fred
    lastName: Johnson

2: 
    id: 1067304
    firstName: John
    lastName: Fredson

Hi All

I ended up going with the second method:

Taking the employee ID from the first call, and calling a second API call using that as a query to fetch the full name.

I’m sad that is uses so many API calls and loops, but at least it’s future proof!

Since it isn’t likely that a name would have a comma in it you can use a code block (javascript) like the below. This is assuming you need a similar structured output. 

 

let customerIds = inputData.customerIds.split(",");
let ids = inputData.ids.split(",");
let first_names = inputData.fnames.split(",");
let last_names = inputData.lnames.split(",");
let startTimes = inputData.startTimes.split(",");
let endTimes = inputData.endTimes.split(",");

output = {
  matchedRecords: []
}
for (var i=0;i<ids.length;i++) {
  if (customerIds[i] == ids[i]) {
    output.matchedRecords.push({
      id: ids[i],
      first_name: first_names[i],
      last_name: last_names[i],
      startTime: startTimes[i],
      endTime: endTimes[i]
    })
  }
}