APIs & Integrations

Athul_C
Participant

CRM API v3 - Sort based on the modified date

SOLVE

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

0 Upvotes
1 Accepted solution
Willson
Solution
HubSpot Employee
HubSpot Employee

CRM API v3 - Sort based on the modified date

SOLVE

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!

Product Manager @ HubSpot

View solution in original post

6 Replies 6
vikram-mit
Participant

CRM API v3 - Sort based on the modified date

SOLVE

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
Community Manager
Community Manager

CRM API v3 - Sort based on the modified date

SOLVE

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

Thanks,

Dennis




HubSpot Community Developer ShowMake sure to subscribe to our YouTube channel
where you can find the HubSpot Community Developer Show
0 Upvotes
DGodoy
Participant

CRM API v3 - Sort based on the modified date

SOLVE

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

0 Upvotes
Willson
Solution
HubSpot Employee
HubSpot Employee

CRM API v3 - Sort based on the modified date

SOLVE

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!

Product Manager @ HubSpot
kawyns1
Participant

CRM API v3 - Sort based on the modified date

SOLVE

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.

0 Upvotes
Athul_C
Participant

CRM API v3 - Sort based on the modified date

SOLVE

Hi willson,

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

Regards

Athul

0 Upvotes