Appsheet Image URLs with URL API

[Nick_Neumann]

I’m trying to use Cloudimage, using it as a URL based API, to add watermarks to images within appsheet (similar to what has been done before with filestack).

I’m using the GetTableFileURL expression to generate the appsheet image URL which is working just fine, but the URL generated isn’t working with Cloudimage.

I’m assuming that has something to do with the way appsheet stores the images? I can get Cloudimage to work with any standard image url, but not the one appsheet produces.

[Nick_Neumann]

Also, when I use a url shortenr like bit.ly for the image url generated by appsheet, it works just fine with appsheet. But I havent found a way to automate this

[GreenFlux]

Nick_Neumann:

Also, when I use a url shortenr like bit.ly for the image url generated by appsheet, it works just fine with appsheet. But I havent found a way to automate this

Integromat

Create shortened URL addresses from new Google Sheets spreadsheet rows via Bitly

Every time you add a new URL address to your Google Sheets spreadsheet, Integromat will automatically shorten it via Bitly and update the spreadsheet with the shortened version of the URL. This template uses this [example...

[GreenFlux]

Make sure Secure Image Access, and URL Signing are both off.

How are you inserting the URL to test with Cloudimage? Can you manually copy/paste a working AppSheet image URL and get it to work that way? What have you tried?

[Nick_Neumann]

Hi there,

Yes they are both off. The formula I’m using is:

CONCATENATE(
“https://aqkwrxwmwp.cloudimg.io/v7/”,
[ImageUrl],
“?&wat=1&wat_url=”&“https://upload.wikimedia.org/wikipedia/commons/4/47/PNG_transparency_demonstration_1.png"&"&mark_wid...”
)

And example URL ouput would be: https://aqkwrxwmwp.cloudimg.io/v7/https://www.qualitymarine.com/graphics/wysiwyg/large/1669.jpg?&wat=1&wat_url=https://upload.wikimedia.org/wikipedia/commons/4/47/PNG_transparency_demonstration_1.png&mark_width=45&mark_pos=southwest&mark_pad=15

You can insert any image URL into the bold text and it will work unless you use an image URL generated by appsheet

[Bellave_Jayaram]

You could try encoding the whole path like so:

ENCODEURL(
CONCATENATE(
"https://aqkwrxwmwp.cloudimg.io/v7/",
[ImageUrl],
"?&wat=1&wat_url="&"https://upload.wikimedia.org/wikipedia/commons/4/47/PNG_transparency_demonstration_1.png"&"&mark_width=45&mark_pos=southwest&mark_pad=15"
)
)