GeorgeRomanows1
3 years agoQrew Member
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
------------------------------
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
------------------------------