• Using Dataflow to replicate data from postgres to Zoho CRM

Using Dataflow to replicate data from postgres to Zoho CRM

  • 58Views
  • Last Post 13 September 2022
0
votes
Aniket Mohapatra posted this 05 September 2022

Hello Colleagues,

I am using a Dataflow to configure a replication flow from my postgres data source to my Zoho CRM. As a first attempt I noticed that for each contact update, I have a lot of API calls to CRM. How does this work under the hood. How can we optimize the API calls to ZOHO CRM. Is it possible to have a short meeting to help us understand? FYI, we have lookup on the CRM, where we try to get the ID of the contact. If found, we update otherwise we insert. Is it possible to take advantage of the cache?

 

Regards,

Aniket

#dataflow

Attached Files

Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 12 September 2022

Hello Aniket.

Thank you for contacting us.

Your request has been taken in progress. We will return to you ASAP.

Best regards,

Yevheniia Bilotserkovska.

0
votes
Yevheniia Bilotserkovska posted this 13 September 2022

Hello Aniket.

Thank you for your waiting.

In this case we would recommend you to consider using of Import Package with UPSERT operation.

How to perform UPSERT operation you can find here https://docs.skyvia.com/data-integration/import/performing-upsert-operation.html

So it will be possible to reduce amount of API calls by using cached Lookup. For this you need to select Options - Use cache on the Mapping Definition stage. Please find the example on the screenshot below.

Also you can find more information about cached Lookup here https://docs.skyvia.com/data-integration/common-package-features/mapping/lookup-mapping-target-lookup-and-source-lookup.html#lookup-options

Please feel free to contact us if you need any additional information from our side.

Best regards,

Yevheniia Bilotserkovska

New Ticket
Categories
Popular Tags
Close