topic API query to get open tickets in APIs & Integrations

API query to get open tickets

RyanClark — Tue, 11 Apr 2023 09:55:27 GMT

I am looking to use MS Flow to get a count of the open tickets from each pipeline every day. We already have Flow connected and running some tasks, but the query to get open tickets from a pipeline is more complex that I would have hoped. Does anyone have an example of how I would submit the request to get the open tickets by Flow?

Re: API query to get open tickets

Jaycee_Lewis — Tue, 11 Apr 2023 21:06:20 GMT

Hey, @RyanClark 👋 Thanks for reaching out. I do not have an MS Flow-specific example. I can provide an example of how to structure a similar request using the Search API.

We'll also leave this open in case there are community members who have the app-specific steps you are looking for.

Best,

Jaycee

Re: API query to get open tickets

RyanClark — Thu, 13 Apr 2023 09:13:37 GMT

Hi, it doesn't have to be Flow specific, but if someone can put an example together in cURL I can probably adapt that.

Re: API query to get open tickets

Jaycee_Lewis — Thu, 13 Apr 2023 23:00:52 GMT

Hey, @RyanClark 👋 Here's my example using Postman:

I have a pipeline with open tickets

Request

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

Body

{ "filterGroups": [ { "filters": [ { "propertyName": "hs_pipeline", "operator": "EQ", "value": "19625033" }, { "propertyName": "hs_pipeline_stage", "operator": "NEQ", "value": "47925265" } ] } ] }

Response

{ "total": 3, "results": [ { "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 } ] }

My underlying thinking:

we can do this per pipeline
our request will look for all tickets that are not Closed
you could also filter by thinking of it the other way around, i.e. use all stages except Closed. Whatever meets your needs.

Have fun building! — Jaycee

Re: API query to get open tickets

RyanClark — Wed, 19 Apr 2023 12:27:36 GMT

Hi, thanks very much for this. I have managed to get it into Flow and it is working. The only issue I have is that we have a pipeline with 3 closed states. If I try the query to search on that pipeline and exclude those 3 states. I get this error. Is there a way round that?

Invalid input JSON on line 1, column 299: too many filters per filterGroup (count: 4, max allowed: 3)

One last thing, can I also search on dates like 'Today' or 'Yesterday' as I can with ticket views?