REST API Transformation In SAS DI Studio

[AnandsinhSindha]

Hello Team.

SAS DI Version:9.4

Problem :- I want to fetch data from the REST API with post method in sas di studio(Using REST API Transformation).

I check the API with third party software like postman.its working fine.

we also tried with sas code (proc htttp)  and it was giving corrrect output.

But we are not able to do this activity with REST API transformation in  sas di studio.

Actually the client requirment is create a SAS DI ETL and use the REST API transformation and fetch the data.Then schedule this ETL.

I am working on sas di studio from last few month and i have good hands on it.But i never use the REST API transformation.

So can you please suggest me some document or blog which are related to the REST API Transformation.

[LinusH]

Assuming you already have consulted the documentation:https://documentation.sas.com/?docsetId=etlug&docsetTarget=p1fdvid6xvcmyin1xen12huf3llt.htm&docsetVe...

What happens?

This is a transformation that use SAS macro code, so try to seem what actual code is being executed (MPRINT).

Whna trying PROC HTTP, are you subitting it in the same Worskspace Server as DI?