Forum Discussion

GeorgeRomanows1's avatar
GeorgeRomanows1
Qrew Member
3 years ago

API Connection from SAS to Quickbase-Connection failed

Anybody have experience connecting to a Quickbase app from SAS.

I am using a PROC HTTP function following the SAS and Quickbase API documentation.

However, my API connection is timing out.  I am getting the following errors.

Is something I need to check for on the Quickbase side?

ERROR: Error connecting to 104.18.101.99:443. (The connection has timed out.)
ERROR: Error connecting to 104.18.100.99:443. (The connection has timed out.)
ERROR: Unable to establish connection to mycompany.quickbase.com.

ERROR: Unable to connect to Web server.


Here is my sas code with user token masked.

proc http
url=%NRSTR("https://mycompany.quickbase.com/db/mytableid?a=API_DoQuery&query={6.EX.'01-26-2022'}&usertoken=xxxxxxxxxxxxxxxxxxxxxxxxxx")
headerout=headers
out=response
HTTP_TOKENAUTH;
run;

------------------------------
George Romanowski
------------------------------
  • Did you solve this somehow? I'm having a similar connection issue.



    ------------------------------
    Daniel Johnson
    ------------------------------