Kaonavi linked application

name
AppTemplate Kaonavi Integration for HR
business
human resources
tag
Talent Management/HR/Kaonavi
Connector used
REST Connector

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)

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)

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)

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)

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)

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

Update script for specified member fields (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)

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)

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)

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

Concatenation 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