topic proc http: Trying to access Quickbase in SAS Procedures

proc http: Trying to access Quickbase

PatMalarkey — Mon, 21 Mar 2022 04:01:50 GMT

Wondering if anyone has tried using the Quickbase REST APIs from SAS? A co-worker and I are noodling with PROC HTTP with no luck so far.

I know I'm missing the authorization token, but the papers available have me confused as to which other parameters I need.

filename response "C:\Users\f353363\OneDrive - Freddie Mac\Section 404\NoCode\QuickBase\sasfiles\test.xml" lrecl=32000;
proc http
url="https://api.quickbase.com/v1/records/query?from=brumhp939,select=[6,7,8,10,11],where={9.EX.'623008'}"
method='GET'
out=response;
run;

ERROR: The TCP/IP tcpSockEstablishSSL() support routine failed with error 10054 (The connection was
reset by a peer.).
ERROR: The tcpSockRead call failed. The system error is 'The connection was reset by a peer.'.
ERROR: Call to tcpSockContinueSSL failed.

Any ideas are welcome! Thanks!

Re: Accessing Quickbase from SAS 9.4 (Maint 3) - Has anyone done this?

ChrisNZ — Mon, 21 Mar 2022 04:05:32 GMT

Welcome Pat!
Retitled and moved to procedures community. Hopefully you'll find an answer there.

Re: proc http: Trying to access Quickbase

Sajid01 — Fri, 25 Mar 2022 02:15:38 GMT

Hello @PatMalarkey

Your proc http code looks OK except for the missing auth_beareer="your token";
Apparently connection was established and then the remote server closed the connection.
Try running the request using some other method such as using Postman / ARC Client /Jmeter etc.
That way you can have an idea if the error is in SAS or on the remote server.