How to programmatically download attachments in notes

Like (0) Share

Report

Posted on 12 Jun 2023 13:26:57 by Levi Stevens

Does anyone know how to pragmatically download attachments from Opportunity notes? I have been able to download and upload to SharePoint any EMBEDDED attachments stored in msdyn_fileblob, but if it is a direct attachment stored in annotations documentbody, it is not in the same file format. I am not familiar with how to convert this into a text/plain fileblob format I can upload to sharepoint.

Working on a script to migrate all notes to SharePoint and update opportunities with hyperlink to document (space savings).

All responses (1)

Answers (1)

Verified answer

Levi Stevens 50 on 12 Jun 2023 at 14:56:34

Like (0)

Report

RE: How to programmatically download attachments in notes

Solutions was following:

$fileblob = [System.Convert]::FromBase64String($documentbody)

$upload = Call-WebAPI -URI "$mgurl/drives/$PDR_RootID/root:/$locationurl/$($fileName):/content" -Method PUT -Accept "text/plain" -Authorization $Token2 -Body $fileblob -ContentType 'text/plain'

Using the content type 'text/plain'.