Chart Update API
      Back to home
      1. Help Center
      2. Developer Documentation
      3. 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.