CustomFields
Get All Custom Fields
Table Specific Information
Select
The connector will use the Paylocity API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- category supports the '=' comparison.
In the case of simple SELECTs, the Category value will be considered as PayrollAndHR.
For example, the following queries are processed server side:
SELECT * FROM CustomFields WHERE Category = 'PayrollAndHR'
Columns
| Name | Type | References | Description |
| Category | String | The custom field category. | |
| Label | String | The custom field label. | |
| Values | String | A set of values that are applicable to the custom field. | |
| Type | String | The custom field type. | |
| IsRequired | Bool | Indicates whether the custom field is required. | |
| DefaultValue | String | Specifies the default value of the custom field. | |
| CompanyId | String | Id of the Company. |