Paylocity to JSM Assets
Import list of employees from Paylocity to JSM Assets.
Configure the connection to Paylocity by going to OnLink (Manage your apps) - Connections. Then click on Add System and select “Paylocity” option in the connection screen. You can follow the instructions from this page Paylocity API.
Once connection is established, please review instructions here to get started with setting up an Assets import configuration. You can then access OnLink app from the “Manage your apps” menu to further configure and set the field level mapping. Here’s an example mapping configuration to fetch employees:
API Documentation Link https://developer.paylocity.com/integrations/reference/get_corehr-v1-companies-companyid-employees
key:id=id
map:info.firstName=First Name
map:info.lastName=Last Name
map:info.email=Email
map:info.jobTitle=Job Title
map:info.supervisor=Manager Name
map:info.hireDate=Hire DateHere’s a breakdown of some of the mapping configuration items:
Key or Map | Description |
|---|---|
| The keyword “key” refers to using id as a unique identifier. This allows OnLink to update the record. “id” is a text attribute. |
| Maps firstname to First Name text attribute |
| Maps supervisor to Manager Name text attribute |
| Use this config to pull list of employees Any fields from the API can be mapped. { |
Config | config:filter=activeOnly config:max_loops=10 config:api=costCentersAndLevels // default is employees |
You can then call “Fetch Sample” to view the structure of the API response and map the relevant fields.
OnLink processes data in two steps - Get Data and Import Data. To manually test, you can click on Get Data first and then wait until you see “No more pending records. Data will be imported on next Import run.” message in Job Logs. Then, click on Import. Production runs are fully automated based on the schedule you choose.
