Call a QuickBase API within a Pipeline

Question

Has anyone successfully called any generic QuickBase API within a Pipeline Step?
I'm trying to execute this URL using the Make a Request step under the Webhook Channel

https://mycompany.quickbase.com/db/xxxxxxx?a=API_GenResultsTable&qid=1&csv=1

But I keep getting the response back of an Authentication failure. I have supplied my Quick Base userid and password and guessed that HTTP Basic is the Authentication method to use.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

AustinK · Answer

I know this is a simple thing but are you supplying the app token in the URL? Since it looks like your whole call is in the URL it may not work to put the app token in the body of the request in this case. So maybe we have to make a choice here. Either do everything via the URL or do it all in the body of the webhook.

I just tested this with AddRecord and the only way it worked was if I supplied the app token and user token in the body of the request. When I tried using my username and password in the Pipeline it always said there was an error and I needed to sign in.

What I have to do is set it up exactly as I would a webhook. So that means the URL I am calling is mycompany.quickbase.com/db/DBID and then you add the request headers which are "QUICKBASE-ACTION" and "API_AddRecord" near the bottom of the webhook.

All the fields above the part of my screenshot are blank. Hopefully this is helpful for you but I know I didn't do the same api call as you did in my screenshot but i DID test GenResultsTable and was able to get a return via the same method.

Here is the screenshot for GenResultsTable which as I said did give me a result.

Sign up

Login to the community