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

Business Central API, convert base64 string to blob and save

(1) Share

Report

Posted on by MG-04060224-0

I created new table with blob field and API page for this table. Now I want to intercept POST request and convert base64 string to blob and save the record. Is there anyway to accomplish this? Or any better method for saving file in business central, custom made table from API request

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 75,942 Super User 2024 Season 2 on at

Like (0)

Report

Business Central API, convert base64 string to blob and save

Hi, here is a good example, I hope it can give you some help.

Importing Attachments To Sales Orders In Business Central Using Web Services - Ivan Singleton

Thanks.

ZHU
Suggested answer

Nitin Verma 21,081 Super User 2024 Season 1 on at

Like (0)

Report
Business Central API, convert base64 string to blob and save

Hi,

You can try this procedure when you are getting Base64 text from API url.

local procedure ConverBase64Text(FileContent: text) var BaseConvert: Codeunit "Base64 Convert"; TempBlob: Codeunit "Temp Blob"; OutStr: OutStream; RecRef: RecordRef; begin if FileContent = '' then exit; RecRef.Open(Database::<TargetTable>); RecRef.GetTable(<TargetTable>); TempBlob.CreateOutStream(OutStr); BaseConvert.FromBase64(FileContent, OutStr); TempBlob.ToRecordRef(RecRef, <TargetTable>.FieldNo(<BlobField>)); RecRef.SetTable(<TargetTable>); RecRef.Close(); end;
Suggested answer

gdrenteria 13,116 Most Valuable Professional on at

Like (0)

Report

Business Central API, convert base64 string to blob and save

Hi

I hope this can help you and give you some hints.

Dynamics 365 Business Central: handling BLOB fields on APIs – Stefano Demiliani

BR

GR