Selecting and Defining the Data Connector File Source

Several connectors including JSON, SVG, Text, XML, and Streams Simulator, allow selection from a File, Web URL, or Text source.

Follow the steps below to select and define the file source for the connector you are using.

Select the connector file source.

File

You can either:

Upload a data source snapshot by clicking Upload File then Browse to browse to the file source.
After selecting the file, it is displayed with the timestamp of the snapshot.

The data source is placed in the repository and locked, synchronized, and bundled with the workbook version.

To change the data source, click then Browse to browse to a new version of the file, which is uploaded into the repository, and create a new version of the workbook that reads it.
Link to a data source file by clicking Link to File and entering a File Path.
The supported file types for the connector are displayed as guide (e.g., for the Text connector they are .CSV, .TXT, and .TSV).

Ensure that in a cluster, you need to use a shared path or put it on every node and use a path that resolves on every node. You can update its contents whenever you want.

NOTE:
- An error notification displays upon fetching sheets/column generation when the File Path is blank.
  
  Click Close and enter the file path.
- Upload File and Link to File options are not available on the SVG and Stream Simulator connectors.

Text

Then enter the text block to be parsed.

NOTE:

In the Text connector, the column names can be up to 128 characters. If the length of the column names are more than 128 characters, they are truncated to 128 characters.
An error notification displays upon column generation when the Text box is blank.

Click Close and enter the text block.

Web URL

The dialog changes to allow specification of the following:

Property	Description
Authentication Type	Basic Basic authentication. OAuth Then enter the following settings: Token URL – The URL to retrieve the access token from. Token Request Body – The request body used for access token requests. 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. Request Headers - A header is automatically added to the REST API request. 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. 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. NOTES: The given request body is posted to the Token URL as application/x-www-form-urlencoded, so request body must be formatted like field1=value1&field2=value2, e.g., client_id=xxxx&client_secret=xxxx&grant_type=client_credentials Not available in the Streams Simulator connector. If you have a pre-generated API token for the service you connect to and want to use the Bearer Authentication (Token Authentication), select the Authentication Type Basic, and manually type into the Headers field: Authorization="Bearer xxxxyz_some_secret_token" Leave the User Id and Password fields blank. The API token in the Headers field can be a Panopticon parameter reference, and the API token can be saved as a global server parameter.
Path	The absolute path including the HTTP where the file is located.
Proxy Server URI	The HTTP Proxy setting that will allow the connector to reach the endpoint. Headers are separated by a comma. Each Header is entered as Name = Value, where Name and Value can be enclosed in double quotes to allow inclusion of any character except for double quotes. Name and Value can also be left unquoted, in which case they may not include comma or equals characters.
Content Encoding	Select the Content Encoding with the HTTP Header: None, GZip, Deflate, or GZip and Deflate
User Id	The user Id that will be used to connect to the connector’s service.
Password	The password to connect to the connector’s service. Select the Show Characters checkbox to display the entered characters.
HTTP Method	Select the appropriate HTTP method for the request from the following options: GET – To retrieve data. POST – To add new data. PUT – To replace existing data. DELETE – To remove existing data.
Timeout	The length of time to wait for the server response (10 to 300). Default is 10.
Request Body	The Request Body for the HTTP POST.
Content Type	The required Content Type. Default is application/x-www-form-urlencoded
Record Path	The record path that will be queried by the connector’s path (e.g., myroot.items.item).

NOTE: An error notification displays upon column generation when the Path is blank.

Click Close and enter the web path.

Intellectual Property Rights Notice | Technical Support