The webhook url is not well formed

AppSheet AppSheet Q&A
1

Good evening, I hope everyone is well. I am trying to use an external API to send messages via Whatsapp (https://www.callmebot.com/blog/whatsapp-messages-from-appsheet)

In one of my tables I have a virtual column called [url_envio_whatsapp] in which I apply the following formula to complete it

Concatenate("https://api.callmebot.com/whatsapp.php?source=AppSheet&phone=",[celular_dis_internacional],"&text=Hola+Pancho","&apikey=1502114")

If I test the formula, the result is what I show in the following image

Captura.JPG
Captura.JPG1168×552 53.3 KB

The expression result:

https://api.callmebot.com/whatsapp.php?source=AppSheet&phone=59899617183&text=Hola+Pancho&apikey=1502114

If I copy and paste this URL into a browser, the API responds correctly

Captura.JPG
Captura.JPG949×223 16.7 KB

On the other hand, I have a bot that, given an event, tries to send a message via WhatsApp

Captura.JPG
Captura.JPG405×564 21 KB

Captura.JPG
Captura.JPG388×562 21.9 KB

When I test the bot it gives me the following error

Captura.JPG
Captura.JPG1344×520 63.6 KB

What I can be doing wrong ?

2

Maybe this?

In place of

Concatenate("https://api.callmebot.com/whatsapp.php?source=AppSheet&phone=",[celular_dis_internacional],"&text=Hola+Pancho","&apikey=1502114")

this

Concatenate(“https://api.callmebot.com/whatsapp.php?source=AppSheet&phone=”,[celular_dis_internacional],“&ENCODEURL(“Hola Pancho”),”&apikey=1502114")

1 Like
3

If I directly copy and paste the formula that you suggest me directly, it gives me an error when testing the resulting url since you ignored the text= parameter

In any case, I tried the following formula where I use the ENCODEURL() function

Concatenate(“https://api.callmebot.com/whatsapp.php?source=AppSheet&phone=”,[celular_dis_internacional],“&text=”,ENCODEURL(“Hello Pancho”),“&apikey=1502114”)

When testing the result, it gives me the following URL that if I try it directly in the browser, the API call does not give me a problem

https://api.callmebot.com/whatsapp.php?source=AppSheet&phone=59899617183&text=Hello%20Pancho&apikey=1502114

On the other hand, when I go to test the bot, it keeps giving me the URL malformation error. Incredible !!!

Anything else you can think of @Suvrutt_Gurjar

4

A detail I wanted to add @Suvrutt_Gurjar …

If I copy the result of the formula and paste it in the URL field of the webhook configuration, it works like a charm!

On the other hand, if I use the field [url_envio_whatsapp], which is where I do the concatenation, it gives me the not well formed error !!!

5

Hola! encontraste una solucion? tengo exactamente el mismo problema