Quick Base

Owned by Rithesh Bejjarapu (Unlicensed)
Last updated: Jan 23, 2020
1 min read

Quick Base is a Project Management tool. This integration is to import Project related data from Yale’s Quick Base Approval table to Service Now. Business use-case is to display Approval records in ‘PMO Gating Request’ Service Offering.

Quick Base API Guide

Scheduled Job : Approvals import from Quickbase : Runs daily at 22:00

Values of Quickbase Ticket, Approval Table ID, AppToken are included in System Properties and mentioned in the same Scheduled job Script.

Rest Message : Yale - Quickbase Approvals

{Query} in the GET Method filtering Active Projects

Transform Map : Yale - Quickbase Approvals Transform. (Coalescing on Approval ID)

ServiceNow Target Table : Yale Quickbase Approvals

 

Troubleshooting :

  • Check with Quickbase team whether the Service Account using for this integration is Active

  • Get a temporary Token for the Account and test it if any authentication errors

  • If there are no authentication errors, make sure properties in Scheduled Job script pointing to the correct ones. If nothing found, check the logic used in the script.