Powered by Temper

Chart Import API

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

 

To import a chart 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.ms-excel" --output importErrors

 

Things to note:

  1. Files created in Microsoft Excel will need their content type defined as 
    type=application/vnd.ms-excel
  2. Files created in Numbers or Open Office will need their content type defined as
    type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

 

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.

 

Have more questions? Submit a request