CRM API v3 - Sort based on the modified date

[Athul_C]

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

[vikram-mit]

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 ?

[dennisedson]

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

[DGodoy]

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

[Willson · Accepted solution]

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!

[kawyns1]

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.

[Athul_C]

Hi willson,

Thank you for the quick response.This made my day.

Regards

Athul