The Korbyt ServiceNow data adapter connects to a ServiceNow report endpoint (URL) that provides an exportable CSV file that Korbyt will use to build a Data Table of usable information within Korbyt.
The Basics
The Korbyt data adapter utilizes customer-provided ServiceNow information to create an authenticated connection.
Once authenticated, the data adapter downloads the report and updates the data adapter table in Korbyt.
Data is then available for further data transformation and display on connected digital signage or desktop endpoints.
Once running, the Korbyt Data Adapter will periodically check the report endpoint in ServiceNow and bring the data into Korbyt.
ServiceNow Pre-requisites and Requirements
To function correctly certain parameters have to be set correctly in your ServiceNow system
These two articles from ServiceNow may be helpful in configuring your system.
ServiceNow Data Adapter Setup
With a Korbyt Templated Data Adapters for ServiceNow you will only need to fill in some key details
- ServiceNow Exportable Report (CSV format) URL
- This is generated by ServiceNow report builder.
- For example, the URL will be similar to this: https://<YOUR SN URL>/<report_name>.do?CSV&sysparm_query=u_status%3D0%5elocation%guid&sysparm_record_count=10&sysparm_order_by=sys_created_on&sysparm_view=export
- Data Schema from the CSV report
- Username and Password for the ServiceNow instance
- Delimiters and Escape characters set to default values in Korbyt (comma, “, \)
- Data Refresh Interval for the Korbyt data adapter
- As often as 30 seconds
- Faster intervals are possible when the real-time data add-on has been purchased
- This is the interval on how often Korbyt will connect to ServiceNow to fetch new data
- In ServiceNow you will need to configure how often ServiceNow goes through it’s processes to update the information internally
- As often as 30 seconds
- Lines to skip (if your report has a header, set to 1
- Remove missing keys (True or False)
- Set to True or False depending on if you want to preserve or remove the data when unique keys are missing from the data