I’m creating a proof of concept/ demo and need data from Zoho CRM.
The code has to be written in node.js
It pulls Accounts, Contacts, Deals, Lead, and User records that have changed in the last 5 hours. The columns for each object will be shared once we pick a resource, but for example we would pull the following for account – id, Last Modified Date, Account Name, Website, URL
It puts the output of each data set into its own file in a LDJSON format, so we end up with 5 files assuming that data has changed for all 5 data types in the last 5 hours.
The file names use the format
Datatype-ddmmyy-hhmmss.json
E.g. account-120524-060343.json
You can see ldjson examples at the bottom of this page
https://us-62605.app.gong.io/settings/api/documentation#post-/v2/crm/entities
Since it’s just a proof of concept:
We will run locally on http://localhost:3000 and download the files locally
We can hard code values like the Zoho client id, Zoho org id, look back # of hours etc.
We don’t need to add a bunch of error handling, have everything logged to the running git/ node.js window
There will be more work to refine it, but this is a good starting point.
It would be great to have you do the first pass using your own Zoho instance, you can demo it to us, make changes, and then we have it run against our Zoho instance.
