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. Main business use for this data is to display Approval records in ‘PMO Gating Request’ Service Offering.
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.