REST
The REST connector is an object that is used to get data that provide various REST services.
After adding the connector to the ETL task working area, set basic properties and import options. The connector output can also be edited and data filtering options can be set.
To work with REST service via HTTPS protocol, use a security certificate in the PEM format:
In Linux OS execute one of the operations:
Add certificate contents to the file /etc/ssl/certs/ca-certificates.crt.
Add a certificate with the *.pem extension to the /etc/ssl/certs folder.
In Windows OS:
Start the Microsoft Management Console built-in utility.
Add the certificate to the Trusted Root Certification Authorities > Certificate folder.
Import Options
The Import Options page enables the user to specify parameters for connection to REST service and a query, according to which data is obtained:
Use the URL box to specify URL of the REST service that gives data (the current implementation enables connection to REST services that give data only in the JSON and XML formats).
NOTE. Only files with UTF-8 encoding are supported.
If user authentication is required to connect to REST service, select the Authentication checkbox and select user check method. Specify user credentials in the User Name and Password boxes. The specified parameters are passed to the core, appropriately processed and used on connection to REST service.
IMPORTANT. If Internet connection is required to access REST service, and it is established via proxy server, first, specify proxy server address in repository parameters.
Select a format to get data from REST service in the Response Format list. Depending on the selected format, determine additional settings:
JSON. Specify the query in the JSONPath Query box, according to which imported data is selected.
XML. In the Format box select how data storage is organized in the XML file (data fields are presented as node attributes or child nodes). Specify the query in the XPath Query box, according to which imported data is selected.
NOTE. When creating various queries take into account the specified data type. Implicit type conversion is not supported. For details on how to create JSONPath or XPath queries see additional guides, such as MSDN.
To determine settings that are used on identifying data, click the Advanced Settings button.
To view first hundred records selected by query, click the View Data button.
Edit Output
The Edit Output page enables the user to set links to the consumer object, to which data on executing ETL tasks is loaded.
NOTE. The page is common to all data connectors and transformers, except for the Split and User Algorithm transformers. Consider setting up a list of fields and output links using the example of the Repository data source editing wizard.
The following settings are available on the page:
Identifier
Up and 
Down buttons.Filtering
On the Filtering page specify the condition, according to which the imported data will be selected.
NOTE. The page is common to all data provider connectors, except for the User Provider connector. Consider setting up data provider filtering using the example of the Repository data provider editing wizard.
To create a filtering condition, click the 
Browse button. The expression editor dialog box opens. All provider fields can be used to create an expression. The data that satisfies the specified condition is imported.