URL for Google Chat within Workflow

[Chris_Sondesky]

Hello Appsheet Community!

We've built google chat notifications within our app, and within this notification, we're attempting to pass a URL and have been successful.  

However, when we try to pass the URL with link text instead of the URL, we continue to run into errors as the Google Chat link text specification is <http://www.URL.com | linktext>

If we structure that within appsheet to call fields, we end up with <<<[url]>> | <<linktext>>>, and this causes an error in the JSON parser.  IF we attempt to escape the first '<' and last '>', we still get an error.

Has anyone successfully passed variables to the google api through json workflow?

[SkrOYC · Accepted solution]

Try to use CONCATENATE()

CONCATENATE() - AppSheet Help