Question on the "after" parameter

[DanaIrvine]

I am using /crm/v3/objects/tickets/search to search tickets. The issue I am having is I am expecting more than 200 results, but there's a limit of 200 with a search. I believe the "after" parameter is my solution to query additional pages of data but I can't figure out what it is expecting there, or how it is used.

[DanaIrvine]

Nevermind, assigned a variable in the wrong spot in my loop.. duh!




Meet with Dana Irvine<>


[A close up of a logo Description automatically generated]



[facebook]<> [linkedin] <> [twitter] <>



Dana Irvine (they/them/theirs)
IT Manager

Tel: 866.444.4615 x1007

Direct: 609-879-0020

www.paragonpayroll.com<>

Please note that all times are EST unless otherwise specified.



________________________________
From: Dana Irvine
Sent: Tuesday, October 29, 2024 11:16 AM
To: hubspot.prod|52220eb7|6fe2fc0f-89cb-443a-a18d-e14f3c523b06@replybyemail.usw2.prod.hosted.lithcloud.com
Subject: Re: Question on the "after" parameter

I am running this in powershell, the same JSON works in postman. Makes no sense.

[SteveHTM · Accepted solution]

 - as Jaycee mentions, you should check the value of the total and paging.next.after values returned from your first call. 

{ "total": 12, "results": [ { "id": ... } ], 
"paging": { "next": { "after": "5" } } }

If these do not indicate addition records available then there may be something else going wrong.

Good luck!

Steve

@DanaIrvine

[Jaycee_Lewis]

Hey, @DanaIrvine 👋 I completely understand why this is confusing until you do it a few times.

I don't have 200+ Tickets in my test portal, but I think I can still give an example that is enough to get you started. 

In my test portal, I have 12 Tickets:

For our example purposes, we'll make our request using a `Limit` of 5, and then use the `After` value to page through the others.

Request one (to get `after` value)

Request

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

Request body

{
    "limit": 5
}

Response

{
    "total": 12,
    "results": [
        {
            "id": ...
        }
    ],
    "paging": {
        "next": {
            "after": "5"
        }
    }
}

For all the following requests, we will include the `after` value in our requests in the body

Request #2 (which will return the next five tickets)

Body

{
    "limit": 5,
    "after": "5"
}

Request #3 (which will return the last two tickets)

Body

{
    "limit": 5,
    "after": "10"
}

In your case, since you are not sending a `limit` value, I'd expect the `after` values to come in increments of 200 for each response — "after": "200", "after": "400", "after": "600", etc.

For me personally, when I'm testing, I find Postman to be the easiest way to gain an understanding of how the Search API wants to behave.

I hope this helps get you moving forward! — Jaycee

[DanaIrvine]

Thanks, now I get an error.

This works, returns 5 records:
{
"limit": 5,
"after": "0",
"properties": [
"id"
],
"filterGroups":[{
"filters":[
{
"propertyName":"hs_lastmodifieddate",
"operator":"BETWEEN",
"highValue": 1730260800000,
"value":1727755200000
},
{
"propertyName":"hs_pipeline",
"operator":"EQ",
"value":63784995
}
]
}],
"sorts": [{
"propertyName": "id",
"direction": "ASCENDING"
}
]
}

This gives an error , returns the same 5 records: "Invalid input JSON on line 27, column 3: Could not resolve subtype of [simple type, class
| com.hubspot.conversations.publicapi.core.messages.PublicMessageEgg]: missing type id property \u0027type\u0027"

{
"limit": 5,
"after": "5",
"properties": [
"id"
],
"filterGroups":[{
"filters":[
{
"propertyName":"hs_lastmodifieddate",
"operator":"BETWEEN",
"highValue": 1730260800000,
"value":1727755200000
},
{
"propertyName":"hs_pipeline",
"operator":"EQ",
"value":63784995
}
]
}],
"sorts": [{
"propertyName": "id",
"direction": "ASCENDING"
}
]
}


The only difference is after 0 vs after 5.