Data upload

REST API upload requests post data or metadata in CSV or JSON format to a specific data source within your AVEVA Insight solution.

Upload requests use a POST method and this upload endpoint URL:

https://online.wonderware.[DOMAINSUFFIX]/apis/upload/datasource/

The request is sent using token authentication. Both the upload token for the target data source and upload endpoint are listed on the Upload to <name> data source dialog box for that data source.

Note: When specifying a tag, upload requests always use a TagName. By contrast, retrieval requests use the fully qualified name (FQN) of datasource.tagname.

For more details, see Upload data using token authentication.

File formats

CSV and JSON data and metadata files must be in a predefined format. For more information, see:

• File format for CSV/JSON metadata

• File format for CSV/JSON data

Note: The AVEVA Insight interface also allows a drag-and-drop method for uploading CSV/JSON data and metadata. For details, see Drag and drop CSV/JSON files.

Authentication for data upload

Data upload requests use token authentication. With this authentication method, solution specifics are in the token itself and not in the endpoint.

See Upload endpoint and token for details about acquiring the unique upload token and endpoint for your solution.

Optional headers

You may opt to use the following headers as appropriate:

• Overwrite set to True

  When you upload data using the Data Source page to drag and drop a data file, Wonderware Online automatically sets overwrite to True. When using the data upload endpoint directly, you can add an "Overwrite" header with the value set to "True".

  For example:

  

• StorageMode set to Forced

  When you upload data using the Data Source page to drag and drop a data file, Wonderware Online automatically sets StorageMode to Delta. When using the data upload endpoint directly, you can add an "StorageMode" header with the value set to "Forced".

  When StorageMode=Delta, only changed values are stored. This is the default.

  When StorageMode=Forced, all values provided, including duplicates and non-changed values, are stored.