Why I added a img field in the input and output, my sql statement can not query the result, is this a bug
You see, remove img and he succeeds。
Hey @Jiayu -
What is the underlying datatype in the table where that image field exists? The Image URL type expects this field to be a text or varchar type.
Pete
Hi @Jiayu as @Pete_Hartnett mentioned the response from Database must be a String. But additionally I found out it must begin with http:// or https://
So that means it must be a valid URL type string…
Hi @Pete_Hartnett
Beautiful day
How do I save the uploaded pictures to the path I specify, because the link to upload pictures will not open in a few days, but I need to save these pictures for a long time, and I can view all the pictures at any time
Hey @Jiayu -
All images in Tulip are stored on an AWS server (or Azure) and the URL you see in tables is just a temporary link to that photo that expires after 24 hours. Within Tulip that link will always be valid (your photo is never deleted) but it is because we handle the reloading of these links when they expire.
There is a feature request to make these links persistent when csv exported, but that work isn’t yet done.
Pete
Hi Pete,
it’s been a few years since the answer on this post, has there been any update? I have the same issue, I’m recording pictures with Tulip app but need long-term storage and also integration with other systems. Yet, the links always expire straight away.
Thank you in advance!
Best regards,
Luca
@lucaq There is now API functionality for getting signed file URLs. This is a secure way for Tulip to share image and file links temporarily. Making perpetually public links is not a secure option for most companies, so I don’t think Tulip has pursued this very far.
Hi Daniel,
thank you for your answer, would it be possible, through the API, to request a signed URL, get it back signed and then show it on a browser viewer, just to make an example? Or maybe to download it?
Thanks,
Luca
Yes this is exactly the expected use pattern. Any scripting language should be able to save the file once it has the temporarily secure url. At that point it is entirely up to you what you would like to do with it.