Ways to extract data from ServiceNow

MMKK
Tera Expert

Hi All,

Please tell me all the possible ways to extract data from Service Now for another application.

REST API,

Scheduled Job to extract csv and send email etc......

 

I have no clue on Midserver but if there is any option, please let me know

5 REPLIES 5

Raf1
Tera Guru

ServiceNow provides a number of interfaces to be able to directly integrate with the platform. These interfaces are considered part of the platform and are provided at no additional charge.

More info on this link.

 

Regards,

Raf

DirkRedeker
Mega Sage
Hi Can you give us a bit more details about what you are looking for? If you just want to get an overview, I recommend reading the docs online. If you have a more concrete requirement, just let us know and we can make better proposals, and help you direct towards your goals. Thanks BR Dirk

Pooja Devkar
Mega Guru

Hello,

You can use any of the following:

JSON Web Service

SOAP Webservice

CSV Web Service

EXCEL Web Service

XML Web Service

RSS Feed Generator

ODBC Driver   (Direct Database Connection)

It seems as though each of these is limited to 10,000 rows or 100,000 aggregated rows by default, possibly with a configurable property on each.   If this is the case, you could get around this programmatically by ordering by the sys_id and collecting in batched increments.

Please let me know if this helps or if you need additional assistance.

Still you have any queries then feel free to ask.

Please mark correct & helpful; if it's useful to you.

Thanks & Regards,

Pooja Devkar

Ashvini Kadus1
Kilo Guru

Hello,

->There are a variety of ways for administrators and users to export data.

Form export
Export an individual record from the user interface. Choose PDF or XML format directly from a form.
List export
Export multiple records from the user interface. Choose CSV, Excel, PDF, or XML format directly from a list.
URL export
Export multiple records from a table using the CSV, Excel, PDF, or XML processor. Specify the table form or list you want to export in the URL.
Web services
Export multiple records from a table when an external client makes a web services request. Create an external application or process to automate the retrieval of data from an instance via web services such as REST or SOAP.
Create a REST message

          Generate a REST message script preview

          SOAP web service

          Outbound SOAP web service

          Scripted SOAP web services

Export sets

Create a file called an export set that contains all the data you want to export.

->If a large amount of data needs to be queried often, and the data does not need to be real-time, perform a sync of the ServiceNow table that you're interested in with your integrating application's data store.

  • Using a scheduled job, ServiceNow can generate a csv/xml from a report and have it emailed to a specific location. The receiver might have a trigger to take the email attachment, parse it, and populate an internal table from which the application can communicate when the data is needed.

->Create application files to include sample data

 

Kindly mark correct or helpful if it helps you to solve your query.

Thank You,

Ashvini k