Transfer collected file data using HTTP

1. Place an operation that reads the data of lines added to a CSV file.

1. Drag and drop File > CSV > Monitoring of File Update from the tool palette onto the script canvas.

   

   The New Monitoring of File Update operation dialog box is displayed.

2. Configure the settings to read the values from the CSV file.

   

   Name

   Enter any value (single-byte alphanumeric characters, underscores).

   [Required settings] tab

   File name

   Specify the file name of the CSV file.

   Skip already written lines when runtime starts up

   There is no need to select this check box.

   For this example, it is assumed that the CSV file is generated upon script execution.

   Column List

   Add all the columns in the CSV file to Column Name.

   For Column Name, enter any value that represents the column.

   = Remarks =

   • Column Name is only used for display on the screen.

   • To retrieve Column Name from the first line of the CSV file, click Read column names from first line of file, and select the file.

   

   [Advanced settings] tab

   Delimiter

   Select Comma.

   Encode of file reading

   Select UTF-8.

3. Click Finish.

   The monitoring file updates operation icon is placed on the script canvas.

   

2. Place an operation that externally transfers data using HTTP.

1. Drag and drop Generic protocol > HTTP > Send from the tool palette onto the script canvas.

   

   The New Send operation dialog box is displayed.

2. Configure the settings of the REST API of the external system.

   

   Name

   Enter any value (single-byte alphanumeric characters, underscores).

   Input data

   Select the "icon name of the Monitoring operation" that you placed earlier.

   URL

   Set the "URL" for REST API.

   Method

   Set the HTTP method (POST or PUT) for REST API.

   Header

   Set the request header that is necessary to send a request to REST API.

3. Click Finish.

   The Send operation icon is placed on the script canvas.

   The Monitoring operation icon and the Send operation icon are connected by a stream flow (an orange dashed line).

   

3. Configure a Mapper.

1. Right-click the stream flow that connects the Monitoring operation to the Send operation and select Add mapping from the menu.

   Mapper is placed in between the Monitoring operation and the Send operation.

   

2. Double-click the mapping_1 icon to open the Mapper editor.

3. In Output destination, set the input schema of the Send operation.

   When the JSON format set for the request body is designated as a REST API specification, you can save that format as a JSON file and use it to generate input schemas.

   = Remarks =

   You can also configure the schema settings manually, but when the JSON format is complicated, letting the schema be read from a JSON file makes operations simpler.

   For details on how to manually configure the schema settings, refer to First Step Guide.

   Right-click the name of the Send operation icon and select Load schema from the menu.

   

   The Load schema dialog box appears.

   Select Read from JSON file.

   Specify the JSON file in File path and click Finish.

   

   A tree similar to the following is generated according to the content of the specified JSON file.

   

4. Drag and drop the following items from the input source onto the output destination:

• column_0 of Input source to temperature of Output destination

• column_1 of Input source to humidity of Output destination

5. Save the script.

For information about how to save a script, refer to First Step Guide.