- Help Center
- Developer Documentation
- Chart Update API
-
Getting Started
-
Boards & Cards
-
Item Workflow
-
Charts
-
Item Lists
-
People
-
Reports
-
Admin
- Users > User Management
- Users > Titles
- Users > Positions
- Users > Employment Statuses
- Users > Certifications
- System > General
- System > Timeline
- System > Login Notices
- System > Tooltip Customization
- System > API Keys
- Organization > Network
- Organization > Level Types
- Organization > Roles
- Organization > Time Savings People
- Organization > Standard Work
- Organization > Weighted Scores
- Organization > Fields
- Organization > Attributes
- Organization > Multi Chart Importer
-
KaiNexus Updates
-
Additional Modules
-
The KaiNexus Mobile App
-
Developer Documentation
-
Lean Strategy
-
Customization
-
Solve Problems
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. |