topic Re: Tickets API search endpoint - sort by updatedAt in APIs & Integrations

Tickets API search endpoint - sort by updatedAt

webcitron — Thu, 29 Sep 2022 05:30:55 GMT

I'm trying to use endpoint `POST /crm/v3/objects/tickets/search` and receive list of tickets sorted by updatedAt descending. I've tried many combinations of "sorts" property but my tries seems to be ignored by API. Documentation does not contains so many informations about how "sorts" parameter should be used.

Anyony could give me any clue about that ?

Re: Tickets API search endpoint - sort by updatedAt

ChehakWadhdwa — Thu, 29 Sep 2022 07:42:36 GMT

Hey @webcitron

Can you try the below curl code

curl https://api.hubapi.com/crm/v3/objects/tickets/search?hapikey=YOUR_HUBSPOT_API_KEY \

--request POST \

--header "Content-Type: application/json" \

--data '{

"sorts": [

{

"propertyName": "lastmodifieddate",

"direction": "DESCENDING"

}

]

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

Re: Tickets API search endpoint - sort by updatedAt

webcitron — Thu, 29 Sep 2022 12:34:25 GMT

@ChehakWadhdwa , thanks a lot of involvement. Please check out below listings. I've tried with 3 different payloads, all of them resulting with same (and not expected) ordering or the tickets.

Script just executing api call and displaying "updatedAt" property for each returned ticket (its displays them in the order as they came from api):

```

$ curl -s --location --request POST 'https://api.hubapi.com/crm/v3/objects/tickets/search' --header 'Content-Type: application/json' --header 'Authorization: Bearer pat-na1-***' --data-raw '{
"limit": 5,
"sorts": [
{
"propertyName": "lastmodifieddate",
"direction": "DESCENDING"
}
]
}' | jq '.results[] | .updatedAt'
"2022-09-14T04:09:53.553Z"
"2022-09-14T04:09:53.562Z"
"2022-08-08T09:55:56.104Z"
"2022-09-14T04:09:53.553Z"
"2021-10-25T09:27:37.640Z"

$ curl -s --location --request POST 'https://api.hubapi.com/crm/v3/objects/tickets/search' --header 'Content-Type: application/json' --header 'Authorization: Bearer pat-na1-***' --data-raw '{
"limit": 5,
"sorts": [
{
"propertyName": "updatedAt",
"direction": "DESCENDING"
}
]
}' | jq '.results[] | .updatedAt'
"2022-09-14T04:09:53.553Z"
"2022-09-14T04:09:53.562Z"
"2022-08-08T09:55:56.104Z"
"2022-09-14T04:09:53.553Z"
"2021-10-25T09:27:37.640Z"

$ curl -s --location --request POST 'https://api.hubapi.com/crm/v3/objects/tickets/search' --header 'Content-Type: application/json' --header 'Authorization: Bearer pat-na1-***' --data-raw '{
"limit": 5,
"sorts": [
{
"propertyName": "updatedat",
"direction": "DESCENDING"
}
]
}' | jq '.results[] | .updatedAt'
"2022-09-14T04:09:53.553Z"
"2022-09-14T04:09:53.562Z"
"2022-08-08T09:55:56.104Z"
"2022-09-14T04:09:53.553Z"
"2021-10-25T09:27:37.640Z"

```

Re: Tickets API search endpoint - sort by updatedAt

ChehakWadhdwa — Fri, 30 Sep 2022 06:02:32 GMT

Hey @webcitron

Looking at the results you got :

It's fetching the results based on recent results modifies.

Could you please elaborate exactly what you want with the API ? How you want the data to come ?

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

Re: Tickets API search endpoint - sort by updatedAt

webcitron — Mon, 03 Oct 2022 09:28:59 GMT

@ChehakWadhdwa , its not. look at updatedAt values which are returned by API (orginal ordering):

```

"2022-09-14T04:09:53.553Z" (row1)
"2022-09-14T04:09:53.562Z" (row2)
"2022-08-08T09:55:56.104Z" (row3)
"2022-09-14T04:09:53.553Z" (row4)
"2021-10-25T09:27:37.640Z" (row5)

```

Note year and month especially. Expected return should be:

```

"2022-09-14T04:09:53.562Z" (row2)

"2022-09-14T04:09:53.553Z" (row1)

"2022-09-14T04:09:53.553Z" (row4)
"2022-08-08T09:55:56.104Z" (row3)
"2021-10-25T09:27:37.640Z" (row5)

```

Just reminding - im trying to fetch tickets ordered/sorted by updatedAt property value descending

Re: Tickets API search endpoint - sort by updatedAt

ChehakWadhdwa — Tue, 04 Oct 2022 07:30:51 GMT

Hey @webcitron

Could you please try using the below property

{

"propertyName": "hs_lastmodifieddate",

"direction": "DESCENDING"

}

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

Re: Tickets API search endpoint - sort by updatedAt

webcitron — Fri, 07 Oct 2022 08:49:00 GMT

Yes, thats works 🙂 Thanks a lot @ChehakWadhdwa 🍻

Re: Tickets API search endpoint - sort by updatedAt

FSoto8 — Thu, 30 Mar 2023 13:31:45 GMT

doestn work.

the response is the same without order.

Re: Tickets API search endpoint - sort by updatedAt

josie_hill — Wed, 23 Oct 2024 22:04:11 GMT

Did you ever find a solution? The last post was over a year ago. Thanks

Re: Tickets API search endpoint - sort by updatedAt

Jaycee_Lewis — Tue, 29 Oct 2024 22:10:00 GMT

Hey, @josie_hill I just tested this with my test portal, and I'm getting the expected response. Do you want to share a simple request and response where you are not getting the expected result? Either here or in a new post, and you can tag me there? I'll add mine here:

I have 12 tickets in my portal going back to 2022
Their last modified date is essentially the same as the created date for most, but it still works for this example

Request and body (I kept it very simple for this example)

POST https://api.hubapi.com/crm/v3/objects/tickets/search

{ "sorts": [ { "propertyName": "hs_lastmodifieddate", "direction": "DESCENDING" } ] }

Response

{ "total": 12, "results": [ { "id": "15816444829", "properties": { "content": null, "createdate": "2024-10-28T22:29:00.321Z", "hs_lastmodifieddate": "2024-10-28T22:29:00.967Z", "hs_object_id": "15816444829", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "testerr 6" }, "createdAt": "2024-10-28T22:29:00.321Z", "updatedAt": "2024-10-28T22:29:00.967Z", "archived": false }, { "id": "15812399104", "properties": { "content": null, "createdate": "2024-10-28T22:28:50.756Z", "hs_lastmodifieddate": "2024-10-28T22:28:51.565Z", "hs_object_id": "15812399104", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "testerrr 5" }, "createdAt": "2024-10-28T22:28:50.756Z", "updatedAt": "2024-10-28T22:28:51.565Z", "archived": false }, { "id": "15812399029", "properties": { "content": null, "createdate": "2024-10-28T22:28:44.477Z", "hs_lastmodifieddate": "2024-10-28T22:28:45.157Z", "hs_object_id": "15812399029", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "testerrr 4" }, "createdAt": "2024-10-28T22:28:44.477Z", "updatedAt": "2024-10-28T22:28:45.157Z", "archived": false }, { "id": "1555709794", "properties": { "content": null, "createdate": "2023-04-13T22:25:41.685Z", "hs_lastmodifieddate": "2024-07-31T15:57:50.072Z", "hs_object_id": "1555709794", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925265", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Testerr 3" }, "createdAt": "2023-04-13T22:25:41.685Z", "updatedAt": "2024-07-31T15:57:50.072Z", "archived": false }, { "id": "1503346867", "properties": { "content": null, "createdate": "2023-03-17T22:27:14.029Z", "hs_lastmodifieddate": "2023-03-17T22:27:14.967Z", "hs_object_id": "1503346867", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925262", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": "Cats and ninjas" }, "createdAt": "2023-03-17T22:27:14.029Z", "updatedAt": "2023-03-17T22:27:14.967Z", "archived": false }, { "id": "1500746070", "properties": { "content": null, "createdate": "2023-03-16T15:49:04.683Z", "hs_lastmodifieddate": "2023-03-16T15:49:06.041Z", "hs_object_id": "1500746070", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925262", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Testerr 2" }, "createdAt": "2023-03-16T15:49:04.683Z", "updatedAt": "2023-03-16T15:49:06.041Z", "archived": false }, { "id": "1500746054", "properties": { "content": null, "createdate": "2023-03-16T15:48:45.014Z", "hs_lastmodifieddate": "2023-03-16T15:48:46.290Z", "hs_object_id": "1500746054", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925262", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Testerr 1" }, "createdAt": "2023-03-16T15:48:45.014Z", "updatedAt": "2023-03-16T15:48:46.290Z", "archived": false }, { "id": "1478326183", "properties": { "content": null, "createdate": "2023-03-03T21:15:46.531Z", "hs_lastmodifieddate": "2023-03-03T21:15:51.870Z", "hs_object_id": "1478326183", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Cat Circus—Big top issue" }, "createdAt": "2023-03-03T21:15:46.531Z", "updatedAt": "2023-03-03T21:15:51.870Z", "archived": false }, { "id": "1317382811", "properties": { "content": null, "createdate": "2022-12-13T20:34:07.713Z", "hs_lastmodifieddate": "2022-12-13T20:34:09.268Z", "hs_object_id": "1317382811", "hs_pipeline": "0", "hs_pipeline_stage": "2", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": null }, "createdAt": "2022-12-13T20:34:07.713Z", "updatedAt": "2022-12-13T20:34:09.268Z", "archived": false }, { "id": "1317387588", "properties": { "content": null, "createdate": "2022-12-13T20:26:40.691Z", "hs_lastmodifieddate": "2022-12-13T20:26:43.223Z", "hs_object_id": "1317387588", "hs_pipeline": "0", "hs_pipeline_stage": "2", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": null }, "createdAt": "2022-12-13T20:26:40.691Z", "updatedAt": "2022-12-13T20:26:43.223Z", "archived": false } ], "paging": { "next": { "after": "10" } } }

And just for fun, if we flip it and use ASCENDING, here's the response

{ "total": 12, "results": [ { "id": "1046754424", "properties": { "content": "This is a test form submission", "createdate": "2022-08-11T23:23:54.489Z", "hs_lastmodifieddate": "2022-09-14T12:25:22.358Z", "hs_object_id": "1046754424", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "New form channel connected" }, "createdAt": "2022-08-11T23:23:54.489Z", "updatedAt": "2022-09-14T12:25:22.358Z", "archived": false }, { "id": "999396896", "properties": { "content": null, "createdate": "2022-07-14T16:08:40.033Z", "hs_lastmodifieddate": "2022-10-24T20:09:44.395Z", "hs_object_id": "999396896", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": "troubleshoot report" }, "createdAt": "2022-07-14T16:08:40.033Z", "updatedAt": "2022-10-24T20:09:44.395Z", "archived": false }, { "id": "1317387588", "properties": { "content": null, "createdate": "2022-12-13T20:26:40.691Z", "hs_lastmodifieddate": "2022-12-13T20:26:43.223Z", "hs_object_id": "1317387588", "hs_pipeline": "0", "hs_pipeline_stage": "2", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": null }, "createdAt": "2022-12-13T20:26:40.691Z", "updatedAt": "2022-12-13T20:26:43.223Z", "archived": false }, { "id": "1317382811", "properties": { "content": null, "createdate": "2022-12-13T20:34:07.713Z", "hs_lastmodifieddate": "2022-12-13T20:34:09.268Z", "hs_object_id": "1317382811", "hs_pipeline": "0", "hs_pipeline_stage": "2", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": null }, "createdAt": "2022-12-13T20:34:07.713Z", "updatedAt": "2022-12-13T20:34:09.268Z", "archived": false }, { "id": "1478326183", "properties": { "content": null, "createdate": "2023-03-03T21:15:46.531Z", "hs_lastmodifieddate": "2023-03-03T21:15:51.870Z", "hs_object_id": "1478326183", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Cat Circus—Big top issue" }, "createdAt": "2023-03-03T21:15:46.531Z", "updatedAt": "2023-03-03T21:15:51.870Z", "archived": false }, { "id": "1500746054", "properties": { "content": null, "createdate": "2023-03-16T15:48:45.014Z", "hs_lastmodifieddate": "2023-03-16T15:48:46.290Z", "hs_object_id": "1500746054", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925262", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Testerr 1" }, "createdAt": "2023-03-16T15:48:45.014Z", "updatedAt": "2023-03-16T15:48:46.290Z", "archived": false }, { "id": "1500746070", "properties": { "content": null, "createdate": "2023-03-16T15:49:04.683Z", "hs_lastmodifieddate": "2023-03-16T15:49:06.041Z", "hs_object_id": "1500746070", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925262", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Testerr 2" }, "createdAt": "2023-03-16T15:49:04.683Z", "updatedAt": "2023-03-16T15:49:06.041Z", "archived": false }, { "id": "1503346867", "properties": { "content": null, "createdate": "2023-03-17T22:27:14.029Z", "hs_lastmodifieddate": "2023-03-17T22:27:14.967Z", "hs_object_id": "1503346867", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925262", "hs_ticket_category": null, "hs_ticket_priority": "HIGH", "subject": "Cats and ninjas" }, "createdAt": "2023-03-17T22:27:14.029Z", "updatedAt": "2023-03-17T22:27:14.967Z", "archived": false }, { "id": "1555709794", "properties": { "content": null, "createdate": "2023-04-13T22:25:41.685Z", "hs_lastmodifieddate": "2024-07-31T15:57:50.072Z", "hs_object_id": "1555709794", "hs_pipeline": "19625033", "hs_pipeline_stage": "47925265", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "Testerr 3" }, "createdAt": "2023-04-13T22:25:41.685Z", "updatedAt": "2024-07-31T15:57:50.072Z", "archived": false }, { "id": "15812399029", "properties": { "content": null, "createdate": "2024-10-28T22:28:44.477Z", "hs_lastmodifieddate": "2024-10-28T22:28:45.157Z", "hs_object_id": "15812399029", "hs_pipeline": "0", "hs_pipeline_stage": "1", "hs_ticket_category": null, "hs_ticket_priority": null, "subject": "testerrr 4" }, "createdAt": "2024-10-28T22:28:44.477Z", "updatedAt": "2024-10-28T22:28:45.157Z", "archived": false } ], "paging": { "next": { "after": "10" } } }

Talk soon! — Jaycee