I am unable to reference fields in the URI for the following data to get tickets that were updated in a specific date range. I am unsure if my syntax is incorrect or what the issue may be. I believe sort_by and sort_order are working because they do not reference fields and instead take specific arguments.
URI:
/api/v2/tickets?updated_at>={{dateFormat "2022-06-01" }}&updated_at<={{dateFormat "YYYY-MM-DD" timeStamp}}&sort_by=created_at&sort_order=asc
Sample Record of Data
{
"page_of_records": [
{
"record": {
"url": "https://company.zendesk.com/api/v2/tickets/99999.json",
"id": 99999,
"external_id": null,
"via": {
"channel": "web",
"source": {
"from": {},
"to": {},
"rel": "web_widget"
}
},
"created_at": "2021-01-18T18:41:07Z",
"updated_at": "2022-04-14T20:02:06Z",
"type": "question",
"subject": "Payment Plans",
"raw_subject": "Payment Plans",
"description": "I have attached payment plans. Let me know what else is needed for these. Thanks\n\n------------------\nSubmitted from: https://company.sharepoint.com/SitePages/Home.aspx",
"priority": "normal",
"status": "closed",
"recipient": null,
"requester_id": 999999999999,
"submitter_id": 999999999999,
"assignee_id": 999999999999,
"organization_id": 999999999999,
"group_id": 999999999999,
"collaborator_ids": [
999999999999
],
"follower_ids": [
999999999999
],
"email_cc_ids": [
999999999999
],
"forum_topic_id": null,
"problem_id": null,
"has_incidents": false,
"is_public": true,
"due_at": null,
"tags": [
"ex_category",
"assistance",
"current",
"non-applicable",
"standard_request",
"va",
"web_widget",
"z_–_not_an_error"
],
"custom_fields": [
{
"id": 999999999999,
"value": "sample_category"
},
{
"id": 999999999999,
"value": "Multiple"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "va"
},
{
"id": 999999999999,
"value": "non-applicable"
},
{
"id": 999999999999,
"value": "current"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "9999"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "assistance"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "z_–_not_an_error"
},
{
"id": 999999999999,
"value": "standard_request"
}
],
"satisfaction_rating": null,
"sharing_agreement_ids": [],
"fields": [
{
"id": 999999999999,
"value": "category"
},
{
"id": 999999999999,
"value": "Multiple"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "va"
},
{
"id": 999999999999,
"value": "non-applicable"
},
{
"id": 999999999999,
"value": "current"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "2105"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "assistance"
},
{
"id": 999999999999,
"value": null
},
{
"id": 999999999999,
"value": "z_–_not_an_error"
},
{
"id": 360043109372,
"value": "standard_request"
}
],
"followup_ids": [],
"ticket_form_id": 999999999999,
"brand_id": 999999999999,
"allow_channelback": false,
"allow_attachments": true
}
}
]
}