How to import base64 string to Image field in Tulip table?

Hello,
I’ve been struggling in for the past few days, trying to import, convert and save base64 image data to Image object in Tulip.

My goal is to retrieve an image using a Nodered connector and save it in a Tulip table.
The connector gives me the 143kB image encoded as a base64 string with the following structure “data:image/png;base64,iVBORw0…”

I tried to use the TEXTTOIMAGEURL() function as described in other forums, but I cannot get it to work. Using the debugging tool, I can see the following error messages “Base value didn’t pass validation”. “This URL is too long and not supported.”

I didn’t find a workaround for this. I thought about directly storing the base64 to a text field in the table but the string is too long.
I would like to avoid the use of custom widgets as much as possible for this task.

Maybe some of you have insight on a strategy I could implement to retrieve my images ?

I’m using LTS13.2
Thanks you

Hi @Valentin_88 -

Great question here. There is a limit of 50 kB for Base64 stored images, so that is why you are seeing an error here. Data Types in Tulip

I am checking with the team to see if there are additional options here and will get back to you!

1 Like

@Beth I’ve been waiting for an answer on this same issue via a ticket. So whatever you find out could you please include me as well.

Yes, definitely will!

Thanks you !
Using a image lighter than 50kB did the trick for me. I was able to convert it to image and store it in a table.
Now, most of the images I have are in the range of the mega bytes…
If you find something out, let me know.
Best regards

1 Like