Insert PDF file in image field of custom entity record using Microsoft Flow

(0) Share

Report

Posted on by ExpertNovice

Requirement Background,

> Have invoice file (PDF) visible/downloadable for Customer portal users.

> Customer portal users are managed by Dynamics CRM online.

> So we have a MS flow to read the PDF files from an SFTP location and post it into respective folder path Sharepoint.

> But the CRM wasn't able to access that file path in Sharepoint and also we weren't able to figure the impersonation needed for the CRM user to fetch from Sharepoint.

What we are trying to do now is...

> To have MS flow write to Sharepoint as well as insert a record in Dynamics CRM Online custom entity having the file in binary format.

Problem,

The SFTP output body is not accepted as a valid input to the binary (Image) field in the CRM.

We tried Base64ToBinary, simply mapping the SFTP body/content to the field, etc. etc.

Nothing works and we keep getting 400, BadRequest, Invalid Argument errors.

Please help.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: Insert PDF file in image field of custom entity record using Microsoft Flow

Hi,

You can try uploading it to a note record for the custom entity. Notes has the document body field which accepts byte array.

docs.microsoft.com/.../sample-upload-retrieve-download-attachment

Hope this helps.