topic Re: SAS DI REST transformation in SAS Data Management

SAS DI REST transformation

cnilsen — Mon, 08 May 2017 16:09:41 GMT

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!

Re: SAS DI REST transformation

ChrisHemedinger — Mon, 08 May 2017 17:40:07 GMT

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.

Re: SAS DI REST transformation

cnilsen — Mon, 08 May 2017 17:59:35 GMT

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.

Re: SAS DI REST transformation

ChrisHemedinger — Mon, 08 May 2017 18:54:27 GMT

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! 🙂

Re: SAS DI REST transformation

cnilsen — Mon, 08 May 2017 19:08:28 GMT

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

Re: SAS DI REST transformation

AhmedAl_Attar — Tue, 09 May 2017 20:16:52 GMT

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

Re: SAS DI REST transformation

cnilsen — Wed, 10 May 2017 12:02:33 GMT

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.