SharePoint attributes deliver additional information on the file origin based on CRM metadata. This article outlines the purpose of the different attributes.
Figure 1: SharePoint attributes
❶ Backlink to Microsoft Dynamics 365 (CRM)
This attribute backlinks to the original item in CRM from which the attachment (email or note) has been extracted previously.
❷ Entity GUID (note/email)
means the unique type GUID of the entity’s origin.
❸ Entity type (note/email)
means the unique type name of the entity’s origin.
The CSV lists mentioned in point 4 & 5 generally refer to metadata (GUID or text) in Microsoft Dynamics 365 (CRM).
Emails and annotations consist of both, GUID-, as well as text-fields.
❹ CSV GUID-list containing metadata regarding the recipient/owner
For EMAILS, the CSV GUID list contains the following attributes:
The list contains a list of EntityReferences to CRM records. This applies to the fields from, to, cc, bcc, regardingobjectid. *The field ‘subject’ is a text field.
If a field contains multiple values, those values are separated by a pipe symbol:
Example for EMAIL (please note the empty entry for bcc):
❺ CSV text-list containing metadata regarding the recipient/owner
For NOTES, the CSV TEXT list contains the following attributes:
The CSV Text list contains a list of references to annotations. This applies to the fields subject, filename, filesize, notetext. *The field ‘objectid’ is a GUID-field.
Example for a NOTE (please note the empty entry for notetext and Object ID):
02_Quote; 02_Quote.pdf; 15447;;;
❻ Record type
This attribute provides you with information regarding the CRM record type.
Set on ‘Yes’, this attribute refers to an email or note body, set on ‘No’, it refers to an attachment.
❼ Entity date
Contains the entity’s creation date.
That’s it! We appreciate your feedback! Please share your thoughts by sending an email to firstname.lastname@example.org!