Excel Add-In for Paylocity

Build 24.0.9060

CustomFields

Get All Custom Fields

Table Specific Information

Select

The add-in 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 add-in.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060