I have an API which successfully extracts all FreshService tickets and inserts them into a SQL database table.I now need an extra column which is located on requested_items. I tried to access this data with an API call for each ticket. This worked but blew out the daily maximum API calls when I tried to process thousands of tickets.api/v2/tickets/'+str(row["id"])+'/requested_itemsSo I am now trying to extract all requested_items for a time period and insert then in a SQL database table. Later, in the reporting layer, these tables can be joined to show all requested_items for a set of tickets.Can you please tell me how to code the API to extract all requested_items for a time period?Does this endpoint exist?something like : api/v2/requested_items ??

API end point for requested items | Freshworks Community

I have an API which successfully extracts all FreshService tickets and inserts them into a SQL database table.

I now need an extra column which is located on requested_items. I tried to access this data with an API call for each ticket. This worked but blew out the daily maximum API calls when I tried to process thousands of tickets.

api/v2/tickets/'+str(roww"id"])+'/requested_items

So I am now trying to extract all requested_items for a time period and insert then in a SQL database table. Later, in the reporting layer, these tables can be joined to show all requested_items for a set of tickets.

Can you please tell me how to code the API to extract all requested_items for a time period?

Does this endpoint exist?

something like : api/v2/requested_items ??

Page 1 / 1

I understand there may be more than one requested item per ticket

As far as I understand you can only do that per ticket. So you need some cue system that checks number of request you have left and keep it under 80% of the cap for your license level.

Thanks for your response Daniel.

Reply

Join the Community

Social Login

Sign in to the Community

Social Login

Scanning file for viruses.

This file cannot be downloaded