Skip to main content

How to pull custom fields from a table via API 

  • March 15, 2023
  • 0 replies
  • 163 views

Firstly, you will be required to run a first call to get the ID of the field using this call 

Once you have the output you can copy this and paste the output into a document such as notes for you to search using the hotkeys such as on Mac Command + F or on Windows CTRL + F. 

Search for Department Dimension and you will see something such as this in the output: 

id": "payroll.salary.customColumns.column_1673626992217", 

"category": "payroll", 

"name": "Department Dimension", 

"description": null, 

"jsonPath": "payroll.salary.customColumns.column_1673626992217", 

"type": "list", 

"typeData": { 

"listId": "payroll.salary.column_1673626992217" 

}, 

"historical": true 

The ID is what we will need here: id": "payroll.salary.customColumns.column_1673626992217", 

Then when you use this call once again copy the output place it into a document then search again using the last half of the ID that we took from the previous call column_1673626992217 which will allow you to find the department dimension field information which will look similar to this depending on the information you hold in the list of that field, for my example I used Test one: 

"displayName": "Chris", 

"payroll": { 

"timeSinceLastSalaryChange": "1 day", 

"salary": { 

"monthlyPayment": "£00", 

"payPeriod": "Daily", 

"customColumns": { 

"column_1673626992217": "test one". < this is the department dimension field on my demo.