The webhook url is not well formed

[Francisco_Vila]

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

The expression result:

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

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

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

 When I test the bot it gives me the following error

What I can be doing wrong ?

[Suvrutt_Gurjar]

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")

[Francisco_Vila]

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

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 

[Francisco_Vila]

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 !!!

[ODCP]

Hola! encontraste una solucion? tengo exactamente el mismo problema