Quick Base API Accessed from Google Apps Script

  • 1
  • 1
  • Question
  • Updated 11 months ago
  • In Progress
Before I go reinventing the wheel, has anyone created an "SDK" or library to access the Quick Base API from Google Apps Script?  Or does anyone have any tips on doing so?

I took the Quick Base JavaScript "SDK" as a starting point, but it assumes it's running client-side, so lots of issues.  BTW, there's no way to use jQuery in a Google Apps Script when it's only a server-side solution, already looked in to that approach.

Why do I want to use Google Apps Script you ask?  I'm looking at methods of integrating another system with Quick Base that POSTs to a URL I can specify to pass along data periodically.  (Not that it matters, but the data comes as JSON from this other system.)  Using Google Apps Script is to avoid the use of a PHP script running on a server.
Photo of joe.acunzo

joe.acunzo, Champion

  • 210 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of Carlos

Carlos

  • 796 Points 500 badge 2x thumb
Hi Joe,
I've successfully used GoogleScripts to automate a bunch of tasks, but mainly repeating what had already been described by Kirk in this video.

You can use variables in GScript as parameters for what you need and with that build the url to execure the API. Also, use a usertoken instead of apptoken (with the necessary precautions of keeping the script away from mischievous hands. 

I'm currently in the process of understanding how to run an API_DoQuery and loop the <records>. It would greatly simplify sending reminders to customers. No luck on this yet though.
 
Photo of joe.acunzo

joe.acunzo, Champion

  • 210 Points 100 badge 2x thumb
Thanks Carlos for your reply.  I figured it all out using various GAS objects and methods, such as UrlFetchApp.fetch().  Contact me directly if you need some help at joe.acunzo @ SoftTechExperts.com.