ElasticFileAttachment table/entity reference

Elastic File Attachment

Messages

The following table lists the messages for the ElasticFileAttachment table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Create Event: True	POST /elasticfileattachments See Create	Create records
CreateMultiple Event: True	CreateMultiple	CreateMultipleRequest
Delete Event: True	DELETE /elasticfileattachments(elasticfileattachmentid) See Delete	Delete records
DeleteMultiple Event: True	DeleteMultiple	Learn to use messages with the SDK for .NET
Retrieve Event: True	GET /elasticfileattachments(elasticfileattachmentid) See Retrieve	Retrieve records
RetrieveEntityChanges Event: True		RetrieveEntityChangesRequest
RetrieveMultiple Event: True	GET /elasticfileattachments See Query data	Query data
Update Event: True	PATCH /elasticfileattachments(elasticfileattachmentid) See Update	Update records
UpdateMultiple Event: True	UpdateMultiple	UpdateMultipleRequest
Upsert Event: True	PATCH /elasticfileattachments(elasticfileattachmentid) See Upsert a table row	UpsertRequest
UpsertMultiple Event: True	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the ElasticFileAttachment table.

Property	Value
DisplayName	ElasticFileAttachment
DisplayCollectionName	ElasticFileAttachments
SchemaName	ElasticFileAttachment
CollectionSchemaName	ElasticFileAttachments
EntitySetName	elasticfileattachments
LogicalName	elasticfileattachment
LogicalCollectionName	elasticfileattachments
PrimaryIdAttribute	elasticfileattachmentid
PrimaryNameAttribute	filename
TableType	Elastic
OwnershipType	None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• ElasticFileAttachmentId
• FileName
• ImportSequenceNumber
• MimeType
• ObjectId
• ObjectIdTypeCode
• ObjectTypeCode
• OverriddenCreatedOn
• PartitionId
• RegardingFieldName
• TTLInSeconds

ElasticFileAttachmentId

Property	Value
Description	Unique identifier of the elastic file attachment.
DisplayName	ElasticFileAttachmentId
IsValidForForm	False
IsValidForRead	True
LogicalName	elasticfileattachmentid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

FileName

Property	Value
Description	File name of the attachment.
DisplayName	File Name
IsValidForForm	False
IsValidForRead	True
LogicalName	filename
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	255

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	importsequencenumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

MimeType

Property	Value
Description	MIME type of the attachment.
DisplayName	MIME Type
IsValidForForm	False
IsValidForRead	True
LogicalName	mimetype
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

ObjectId

Property	Value
Description	Unique identifier of the object with which the attachment is associated.
DisplayName	Regarding
IsValidForForm	False
IsValidForRead	True
LogicalName	objectid
RequiredLevel	None
Type	Lookup
Targets	componentversionnrddatasource

ObjectIdTypeCode

Property	Value
Description	Type of entity with which the elastic file attachment is associated.
DisplayName	Object Id Type Code
IsValidForForm	False
IsValidForRead	True
LogicalName	objectidtypecode
RequiredLevel	None
Type	EntityName

ObjectTypeCode

Property	Value
Description	Type of entity with which the elastic file attachment is associated.
DisplayName	Object Type
IsValidForForm	False
IsValidForRead	True
LogicalName	objecttypecode
RequiredLevel	None
Type	EntityName

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

PartitionId

Property	Value
Description	Logical partition id. A logical partition consists of a set of records with same partition id.
DisplayName	Partition Id
IsValidForForm	True
IsValidForRead	True
LogicalName	partitionid
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

RegardingFieldName

Property	Value
Description	Regarding attribute schema name of the attachment.
DisplayName	Regarding Attribute Schema Name
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingfieldname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	255

TTLInSeconds

Property	Value
Description	Time to live in seconds.
DisplayName	Time to live
IsValidForForm	True
IsValidForRead	True
LogicalName	ttlinseconds
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

• CreatedOn
• FilePointer
• FileSizeInBytes
• Prefix
• StoragePointer
• VersionNumber

CreatedOn

Property	Value
Description	Date and time when the attachment was created.
DisplayName	Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

FilePointer

Property	Value
Description	File pointer of the attachment.
DisplayName	File Pointer
IsValidForForm	False
IsValidForRead	False
LogicalName	filepointer
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	255

FileSizeInBytes

Property	Value
Description	File size of the attachment in bytes.
DisplayName	File Size (Bytes)
IsValidForForm	False
IsValidForRead	True
LogicalName	filesizeinbytes
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Prefix

Property	Value
Description	Prefix of the file pointer in blob storage.
DisplayName	Prefix
IsValidForForm	False
IsValidForRead	False
LogicalName	prefix
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	10

StoragePointer

Property	Value
Description	Storage pointer.
DisplayName	Storage Pointer
IsValidForForm	False
IsValidForRead	False
LogicalName	storagepointer
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	10

VersionNumber

Property	Value
Description	Version number of the file attachment.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

componentversionnrddatasource_ElasticFileAttachments

One-To-Many Relationship: componentversionnrddatasource componentversionnrddatasource_ElasticFileAttachments

Property	Value
ReferencedEntity	componentversionnrddatasource
ReferencedAttribute	componentversionnrddatasourceid
ReferencingAttribute	objectid
ReferencingEntityNavigationPropertyName	objectid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

ElasticFileAttachment_componentversionnrddatasource_Payload

Many-To-One Relationship: componentversionnrddatasource ElasticFileAttachment_componentversionnrddatasource_Payload

Property	Value
ReferencingEntity	componentversionnrddatasource
ReferencingAttribute	payload
ReferencedEntityNavigationPropertyName	ElasticFileAttachment_componentversionnrddatasource_Payload
IsCustomizable	False
AssociatedMenuConfiguration	AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
elasticfileattachment