SSIS Components for Zoho Projects

Build 26.0.9770

IssueCustomFields

Gets all the custom fields for issues.

Select

Columns that support the = operator:
  • IsDefault
  • IsMandatory
  • IsRenamed
  • IsUnassociated
  • IsAssociationInfoNeeded
  • IsFormulaBasedList
  • LayoutId
  • ProjectId
  • FieldIds
  • Fields
  • SearchTerm

For example, the following query is processed server side:
SELECT * FROM IssueCustomFields WHERE ProjectId = '12345600000123' 

Columns

Name Type Description
Id [KEY] Long Unique custom field identifier..
FieldName String Name of the custom field.
DisplayName String Custom Field Display Name.
FieldType String Custom Field Type.
FieldPropertyIsEncrypted Boolean Specifies if the custom field is encrypted.
FieldPropertyIsPii Boolean Specifies if the custom field contains Personally Identifiable Information.
FieldPropertyScope String Additional properties specific to the field type.
IsDefault Boolean Indicates if the field is a default field.
IsDeactivated Boolean Indicates if the custom Field is Deactivated.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
IsMandatory Boolean Specify whether the field must be filled before saving a record.
IsRenamed Boolean Specify whether to retrieve fields whose display name has been modified.
IsUnassociated Boolean Specify whether to retrieve fields not associated with any layout.
IsAssociationInfoNeeded Boolean Specify whether to include layout association details for each field.
IsFormulaBasedList Boolean Specify whether to retrieve fields eligible for use in formula fields.
LayoutId Long Layout Id.
ProjectId Long Project Id.
FieldIds String Array of field IDs.
Fields String Array of field API names.
SearchTerm String Keyword to search fields by name.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770