Getting External Platform Deal Contacts in Batches

Alejandro Posted by: Alejandro Hernandez Date Posted: January 29, 2025
Back to Case Studies

Issue

In a Workato recipe, the external platform deals can be queried in bulk but they exclude contact data and we want to avoid using one API call and task per deal for fetching the associated contacts.

Solution

If contacts can be queried in bulk by last updated date then a lookup table can be created to store the contacts and to keep them up-to-date. Then the deals workflow will locally fetch each deal’s contact via a lookup formula instead of having to hit the API once per deal/contact, which is more costly and can cause API limit reached issues for the client.
In the case of Integrity Overhead Door, the platform was Service Fusion, and the workflow runs the contact import/update portion before getting the deals incrementally.

Achievement

Integration deals and contacts queried in bulk to lower Workato task usage and external platform API calls.

Snippet/Screenshot/Link

The contact import portion of the workflow