Kaonavi linked application

name
AppTemplate Kaonavi Integration for HR
business
human resources
tag
Talent Management/HR/Kaonavi
Connector used
REST Connector
Conceptual diagram of the Kaonavi integration application

The following process is performed using Kaonavi:

  • Process to register new employee information and update data
  • Process to update the specified item

This application includes:

script

  • Token Issuance Script
  • Member information list creation script
  • Item ID list creation script
  • Sheet information custom item ID list creation script
  • Member information addition and update script
  • Update script for the specified member item
  • Sheet Information Custom Field Update Script
  • CSV creation script for registering experience data
  • Experience data registration script
  • Concatenated Script

Script Details

Token issuance script (kaonavi_get_token)

Image diagram of the token issuance script (kaonavi_get_token)

Obtain an access token to use the Kaonavi API.
The acquired token is set to the script output variable [token].

Member information list creation script (kaonavi_get_members)

Image diagram of the member information list creation script (kaonavi_get_members)

Execute the member information retrieval API to create a list of information such as member codes.

Item ID list creation script (kaonavi_get_fields_list)

Image diagram of the item ID list creation script (kaonavi_get_fields_list)

Execute the member information layout retrieval API to create a list of item IDs and item names.

Sheet information custom item ID list creation script (kaonavi_get_sheets_list)

Image diagram of the sheet information custom item ID list creation script (kaonavi_get_sheets_list)

Execute the sheet information layout bulk retrieval API to create a list of "sheet name," "sheet ID," "item name," and "item ID."

Member information addition and update script (kaonavi_upsert_member)

Image diagram of the script for adding/updating member information (kaonavi_upsert_member)

Reads the input employee information CSV file and adds or updates member information.

Update script for specified member fields (kaonavi_update_custom_field)

Image diagram of the update script for the specified member field (kaonavi_update_custom_field)

Updates the specified member information item.
Set the ID of the field to be updated in the script variable [custom_field_id] and execute it.

Sheet information custom item update script (kaonavi_update_custom_sheet)

Image diagram of the update script for custom sheet information fields (kaonavi_update_custom_sheet)

Updates a custom field in the specified sheet.
Set the ID of the sheet to be updated in the script variable [sheet_id] and the ID of the custom field in the script variable [field_id], then execute.

CSV creation script for experience data registration (kaonavi_alternate_input)

Image diagram of the CSV creation script for registering experience data (kaonavi_alternate_input)

The data on the employee's experience hours for each job type is merged with the data on the Kaonavi item ID corresponding to the job type, and output as an input CSV file.

Experience data registration script (kaonavi_update_member_fluid)

Image diagram of the experience data registration script (kaonavi_update_member_fluid)

Read the CSV file created using the "CSV creation script for registering experience data" and register it in Kaonavi.

Concatenation script (kaonavi_DEMO_script)

Image diagram of the linked script (kaonavi_DEMO_script)

This allows you to do everything from obtaining Kaonavi tokens to updating seat information all at once.
This script is a sample of script linking, and other processes can be linked in the same way.

How to install and use it

»See the list of applications