ODBC Driver for QuickBooks

Build 24.0.9175

CustomFieldMode

Specifies the format used to display custom fields in the data. Choose between the traditional XML format for compatibility with older systems or the compact JSON format for modern tools and databases.

Possible Values

XML, JSON

Data Type

string

Default Value

"XML"

Remarks

This property defines how custom fields are formatted in query results, allowing you to adapt the data presentation to your application's needs. When set to XML, custom fields are displayed in an XML structure, which is suitable for legacy systems and tools that process hierarchical XML data. When set to JSON, custom fields are presented in a compact, modern JSON structure, making it ideal for applications and databases that prioritize lightweight data processing.

Selecting the appropriate format can simplify integration and improve performance in workflows that involve storage or data transformation. Choose XML for broader compatibility and JSON for more efficient handling of custom fields in contemporary environments.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175