How to programmatically download attachments in notes

(0) Share

Report

Posted on 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).

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Levi Stevens 50 on at

Like (0)

Report

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'.

Was this reply helpful? Yes No