ContentDocumentLink
Links Content Documents to multiple records, allowing files to be associated with various objects.
Table Specific Information
Select
The Salesforce provider requires filtering on Id, ContentDocumentId, or LinkedEntityId to perform the query.
Either of the following operators can be used when creating a filter or WHERE clause. For example:
SELECT * FROM ContentDocumentLink WHERE Id = 'your value' SELECT * FROM ContentDocumentLink WHERE ContentDocumentId = 'your value' SELECT * FROM ContentDocumentLink WHERE LinkedEntityId = 'your value'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the content document link record. | |
| LinkedEntityId | String | False |
ID of the record (such as a user, group, or object) the content document is linked to. | |
| LinkedEntityIdType | String | False |
Specifies the type of the 'LinkedEntityId' polymorphic field to use in the statement. | |
| LinkedEntityIdExternalFieldName | String | False |
Specifies the external field name of the 'LinkedEntityId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| ContentDocumentId | String | False |
ID of the content document associated with this link. | |
| IsDeleted | Bool | True |
Indicates whether the link record has been deleted (true) or not (false). | |
| ShareType | String | False |
Level of access granted to the linked entity. For example, 'V' for viewer, 'C' for collaborator, or 'I' for inferred permission. | |
| Visibility | String | False |
Field containing Visibility information. | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
Date and time when the link record was last modified. |