Hello,
I have written a Business Central Query Extension to get the field "Image" and exported it in a Web Service to Power BI.
What I get is the string that should connect the real image bitmap.
How can I set the Query in order to get the image bitmap and not the string as a key?
Later I will use too the dataset with the image bitmap in Report Builder.
Thanks in advance,
Hi, just adding some info for Report Builder.
You can refer to the standard function below to display your images.
table 79 "Company Information"
report 1305 "Standard Sales - Order Conf."
Hope this helps as well.
Thanks.
ZHU
What you will ned to do is first to put the image (content of the blob field) into a stream and then convert the stream to a base 64 string before you use the base 64 encoded string as the return value for your webservice.
procedure ToBase64(InStream: InStream): Text
learn.microsoft.com/.../system_application_codeunit_base64_convert
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156