SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
aomy82
Fluorite | Level 6

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

 

 

2 REPLIES 2
Patrick
Opal | Level 21

@aomy82

Get from your API developers a working sample get request (the URL) where they confirm that you get an XML back.

Reeza
Super User

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)

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 2 replies
  • 2251 views
  • 0 likes
  • 3 in conversation