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!
Welcome Pat!
Retitled and moved to procedures community. Hopefully you'll find an answer there.
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.