Follow Up Hupspot 404 Exception

Fivetran
Member

The sync failed at the following curl request:

 

curl -H 'Authorization: Bearer **' -A 'Jersey/2.31' 'https://api.hubapi.com/contacts/v1/lists/recently_updated/contacts/recent?count=100&limit=250&formSubmissionMode=all&vidOffset=53270307&property=lastmodifieddate&timeOffset=1610758511238&propertyMode=value_and_history'

 

 

with following offsets

 

vid-offset : 53270307,
time-offset : 1610758511238

 


response:

 

Hubspot 404 error image 1.png


The value for time-offset and vid-offset is provided by the Hubspot API in previous page which can found in the response of the previous curl request : 

 

curl -H 'Authorization: Bearer **' -A 'Jersey/2.31' 'https://api.hubapi.com/contacts/v1/lists/recently_updated/contacts/recent?count=100&limit=250&formSubmissionMode=all&vidOffset=32768357&property=lastmodifieddate&timeOffset=1610773658450&propertyMode=value_and_history'

 


But I ran the sync again and the offset values changed to

 

vid-offset : 52513857,
time-offset : 1610758329942

 


and the failed with same 404 error.


Why are the offsets being returned with a response of 

 

curl -H 'Authorization: Bearer **' -A 'Jersey/2.31' 'https://api.hubapi.com/contacts/v1/lists/recently_updated/contacts/recent?count=100&limit=250&formSubmissionMode=all&vidOffset=32768357&property=lastmodifieddate&timeOffset=1610773658450&propertyMode=value_and_history'

 



@WendyGoh @dennisedson 

0 Upvotes
4 Replies 4
dennisedson
Community Manager

Hey @Fivetran 

Is this issue persisting?

Thanks,

Dennis




Check out our Community Developer Blog
where we feature our Community driven developer podcast and how to content
0 Upvotes
Fivetran
Member

I keep getting an error trying to submit my response so I will respond in batches. 

0 Upvotes
Fivetran
Member

Upon further investigation I found out that there is a problem with Contact with id 52490207. If the API response contains this particular Id it fails with 404 with the reason could not find last modified date for 52490207

In the curl request we add property=lastmodifieddate parameter so that we could save the state from the response.. (I tried the curl request without this param and still got the error), the problem here is the API just doesn’t send the object, it fails. It it was sending that object 52490207 without last modified date we could have caught such corrupted object and skipped it or synced it, but currently the API just fails from HubSpot side.

Furthermore I tried to fetch just the contact with ID 52490207 and it doesn't contain lastmodifieddate property as show below:

0 Upvotes
Fivetran
Member

Screenshot 2021-01-25 at 5.57.58 PM.png

Here is example of another contact 42961207 which contains lastmodifieddate property:
Screenshot 2021-01-25 at 5.59.49 PM.png

0 Upvotes