Upload Keyset Data From a CSV File Using the API

This applies to: Visual Data Discovery

You can upload keyset data from a CSV file using the API. Use the POST /api/keysets/upload API endpoint to do this. The CSV file must provide the field name, file data, the file name, the keyset name, and the data source definition ID. A keyset description is optional.

You must be the owner of the keyset or be a user with the Administer Dashboards privilege.

The CSV file should be in the following format. A header should not be included.

fieldName:<field-name>
fileData: <file-information>
fileName:<CSV-file-name>
keySetName:<keyset-name>
keySetDesc:<optional-keyset-description>
sourceId:<data-source-id>

The response from this endpoint includes a unique ID for the keyset. You will need this ID if you update the keyset from a CSV file.

For more information, see your API documentation.

API documentation is provided with your Symphony installation at this link: <symphony-URL>/discovery/swagger-ui.html.