JDBC Driver for Xero WorkflowMax

Build 22.0.8462

IncludeCustomFields

Determines if Custom Fields should be included as table columns or not. Including CustomFields will impact the performance.

Data Type

string

Default Value

"false"

Remarks

It is possible to create custom fields in Xero WorkflowMax. To retrieve their values you can set IncludeCustomFields=true as a connection property. Doing so will list the custom fields created as table columns. These custom fields can also be updated for ex.

UPDATE Costs SET CF_1='new CF value' WHERE ID='CostID'
Note: You can still update custom fields even when a specific table doesn't support UPDATE operation.

Custom Fields are very expensive. They require one request per record to retrieve. For this reason, they are disabled by default.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462