API endpoints to update/sync data in Custom Group Property values from my SQL data
Hello,
I need help to find HubSpot API endpoints for the following processes I need to do:
1. Need to store contact data(only my custom group property data) from Hubspot as a mirror copy on my SQL server using email as the primary value to sync between hubspot and my sql data. I will have at least two dozen properties.
2. When my data changes on my end I need to update/sync the Hubspot Custom Group Property values.
What API methods do I need to use?
I am a developer and I will be wrting code via C#. Thank you in adnvace for your help.
API endpoints to update/sync data in Custom Group Property values from my SQL data
@AppTestAccountE This topic can be use by the community as is to know how to export / import contact, so i think it will better to mark it as solved and make a new one when you will start to develop your code and encounter issue.
@quentin_lamamy is a pro at the CRM apis so I am adding him here for any additional advice 😃
An expert, well.. not really just a curious dev 🙂
@AppTestAccountEIn fact @dennisedson answer your question i have not really more to add, THe contact api will allow you to retrieve all your data and insert in your mysql DB All the endpoint and parameters are listed here . The one you will need is the first one
GET /crm/v3/objects/contacts
This endpoint will do the job, it will return your data on multiple page, with the properties parameters you can set which properties you want to retrieve.
When you make a change in your mysql use this endpoint to update HS
PATCH /crm/v3/objects/contacts/{contactId}
I let you try on your side to code that and if you have some issue, just answer here 🙂