Chart Update API

XLSX Multi Chart Update API

KaiNexus 2.4.0 adds support for the importing of Chart data in Excel format.

To import a chart as .xlsx, use the URL:

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

 

See The API module for more information on how to configure API Keys.

 

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

 

NOTE: Files need to be in .xlxs format.

 

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.