APIs & Integrations

swetha_salaskar
Member

Migration of records

Hi,
I am using SSIS package to migrate contacts from hubspot to crm using hubspot api and hubspot api retrieves maximum of 250 records at a time.Using SSIS how do I retrieve the next set of records?

0 Upvotes
1 Reply 1
Derek_Gervais
HubSpot Alumni
HubSpot Alumni

Migration of records

Hi @swetha.salaskar,

I'm not particularly familiar with SSIS, but you'd need a way to pull values from each request and add them as parameters to the URL. Specifically, you'll need to pull the vid-offset and time-offset fields from the response and append them to the next request URL as query parameters, like this:

((requestURL))?vidOffset=12345&timeOffset=1234567891011
0 Upvotes