Create table API and import it into excel

[imjustanintern]

Hi, I'm extremely new to this and was wondering how I can make an API link that will get me a specific reporting from a table and how I would go around importing that table into Excel. I've tried googling it but most of the explanations go right over my head. Thanks!

[Dave Smith1]

Create a filter on the list that displays just those records first.

Then append the ?&CSV suffix.

[tony_barratt · Accepted solution]

Ni Nick,

https://<instance Name>.service-now.com/incident_list.do?CSV&sysparm_query=sys_created_on%3C%3Djavas...

That should do it!

edit:

Just to add some more info - I created the sys_created_on filter in the URL above, by creating the filter on the incident list, then "copy query" - as suggested by Dave Smith

If the reply was informational, please like, mark as helpful or mark as correct!

[gyedwab]

Hi Nick,

If you're doing this for reporting purposes, you might be interested in Explore Analytics, which can run real-time reports against the data in ServiceNow, rather than requiring you to pull a flat CSV of the data on a schedule.