Getting large number of rows *out* of ServiceNow: Export data via API or connector?

[dbcandle]

What is a good way to export data from ServiceNow, that does not have the row-limits of the Excel exports?

I'm a bit confused re: the API(s) and Connectors.  In the Microsoft Power Platform, for example, they have a ServiceNow Connector.  I've also seen client/server APIs, but that seems more for business-logic within an application.

What I'm looking for is a way to export a large number of rows from ServiceNow.  For small tables (e.g. 5,000 rows), I can just create a report using the Report tool, then export to Excel.  This won't work with large tables though.

I'm sort-of looking for the opposite of Transform Maps and related features that allow getting data *in* to ServiceNow.  I'm wondering what robust options allow getting data *out*.

ServiceNow will be our ITIL hub and data repository, so this question is somewhat academic, but for data-cleanup activities (for data being fed back-in via Transform Maps), I can see where it would be useful to get data out of ServiceNow, if only temporarily.  I like "options". 😁

[Bert_c1 · Accepted solution]

Using google, I found:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636

Seems you'll have to export data in chunks. Nothing I've found avoids using chunks.

[dbcandle]

Perfect!  I don't mind chunks via the API; *SO* much better than writing a report in the "Report" tool, and using the export to Excel.

Thanks!!! 😁