I work a lot with files/images stored in blob fields. With the lack of .NET support it would be good to have the posibility to convert byte arrays to base64 strings, and the other way around.
A real life example would be:
- Receive a base64 encoded string from a javascript file drag/drop add-in.
- Store the file into a blob field.
- Export the blob to base64 to include it in a REST API call to a 3rd party system.
erikrijn
All 7 comments
With the June update you can use the FromBase64String and ToBase64String functions from the TempBlob table. This was not possible in previous versions.
In case you are interested, I can provide you with a Codeunit for Base64 encoding / decoding, fully written in AL code, without .Net dependency. Didn't publish it because Microsoft promised to enable the functions in the TempBlob.
ajkauffmann
on 23 Jun 2017
That would be much appreciated! I don't like the whole concept of temp tables. Especially not of using a helper table like tempblob.
erikrijn
on 24 Jun 2017
We have it on our backlog to add Base64 to the Library.
esbenk
on 25 Jun 2017
@ajkauffmann I would like the AL code example you created. :)
RasmusTidselbak
on 30 Jun 2017
Sorry guys, I'm quite busy those days and forgot about it. Will try to find some time during the weekend. ;-)
Point is: it was focused on encoding text to base64 because you need that for authentication with web services. So currently it is not supporting binary data (e.g. streams).
ajkauffmann
on 30 Jun 2017
Code is available on GitHub. See: http://www.kauffmann.nl/2017/07/10/convert-base64-with-al-code/
ajkauffmann
on 10 Jul 2017
Closing this suggestion since FromBase64String and ToBase64String functions from the TempBlob table cover it.
StanislawStempin
on 11 Sep 2017
Related issues
kine
路
3Comments
TinaMenezes
路
3Comments
daansaveyn
路
3Comments
bvbeek
路
3Comments
RedFoxUA
路
3Comments
Most helpful comment
Code is available on GitHub. See: http://www.kauffmann.nl/2017/07/10/convert-base64-with-al-code/