Transform Base64 string in Image variable

Product Suggestions
1

Will be nice in trigger action/fonction editor to convert a base64 string into a image variable. I will enable us to show a image in Tulip apps without store in table or S3.

2

I agree. It would also be good if SVGs could be handled the same way. In the short term, this is achievable by using a connector function.

image
image951×824 14.5 KB

1 Like
3

We have a use case where an inspection machine takes pictures of a part and makes measurements. The machine manufacturer asks us for the protocol to send this data. We oriented it to the MQTT format with base64 for the photo. Then via NodeRed we send this data to the Machine Tulip API. Any other protocol suggestions to allow us to send this data and display the image in real time in Tulip?

4

are you sure about syntax?

image
image1813×1083 48.3 KB

5

The syntax I shared works with the built-in “connectors demo” which is a postgresql database. The “||” is a concatenation.

In another database, like SQL server, you may need another syntax like “concat(‘string1’,‘string2’)”

1 Like
6

Thanks, + works for SQL Server

1 Like
7

Our application works well with this tip :slight_smile: But we have a limitation on the size of the image. Do you know where this limitation can come from? (The database, the Tulip connector, the text field, …) Thanks

8

Great to hear! I’m not quite sure, could you send me the image base64 string for me to play with? I wonder if there is some character limit somewhere.

9

Hello Mark,
thank you to help us on this Topic.

I can not send you here the .txt file.
Can i share this on Email?
Mark.freedman@tulip.co?

Thanks

10

@yvan.chkouropadsky Sure, you can send it to that email if you’d like. Also, the new STRING_TO_IMG_URL() function in the expression editor will make it so you no longer need to use the connectors demo workaround.

11

Hi Mark,

Do you know a solution to integrate pdf files in a Tulip application from a data:application/pdf;base64 URI?

Thanks

12

Hi Mark,
I’m trying to develop a TULIP vision app and also have the same kind of issues with base64 string coming from a connector to a cloud API that I would like to store in a variable and display as an image in TULIP. I cannot seem to find the STRING_TO_IMG_URL() expression that you mentionned. do you know any way to do it? even if I need to store it in a table?
Thanks a lot for the insight.

13

Hi Antoine

TEXTTOIMAGEURL

Youri

2 Likes
14

Thanks @youri.regnaud , you beat me to it!

2 Likes