Announcements
60
I am getting base64string data in blob field using API. Now I want to convert that Base64string to readable format and want to store that data as xml file. So that I can view that file and download it.
Hello,
Thank you so much for sharing this code snippet of converting "Base64String to text" with me! I tried it and it worked perfectly for me. I really appreciate your help and I learned something new today thanks to you. Thank you again for your contribution to the conversation!
hello,
to convert the base64 code and store it in a table blob field, you can do it this way:
var
RecRef : RecordRef;
cuTempBlob: Codeunit "Temp Blob";
DocOutStrem: OutStream;
Base64Convert: Codeunit "Base64 Convert";
begin
cuTempBlob.CreateOutStream(DocOutStrem);
Base64Convert.FromBase64(base64value, DocOutStrem);
RecRef.GetTable(Rec);
cuTempBlob.ToRecordRef(RecRef ,Rec.FieldNo(BlobField));
RecRef.SetTable(Rec);
end;
to read the xml file contained in the blob inside the AL code, you can use XMLDOCUMENT like this
var
XmlDoc: XmlDocument;
inStr : Instream;
begin
Rec.CALCFIELDS(BlobField);
Rec.BlobField.CreateInStream(inStr);
XmlDocument.ReadFrom(inStr, XmlDoc);
end;
from here you can use the methods (XmlDoc.SelectNodes, XmlDoc.SelecSingleNode,...etc)
look at the documentation to learn more:
learn.microsoft.com/.../xmldocument-data-type
if you want to save and download the content in xml files on your machine:
var
XmlDoc : XmlDocument;
inStr : Instream;
FileName : Test;
begin
FileName := 'myXmlFile.xml';
Rec.CALCFIELDS(BlobField);
Rec.BlobField.CreateInStream(inStr);
DownloadFromStream(inStr, '', '', FileName);
end;
if it helped you, please select this answer, thank you
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,107
Super User 2024 Season 2
#2
Martin Dráb
227,969
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (