Chart Update API

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.