- 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 > Goals
- Organization > Time Savings People
- Organization > Standard Work
- Organization > Weighted Scores
- Organization > Workflows
- Organization > Templates
- Organization > Fields
- Organization > Attributes
- Organization > Multi Chart Importer
- Other
-
KaiNexus Updates
-
Additional Modules
-
The KaiNexus Mobile App
-
Developer Documentation
-
Lean Strategy
-
Customization
-
Solve Problems
-
KaiNexus Internal
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. |