...
We've set up a module in ServiceNow for using authenticated QuickBase tables as a data import sources in ServiceNow. The standard HTTPS and REST modules in ServiceNow can't easily do this--they only seem to support BasicAuthbasic authentication, and the QuickBase API implements its own authentication system using an ephemeral session tokens. That means that the valid endpoint URL is periodically changing; this modification automatically maintains it for you.
...
Usage
Overview
The update set modifies ServiceNow Data Sources by adding a new data source file retrieval method labeled "QuickBase" which references exactly one "QuickBase Resource."
...
Finally, there is a scheduled job that updates the session token and URL on an hourly basis. An update to a QuickBase Resource cascades to all data sources using it.
Downloads
[note terms of LICENSE]
| Attachments | ||
|---|---|---|
|
Related Documentation
...
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. Then you proceed as you would with any data source: create a transform map, schedule the import, etc.
...
Internals
Database Modifications
- QuickBase Resource table, fields, field labels, views created
- Data Source.File retrieval method choice list modified to include "QuickBase" option
...
- both refresh tickets (one explicitly, one on a schedule). Ticket
- ticket generation and scheduled refresh is hard-coded based on for one-hour tickets.
Access Control
- QuickBase Resources only visible to admin, since there is hot data (passwords, app tokens)