Small and medium business | Business Central, N...

Convert BLOB to Base64 for use in Web Service

(0) Share

Report

Posted on by Jesse Otu

Hello, I've been trying, and failing miserably, to convert a BLOB data type to and Base64 text string in order to send it through a web service.

Here's what I tried:

A manual port of the official Base64 Convert codeunit (which is only available from BC16 or later). Available here: https://github.com/microsoft/ALAppExtensions/blob/main/Modules/System/Base64%20Convert/src/Base64ConvertImpl.Codeunit.al
This other implementation by Kauffmann: ALCodeSamples/Base64Convert at master · ajkauffmann/ALCodeSamples · GitHub

In both cases, I get this error:

I tried to set the length of the string to 2048(max value), and then it tried to assign 39,000 characters. I will appreciate any help I can get.

I'm working in BC14.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Greg Enns 1,106 on at

Like (0)

Report

RE: Convert BLOB to Base64 for use in Web Service

Did you try using the Base64 conversion functions in Codeunit 10 "Type Helper"?

There is both ConvertValueFromBase64 and ConvertValueToBase64.

Was this reply helpful? Yes No
Jesse Otu 10 on at

Like (0)

Report

RE: Convert BLOB to Base64 for use in Web Service

[quote user="Nitin Verma"]
In which line you are facing the issue, also you can avoid showing the message and direct your URL in here.
[/quote]
The issue is in the codeunits where the data type conversion is happening.

This is a link to codeunit 4110 and 4111.

github.com/.../Base64Convert

The error is thrown after the line Base64String := Convert.ToBase64String(InputArray).

This method uses the dotnet Convert subtype to run the conversion.

I hope this answers your question. The other linked codeunit uses a different implementation but still throws the exact same error.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,605 Moderator on at

Like (0)

Report

RE: Convert BLOB to Base64 for use in Web Service

In which line you are facing the issue, also you can avoid showing the message and direct your URL in here.

Was this reply helpful? Yes No
Jesse Otu 10 on at

Like (0)

Report

RE: Convert BLOB to Base64 for use in Web Service

Okay Nitin Verma here you go:

OnRun()
GetEmployeeImage3('JR');

GetEmployeeImage3(EmployeeCode : Code[20]) : Text[2048]
Employees.GET(EmployeeCode);
IF NOT Employees.Image.HASVALUE THEN
EXIT;

TenantMedia.GET(Employees.Image.MEDIAID);
TenantMedia.CALCFIELDS(Content);
IF TenantMedia.Content.HASVALUE THEN BEGIN

CLEAR(PictureText);
CLEAR(PictureInStream);
TenantMedia.Content.CREATEINSTREAM(PictureInStream, (TEXTENCODING::UTF8));
//PictureText.ADDTEXT(Base64Convert.StreamToBase64String(PictureInStream));
//PicDataBASE64 := Base64Convert.StreamToBase64String(PictureInStream);
//PicDataBASE64 := Base64Convert1.ToBase64_6(PictureInStream);
PictureText.ADDTEXT(Base64Convert1.ToBase64_6(PictureInStream));
MESSAGE(PicDataBASE64);

END;

This is my codeunit where I tried using both resources referenced in my original post.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,605 Moderator on at

Like (0)

Report

RE: Convert BLOB to Base64 for use in Web Service

is it possible to share the code

Was this reply helpful? Yes No
Jesse Otu 10 on at

Like (0)

Report

RE: Convert BLOB to Base64 for use in Web Service

I'm working in BC 14. I've updated my post accordingly.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,605 Moderator on at

Like (0)

Report

RE: Convert BLOB to Base64 in Dynamics NAV for use in Web Service

Hi,

Are you trying to do in NAV or BC?

Thanks.

Was this reply helpful? Yes No