Migration of records


#1

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?


#2

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