SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DI REST transformation

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

SAS DI REST transformation

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!

 

 

 

 

 

 

 

- Chris N.

Accepted Solutions
Solution
‎05-08-2017 03:07 PM
Community Manager
Posts: 2,953

Re: SAS DI REST transformation

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! Smiley Happy

View solution in original post


All Replies
Community Manager
Posts: 2,953

Re: SAS DI REST transformation

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.

Contributor
Posts: 38

Re: SAS DI REST transformation

Posted in reply to ChrisHemedinger

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.  

 

- Chris N.
Solution
‎05-08-2017 03:07 PM
Community Manager
Posts: 2,953

Re: SAS DI REST transformation

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! Smiley Happy

Contributor
Posts: 38

Re: SAS DI REST transformation

Posted in reply to ChrisHemedinger
Thank you again..
It's always good to pushed into learning something new.

- Chris N.
Regular Contributor
Posts: 216

Re: SAS DI REST transformation

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

Contributor
Posts: 38

Re: SAS DI REST transformation

Posted in reply to AhmedAl_Attar

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.

 

- Chris N.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 562 views
  • 4 likes
  • 3 in conversation