Getting a list of tickets from certain pipeline

Developer Support APIs & Integrations
1

Hey There,

I am trying to use this API call to get a list of the tickets with their info and I would like to get a list only of tickets that are in a specific pipline (hs_pipeline=1158281) but I don’t know how to (if even possible) to filter that out, to set that parameter in the API call?

I tried using following which didn’t work:

https://api.hubapi.com/crm/v3/objects/tickets?limit=10&properties=hs_pipeline&properties=hs_pipeline=1158281&properties=content&properties=createdate&properties=hs_lastmodifieddate&properties=hs_pipeline_stage&properties=hs_ticket_category&archived=false

as you can see in the code call I tried using “properties=hs_pipeline=1158281”

How, if possible, can I get a a response with the tickets that are only part of that pipeline?

(FYI I am using appscript with “UrlFetchApp” for the call)

2

Hi, @mmacerl :waving_hand: Great question!

The Search API will be your best friend here. We can use a modified version of this example. We’ll use the EQ search operator for our use case.

Here’s a quick example using my test portal:

  • I have two Ticket Pipelines — Support and Art
  • Art has two tickets

CleanShot 2023-03-16 at 09.57.50.png
CleanShot 2023-03-16 at 09.57.50.png1227×564 71.2 KB

  • I find Postman is easier for me to use when testing the Search API, and you can test from the page example (endpoints tab >search) or however works best for you :blush:

  • The request URL
    POST https://api.hubapi.com/crm/v3/objects/tickets/search​

  • The request body

    {
 "filterGroups": [
 {
 "filters": [
 {
 "propertyName": "hs_pipeline",
 "operator": "EQ",
 "value": 
 "19625033"

 }
 ]
 }
 ]
}​

  • The response

    {
 "total": 2,
 "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
 }
 ]
}​

I hope this helps you get moving forward!

Best,

Jaycee