Connector for Web Data
The Web Data connector allows the retrieval and processing of JSON, delimited Text (such as CSV, TSV), and XML data that is accessible over HTTP/HTTPS.
Steps:
1. Enter the absolute URL of the web data including scheme (HTTP/HTTPS) into the URL field.
2. Click
. A successful connection will result
to the following:
· The Connection Successful status is displayed along with some raw data returned by the server.
· Connector tries auto discovery of the Data Type.
You can also opt to load or save a copy of the column definition.
3. Adjust the Authentication Type, if required.
3.1. Select the Authorization tab.
3.2. Set the required settings:
Authentication Type |
Description |
None |
No authentication needed. |
Basic |
Enter the User ID and Password to connect to the connector’s service. Select the Show Characters box to display the entered characters. |
OAuth |
Some standard OAuth token request parameters come initialized with empty values. You can set these values and also add/remove any/all of the keys. Enter or select the following settings: · Token URL – The URL to retrieve the access token from. · Add Access Token To - The Access token retrieved from the Token URL can be added to headers, URL or request body, depending on how the endpoint needs the token. o Request Headers - A header is automatically added to the REST API request. o Request URL - The URL needs to be manually parameterised with a {access_token} parameter, before calling the REST API, the parameter is replaced with the actual token. o Request Body - The Request Body needs to be manually parameterised with a {access_token} parameter, before calling the REST API, the parameter is replaced with the actual token. NOTE: The given request parameters key/value pairs are formatted by the connector as application/xwww-form-urlencoded, and posted to Token URL. |
Bearer Token |
If you already have a authentication token, enter the token string into Bearer Token input box. This can be parameterized also. |
4. The Headers tab allows you to enter any custom headers required to be passed to the URL endpoint, typically to provide additional metadata. Enter any key/value pairs you need, and the connector will send them along with request.
5. Set the Body, if a POST/PUT request is required.
5.1. Select the Body tab.
5.2. Set the required settings:
Property |
Description |
HTTP Method |
Select the appropriate HTTP method for the request from the following options: · POST – add new data · PUT – replace existing data |
Content Type |
Select or enter content-type based on request body (payload) format. |
Request Body |
The Request Body for the HTTP POST method. |
6. Set the Advanced settings, if needed.
6.1. Select the Advanced tab.
6.2. Set the required settings:
Property |
Description |
Proxy Server URI |
The HTTP Proxy setting that will allow the connector to reach the endpoint. |
Content Encoding |
Select the Content Encoding with the HTTP Header: None, GZip, Deflate, or GZip and Deflate |
Timeout |
The length of time to wait for the server response (10 to 300). Default is 10. |
Decimal Separator |
Select either the dot (.) or comma (,) as the decimal separator. |
6.3. You can opt to define the Show in Timezone and Source Timezone settings.