CRM API v3 - Sort based on the modified date

Develop, Build & Integrate APIs & Integrations
1

Hi Hubspot team,

I was working around Hubspot API v3, and I have requirement of sorting contacts based on modified date.So is there any solution for the same.

Thanks

Atul

2

Hi @Athul_C

When working with our v3 APIs, you can work specifically with our CRM Search API in order to Sort results by properties.

As an example, we can use the following request:

curl https://api.hubapi.com/crm/v3/objects/contacts/search?hapikey=YOUR_HUBSPOT_API_KEY \
 --request POST \
 --header "Content-Type: application/json" \
 --data '{
 "sorts": [
 {
 "propertyName": "lastmodifieddate",
 "direction": "DESCENDING"
 }
 ]
 }'

This would then fetch your Contacts and sort them according to the lastmodifieddate timestamp, in this particular case, those created most recently.

I hope this helps!

3

Hi willson,

Thank you for the quick response.This made my day.
16x16_smiley-happy.png.png

Regards

Athul

4

Hi @Willson ,

I am try to retrieve all the tickets data from a certain date → basically filtering out the data since the lastmodifieddate. However, this is giving all my ticket records instead of just only the ones from the last modified date.

Any help / advice is appreciated, thank you.

5

Hello,

Does the search go off a secondary index? We see out of order records many times when we use this API, making our integrations skip large number of records when syncing from Hubspot. Are there any best practices around handling such records?

6

how do i do it with regular object api like https://api.hubapi.com/crm/v3/objects/companies say i want to sort by lastmodifieddate ?

7

@vikram-mit , this is only available for the search endpoint

8

Hi, how can i get the results sorted using python? Thanks in advance!