SAS DI REST transformation

[cnilsen]

Hi All.

I'm recently charged with creating a job in DI Studio (v4.901) that will use a REST transformation, an API, and return a Json file with data.

I've never done anything like this before, and the web and SAS seem limited with information about how to something similar.  

I sorta understand the concept, requests and replies with the API... codes based on success or failure.

Then using a token to actually GET my data..

Does anyone know of any resources, examples (examples would be awsome) or ways to find out more?

I'm still on the green side with my programming skills.. 

Thanks!

[ChrisHemedinger]

This is not specific to DI Studio, but you can use PROC HTTP and the JSON libname engine (SAS 9.4m4) to fetch and process REST API data.

Here's a blog post to get you started.  I do this work with a number of REST APIs: Google Analytics, GitHub, Brightcove, Lithium.  If any of those are something you're working with, I can provide more concrete examples.

[cnilsen]

Hi Chris,

Thank you for the quick response. I was surprised at the lack of SAS related material and REST API's.

My initial project will be with a vendor to retrieve data quarter-hourly and parse it out into SAS datasets. This project is to 'get my feet wet' with this type of work (I've only been working with SAS tools for a few months now). My follow up project will in fact be with Google Analytics, so any examples of work would be welcomed and greatly appreciated.  

[ChrisHemedinger · Accepted solution]

When you're ready for it: Using SAS to access Google Analytics APIs

It's definitely a good idea to start with something simple though, if you can. Build your confidence! 🙂

[cnilsen]

Thank you again..
It's always good to pushed into learning something new.

[AhmedAl_Attar]

Hi,

I know this has been marked solved already, but here is a link to a SAS Global Forum Paper that mentions the DI Studio Transformation you were asking about. just in case somebody was looking for a Use Case of this particular Transformation.

http://support.sas.com/resources/papers/proceedings16/7320-2016.pdf

"Querying REST web services via a Data Integration Studio REST Transform or Proc HTTP"

Hope this helps,

Ahmed

[cnilsen]

Ahmed,

I always appreciate extra resources for any solution I am looking for. There is not always just a single way to do something, or code something. Quite honestly.. the more I am reading of this new sublect, the more additional questions I have.. I'm sure I will have additional posts regarding this.

Thank you.