First, I want to thank these SAS legends for their insight, innovation and customer service focus: Chris Hemedinger, Joseph Henry and Vince DelGobbo! As we all know, there are multiple ways to accomplish what we need in our SAS projects, so it is vital that we have experts like these to help us navigate options and make better choices! I am using a series of traditional techniques to collect external REST API data from external vendors for Physician Vacation planning purposes. We build a set of dynamic web pages, with this data, using PROC Stream to wrap HTML code around the JSON data returned from our REST call. One particular vendor has enhanced its REST API call to require an Auth Token and we are in the process of updating that call structure. Using cURL commands from %sysexec macros has been working perfectly for this new API as follows: The resulting xxx_auth_token.json file contains the API authorization token required for the next series of API end-point calls to collect various types of vacation data. We are now working to convert the code above for security reasons, among other necessary requirements, to PROC HTTP. However, I am unable to determine the proper sequence of PROC HTTP options required to pass the "--data-urlencode" options shown in the base cURL command structure. I have tried IN=, HEADERS and a few other macro variable methods to include those values in a URL encrypted body but I am consistently getting the following error in my output headers file: {"Message":"email and password are required"} So, bottom line, How do we encapsulate cURL options and parameters into proper PROC HTTP syntax? Thanks very much!
... View more