Iterating through records from one webservice call to drive a second call

Been out of the developer mindset the last few years and am trying to build what seems like a simple integration using Celigo to connect to our Geotab platform and make a few calls to pull nightly odometer and engine hour readings off our fleet of vehicles.

years ago i wrote a quick desktop application to do this, but would like to utilize Celigo for this, this time around.

I created a flow in my sandbox with the following needs

  1. Authenticate to the Geotab endpoint and capture the sessionID (works fine)
  2. Pass that sessionID to a lookup to get a list of all active devices (works fine)
  3. Iterate through the returned active devices and make a seperate call to retrieve the odometer reading (can’t get the device list to pass down the flow)
  4. then either down stream or in a branch also iterate through that same list again making a second call to retrieve the engine hours

I may be making this way more difficult than necessary, but i spent a few hours back and forth with ChatGPT last night and didn’t get it solved so i figured i’d reach out to the collective and see where my process is flawed.

Thanks in advance for any help!

@Adrian_Aucoin_Jr

Please add results mapping on the lookup step , to merge the list of all active devices received into the record exported.

Click on 3 dots on the lookup step , in the list select results mapping

Add results mapping

You can read more : https://docs.celigo.com/hc/en-us/articles/360054647472-Lookups-and-results-mapping