File and image columns and associated messages

[jordimontana82]

Background info:

• https://learn.microsoft.com/en-us/power-apps/developer/data-platform/files-images-overview?tabs=sdk
• https://learn.microsoft.com/en-us/power-apps/developer/data-platform/file-column-data?tabs=sdk
• https://learn.microsoft.com/en-us/power-apps/developer/data-platform/image-column-data?tabs=sdk

Sample code:

• https://learn.microsoft.com/en-us/power-apps/developer/data-platform/org-service/samples/file-operations
• https://github.com/microsoft/PowerApps-Samples/blob/master/dataverse/orgsvc/C%23-NETCore/FileOperations/Program.cs

Tasks:

• [x] Add default FileStorageSettings, set MaxSizeInKB for both Files and Image columns
• [x] Validate missing EntityReference when trying to upload a file
• [x] Validate commit of file blocks exceeding max size
• [x] Add internal operations to support Initializing file blocks, uploading of blocks, and committing of file blocks.
• [x] Add FileAttachment record when commiting a file and update Target record file attributes
• [x] Basic query operations to retrieve file id and use of reserved table FileAttachment
• [x] Add internal operations to support Downloads: InitDownloads, DownloadBlocks
• [x] Upload Messages: InitializeFileBlocksUpload, UploadBlock, CommitFileBlocksUpload
• [x] Download Messages: InitializeFileBlocksDownload, DownloadBlock
• [x] Add internal method of File deletion
• [x] Delete file when setting file attribute to null
• [x] Delete file when using DeleteFile message
• [x] Add method to quickly InitializeFiles (InitializeFiles(...))
• [x] Delete associated file(s) when deleting a record
• [x] Blocked Attachments by either extension or MIME type: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/files-images-overview?tabs=sdk#block-certain-types-of-files

Image specific behaviour:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/image-column-data?tabs=sdk#image-file-types

Same messages for Upload / Download can be used for images, with the below considerations

• [ ] Images: DeleteFile is not supported for Images
• [ ] InitializeDownload and DownloadBlock will fail if the ImageAttributeMetadata has CanStoreFullImage to false (only supported if True)
• [ ] Images: When retrieving Image data via .Retrieve, only the thumbnail is retrieved, the full image needs a separate download.
• [ ] Images won't be retrieved if ColumnSet.All is used, they need to be queried explicitly.
• [ ] Only one PrimaryImage can be set on create at the same time.
• [ ] Images: If CanStoreFullImage in metadata is set to true when uploading images, then images are stored like normal files.
• [ ] Images: with files, any file extension that is not blocked it's allowed, but with Images, only these file formats are supported: gif, jpeg, tiff, bmp, & png (fixed list not configurable via Organization)

Images: Special behaviour, columns have extra added internal columns: imageId, URL, and timestamp.

• [ ] Make the assumption the imageId is the fileId
• [ ] Timestamp will be generated automatically on add / update
• [ ] URL is relative url with the following format:

/Image/download.aspx?Entity=<entity logical name>&Attribute=<image column logical name>&Id=<image id value>&Timestamp=<time stamp value>