Exports based on Lookup Caches

Integrator.io
,
1

Is it possible to do an export based on all records within a lookup cache?

Scenario, I have a TMS system that I'm trying to get invoices out of. Currently, I'd have to do a call into the TMS for all loads for a specific client, then filter on those loads to find which ones have invoices, then filter on which has invoices that were recently created.

What I'd like to do is store the id number for each completed load in a look up cache which will populated by a different flow. Then periodically use the lookup cache to find out if those loads have invoices. If they do, then send a 210 and remove it from the lookup cache.

2

Hi Jack,
That's a cool idea!
Yeah, I think you can do it like this:

  1. Have a "Celigo" Export step that will call the specific Lookup Cache
  2. If needed, add a transformation or a PreSave script to structure your data as needed downstream
  3. Each of the downstream steps will iterate through the records from your Lookup Cache.
  4. As a final step, use the Celigo endpoint to update the specific Lookup Cache.

Here's the Lookup Cache API documentation if you need it: https://docs.celigo.com/hc/en-us/articles/33900314608667-Lookup-caches-API-endpoints

Let me know if you need any specific documentation or examples.

Good luck!

Yonton Mehler
Sr. Dev
Celigo

1 Like