Hi All,
I am trying to get data in XML format from an API. But the data I get form this API is always in JSON format.
I confirmed with the API's developers that it can return data in both JSON and XML depending on the request
Here is the code I am using:
FILENAME QAOS "/haexample/Example_Dir/Example.xml";
PROC HTTP
URL = "http://example.cnn.com/api/Something?format=xml"
OUT = QAOS
METHOD= 'GET'
;
RUN;
What am I missing here? Please help.
Regards,
Ahmed
Get from your API developers a working sample get request (the URL) where they confirm that you get an XML back.
Most of the time you can take the API call, post it in a browser URL bar and get the response. Make sure that works first and then verify that PROC HTTP works. FYI - I used it last week so it definitely works as intended.
Another check, make sure your version of SAS supports what you're trying to do but I think PROC HTTP is pretty old. This is unlikely...but if you're not sure post your SAS version (i.e. 9.4 TS1M4)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: