+1 (866) 832-3090
+91 (44) 6667 8040
+44 (800) 808 5790
+61 2 8188 4692
I am unable to extract all tickets that were created yesterday or updated yesterday.
I am using the api token .
Queries that i have tried but failed are
This query returns all the tickets
"https://"+ domain +".freshdesk.com/helpdesk/tickets/filter/all_tickets?format=json&updated_since=2017-10-05&page=[pageno]", auth = (api_key, password))
This query returns error code 400
"https://'+ domain +'.freshdesk.com/api/v2/search/tickets?query="created_at:2017-10-05T00:00:00Z"', auth = (api_key, password))
Can anyone please help me with the correct query
Can you please try using this query to obtain the ticket list that were updated yesterday?
Thanks for your reply, However your query returns only 35 columns and 30 rows. Im interested in getting all the tickets and columns.
Here is the code i wrote in python to extract and return all tickets, but after running this one i need to run a new script which would extract only yesterdays tickets and not all.
r = requests.get("https://"+ domain +".freshdesk.com/helpdesk/tickets/filter/all_tickets?format=json&page="+str(i), auth = (api_key, password))
print("First Statement executed")
Ticket_Table = pd.concat([Ticket_Table,json_normalize(json_data)],axis=0,ignore_index=True)
print("I counter : "+str(i))
You can probably use the per_page and page parameters to increate the list of results that is returned. You can read more about them here : Pagination
Start your 21-day free trial. No credit card required. No strings attached.
Copyright © Freshworks Inc. All Rights Reserved.