Abstract

We've set up a generalized module in ServiceNow for using authenticated QuickBase 's REST API as an integration Data Source tables as a data import sources in ServiceNow. The standard HTTPS and REST modules in ServiceNow arencan't quite sufficient, since easily do this--they only seem to support BasicAuth, while and the QuickBase API implements its own dual layer token-based authentication system using an ephemeral session token and a semi-permanent app token.

...

tokens. Basically that means that the endpoint URL is periodically changing; this modification automatically maintains it for you.

Module Use

Overview

The update set adds modifies ServiceNow Data Sources by adding a new data source file retrieval method labeled "QuickBase" which references exactly one "QuickBase Resource."

A QuickBase resource Resource is a separate new custom ServiceNow object consisting of:

• a set of credentials
• a named QB table
• an app token (optional)
• a session token (generated)
• a constructed URL (generated).

Finally, there is a scheduled job that updates the session token and URL on an hourly basis. Business rules ensure an update to a QuickBase Resource cascades to all data sources which use using it.

Downloads

...

In a real example, the ticket would be present as well. If all goes well, the URL should contain the URL Template from the QuickBase Resource you pointed to, and you should be able to test load records from QuickBase. From this point, Then you proceed as you would with any data source (: create a transform map and , schedule the import), etc.

Integration Internals

Database Modifications

...