Convert Base64 from a RestAPI JSON into a PDF

(1) Share

Report

Posted on by Gotorus

Hi there

I have a small problem which I can not solve.

I receive a document in Base64 via a REST API. According to other forum posts and instructions I found, it should be possible to convert the data to binary and then save it as a document on Sharepoint.

The flow goes through without a problem as well. Only the document (PDF) is not correct on Sharepoint and cannot be viewed. The Base64 code does not seem to have been changed to binary.

The final result is still just a Base64-Code. I tested it to transfer it to a PDF with a simple online-tool. It works and it gives the correct result.

Does anyone have an idea what this could be?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Troels 4 on at

Like (1)

Report

Re: Convert Base64 from a RestAPI JSON into a PDF

Hey Gotorus
I had a similar problem trying to attach a pdf when sending an email. I realized that the output of the Base64ToBinary function is an object in the below format (which seems to be the way Power Automate represents binary data):

{
  "$content-type": "application/octet-stream",
  "$content": <the base64-string>
}

So since the SharePoint action is expecting a binary-type object for "File Content", I think the issue is that the output of the "Base64ToBinary Label" action is not in the same format as above but rather something like this:

{
  "$content-type": "application/pdf",
  "$content": {
"$content-type": "application/octet-stream",
"$content": <the base64-string>
}
}

Try to use just the base64-string for the "$content" of the "Base64ToBinary Label" action:
{
  "$content-type": "application/pdf",
  "$content": outputs('Compose_Label_Base64')
}

Was this reply helpful? Yes No
Verified answer

Gotorus 18 on at

Like (0)

Report

Re: Convert Base64 from a RestAPI JSON into a PDF

Hey Troels
Thanks for your answer!
I tried this, but it was not a different result.
But I found the problem. It was very simple. I had to remove the "- and []-characters. Then it worked.

Was this reply helpful? Yes No
LSB 33 on at

Like (0)

Report

Convert Base64 from a RestAPI JSON into a PDF

What exactly do you mean? You deleted every - and [] in the base64 stream before you gave it to the compose node?

Can you provide me with a screenshot of your working flow?

Was this reply helpful? Yes No