APIs & Integrations

Athul_C
Participante

CRM API v3 - Sort based on the modified date

resolver

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 Me gusta
1 Soluciones aceptada
Willson
Solución
HubSpot Employee
HubSpot Employee

CRM API v3 - Sort based on the modified date

resolver

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

Ver la solución en mensaje original publicado

6 Respuestas 6
vikram-mit
Participante

CRM API v3 - Sort based on the modified date

resolver

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
Equipo de producto de HubSpot
Equipo de producto de HubSpot

CRM API v3 - Sort based on the modified date

resolver

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

0 Me gusta
DGodoy
Participante

CRM API v3 - Sort based on the modified date

resolver

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

0 Me gusta
Willson
Solución
HubSpot Employee
HubSpot Employee

CRM API v3 - Sort based on the modified date

resolver

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
Participante

CRM API v3 - Sort based on the modified date

resolver

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 Me gusta
Athul_C
Participante

CRM API v3 - Sort based on the modified date

resolver

Hi willson,

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

Regards

Athul

0 Me gusta