XLSX Multi Chart Update API

Import one spreadsheet and update multiple Charts at once.

Making Requests

To import a chart using XLSX format, execute a PUT request to this URL:

https://api.kainexus.com/api/public/v1/excel/multiChartImport

Authentication

The username will be "api" and the password will be the API Key. See this article for information on obtaining the API Key.

If you are using Curl to make the API call, refer to the following Curl script example:

Example Curl Script:

curl -s -D - --user api:APIKEY https://api.kainexus.com/api/public/v1/excel/multiChartImport -F "file=@FILEPATH;type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" --output importErrors

Errors

All imports will return data on warnings and errors. The table below provides an explanation of the data fields returned from an import.

Field	JSON Field	Explanation
Sheet name	sheetName	Sheet the error is located on
Incorrect value	badValue	The value included on the sheet
Correct value	goodValue	The expected value
Error Message Key	message
Row	row	Row the error is located on
Column	col	Column the error is located on
Failure	failure	TRUE or FALSE. Conveys the severity of the error. TRUE errors result in the rollback of all imported changes.