Attachments
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False | The unique identifier for this record. |
AttachmentOwner_Id | String | False | The Id of the attachment owner. |
AttachmentOwner_Name | String | True | The name of the attachment owner. |
ModifiedBy_Id | String | False | The Id of the User who modified the record. |
ModifiedBy_Name | String | True | The name of the User who modified the record. |
CreatedBy_Id | String | False | The Id of the User who created the record. |
CreatedBy_Name | String | True | The name of the user who created the record. |
CreatedTime | Datetime | False | The time when the record was created. |
ModifiedTime | Datetime | False | The time when the record was modified. |
FileName | String | False | The name of the file of the attachment. |
Size | String | False | The size of the attachment. |
ParentID_Id | String | False | The Id of the parent of the attachment. |
ParentID_Name | String | True | The name of the parent of the attachment. |
ModuleName | String | False | The name of the module this attachment belongs to. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Word | String | Used to search for a specific word in records. |
DuplicateCheckFields | String | The field/s to be used for checking in an upsert. |
Converted | Boolean | Set to true to return only converted records. |
Approved | Boolean | Set to true to return only approved records. |
CustomViewId | String | The custom view Id to be used for filtering this record. |
Last updated