Power BI Connector for Vault CRM

Build 25.0.9454

ObjectsFields

Get all field information for the given vault object

Columns

Name Type Description
ObjectName [KEY] String (Object fields only) The related object by name, e.g., country__v.
ObjectLabel String (Object fields only) The related object by label, e.g., Country.
ObjectLabelPlural String (Object fields only) The related object by label Plural, e.g., Countries.
Name [KEY] String The API name of the field (e.g., status__c).
Label String UI-friendly string in the Vaults base language.
Editable Bool Indicates whether the field is editable. Read-only.
Type String Defines the fields data type.
Subtype String Determines the field subtype, if any.
Active Bool Indicates whether the object is active.
Order Integer Order in which the field appears by default in hovercards and object lists.
Picklist String (Picklist fields only) Defines the picklist to use for the field.
Required Bool Indicates whether the user must always enter a value.
Encrypted Bool Indicates whether the field is encrypted.
Unique Bool Indicates whether the fields value must be unique.
MaxLength Integer Maximum number of characters for the field value (applies to String/LongText/RichText).
MaxValue Integer (Number fields only) Defines the maximum numeric value for the field value.
MinValue Integer (Number fields only) Defines the minimum numeric value for the field value.
Scale Integer (Number fields only) Maximum number of decimal places.
Searchable Bool Indicates whether the field is searchable. Read-only; applies to lookup fields.
Description String Admin-only description of the field.
RelatedLocalCurrencyField String The name of the local currency code field. For example, local_currency__sys.
ShowInHeader String If set to left or right, the field is shown as an icon in the left or right of the header. Only for formula fields returning text.
SecureRelationship Bool Enables relationship security on a referenced object.
PicklistDependencies String Comma-delimited list of dependencies for the controlling picklist, e.g., {\
ShowAsIcon Bool If true, show_in_header settings are applied. Only for formula fields returning text.
RelatedCorporateCurrencyField String Contains the name of the related corporate currency field.
ControllingPicklist String The name of the controlling picklist, if any.
FormatMask String Format masks configured by Vault Admin to instruct display formatting.
HelpContent String Hover text to display for the (?) icon in Business Admin for this field.
ListColumn Bool Indicates if the field should display in default object record lists, hovercards, etc.
MultiValue Bool (Picklist fields only) Indicates if the field is multi-select.
RelationshipType String (Object fields only) Indicates the relationship type.
RelationshipOutboundName String (Object fields only) Outbound Relationship Name.
RelationshipInboundName String (Object fields only) Inbound Relationship Name.
RelationshipInboundLabel String (Object fields only) Outbound Relationship Label.
ControllingField String Controlling field name, if any.
RelationshipDeletion String (Object fields only) Deletion rules. Can be cascade only if relationship_type is parent.
RelationshipCriteria String (Object and document fields only) VQL WHERE clause that specifies criteria for the relationship.
SystemManagedName Bool Indicates if the [name] value is automatically generated by the system; field becomes read-only.
StartNumber Integer First sequence number for the system-managed name value.
ValueFormat String Format for the system-managed name value, e.g., VV-{###}.
Component String (Component fields only) The Component Type values can refer to.
RelationshipDeepCopy Bool (Object fields only) Indicates if child records via this field are available for hierarchical copy.
LookupRelationshipName String (Lookup fields only) Relationship name that a Lookup field uses.
LookupSourceField String (Lookup fields only) Field on the referenced object to display as the lookup.
DocumentVersionReference String Indicates which document version the field references (specific/latest/latest_steady_state_version).
RelatedDocumentReferenceField String Name of the related document reference field for Unbound Document Field.
NoCopy Bool When true a value will not be set in a copied record. Cannot be true when required is true.
CreateObjectInline Bool (Object fields only) If true, users can create a new reference record within an object reference field.
SequentialNaming Bool Indicates the system controls the name to be sequential.
DefaultValue String The default value of the field.
Checkbox Bool Indicates whether a Yes/No field will display as a checkbox.
Formula String The formula expression.
EnhancedBlankHandling String (Formula fields only) Blank field handling setting.
MultiPartField String Indicates whether the prefix and suffix of multi-part field is editable.
MultiPartReadonly String The read-only text of a multi-part field.
CurrencyType String (Currency subtype fields only) Indicates whether currency formula should use local or corporate currency.
PredefaultReference Bool Only on Object type fields where required=false. If true Vault pre-defaults values for this field when creating or copying records.
Rollup Bool Set to true to create a Roll-up field. The no_copy attribute must also be true.
RollupRelationshipName String Name of inbound relationship from child object providing source data for Roll-up field.
RollupFunction String Aggregate function to perform on the child object field for Roll-up field.
RollupSourceField String Name of the child object field on which to perform the rollup function.
rollupFilterCriteria String Formula expression to determine which child records are included in Roll-up calculation.
ReplicateSharingFromParent Bool Indicates if Child Object security is enabled.

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