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

Support, Troubleshooting, & Help
, ,
1

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

2

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
3

@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.

4

Yes, definitely will!

5

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