BookmarkSubscribeRSS Feed
PatMalarkey
Obsidian | Level 7

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!

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

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

Sajid01
Meteorite | Level 14

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: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 865 views
  • 2 likes
  • 3 in conversation