TDV Adapter for Zoho CRM

Build 22.0.8462

CustomFieldHistoryTracking

Query information regarding different histories for a particular custom field.

Table-Specific Information

Select

The adapter uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the adapter.

  • ModuleName supports the '=' operator.
  • EntityId supports the '=' operator.
  • FieldName supports the '=' operator.
  • HistoryName supports the '=' operator.

All columns used in the criteria are required. Use FieldName to specify the actual name of the tracked custom field and HistoryName to specify the name of the history tracking section. If you want to retrieve data for a specific entity of a module specify EntityId in the criteria. For example, the following query is processed server side:

SELECT * FROM [CustomFieldHistoryTracking] WHERE ModuleName = 'Leads' AND FieldName = 'pickListField' AND HistoryName = 'Pick List 1'

SELECT * FROM [CustomFieldHistoryTracking] WHERE ModuleName = 'Leads' AND FieldName = 'pickListField' AND HistoryName = 'Pick List 1' AND EntityId = '12345665'

Columns

Name Type Description
Id [KEY] String A unique numeric identifier for the history.
ModuleName String A unique numeric identifier for the module instance this custom field tracking belongs to.
EntityId String A unique numeric identifier for the module instance this custom field tracking belongs to.
FieldName String The name of the custom field.
HistoryName String The name of the custom field tracking history.
FieldValue String The value of the custom field.
DurationDays Integer The duration of this stage.
ModifiedAt Datetime The time this historical value was last modified.
ModifiedById String The id of the user who modified the value.
ModifiedByName String The name of the user who modified the value.
CurrencySymbol String The currency symbol for the value.
ProcessFlow Boolean The boolean indicating the process flow for this historical value.
Editable Boolean The boolean indicating if this historical value can be edited.
Approved Boolean The boolean indicating if this historical value has been approved.

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