Using REST to Access a Third-Party Web Service


You want a job to access a third-party web service that uses a REST interface.


Create a job that uses a REST transformation to access the web service. Representational State Transfer (REST) is a set of architectural principles for designing web services that access a system's resources. A resource is accessed with a Uniform Resource Identifier (URI). The REST transformation generates SAS HTTP procedure code to read from and write to a web service in the context of a job.
To use the REST transformation, perform the following tasks:

Verify Prerequisites

It is assumed that you are familiar with how to use the REST interface to access web services. Gather the same information that you need to use the SAS HTTP procedure to read from and write to the desired web service. Example options and values are shown in the next section. For detailed information about the SAS HTTP procedure, see the documentation for that procedure in the Base SAS Procedures Guide.

Create a Job That Uses a REST Transformation to Access a Web Service

Perform the following steps. It is assumed that you are familiar with creating SAS Data Integration Studio jobs, as described in Creating Jobs.
  1. Create an empty SAS Data Integration Studio job.
  2. In the Transformations tree of the process editor, open the Access folder.
  3. Drag the REST transformation into the empty job.
  4. Right-click the REST transformation and select Properties.
  5. Specify the options that you need to read from and write to the desired web service. See the following table for some example values.
  6. Save the job.
  7. Run the job. Review status messages to verify that the job executed without error.
The following table shows an example set of options that you can specify in the REST transformation. In this example, when you submit a request to the web service, it returns contact information in the output variable RESTGetText_Auth_UserPwd.
Example Options for the REST Transformation
Tab Selection Path
Example Values
Optionsthen selectREST Properties
HTTP Method:
HTTP request endpoint:
HTTP context-type:
HTTP charset:
Optionsthen selectInput and Output
Input type:
Input text:
Output type:
Output Text Macro Variable Name:
Optionsthen selectAuthentication
Web authentication type:
Web authentication username:
Web authentication password:
Last updated: January 16, 2018