TeamDesk Knowledge Base & Support

Kirill Bondar  Staff  2/12/2021 6:29:05 AM

There are two encoding functions we use in Call URL actions -- JSON and JSONFormat.

JSON(text) does just what you propose - encodes special characters in a string.
JSONFormat(text | number | bool | date | time | timestamp) produces JSON represenation for any value type -- quoted string, true, false, properly formatted number etc. Latter allows handling NULLs:

JSONFormat("text") produces string "text"
JSONFormat(null) produces word "null"

With best regards,
Kirill

Kirill Bondar  Staff  2/12/2021 6:30:02 AM

I only wonder why you could need it as in Call URL actions all encoding happens automatically.

Robert Gustavsson 2/12/2021 8:05:53 AM

I'm using a column summary (concatenation) to create multiple JSON rows, thus I can't rely on "call URL" to format at the top level.

Robert Gustavsson 2/12/2021 8:15:41 AM

Thanks Kirill, the secret JSON() function seems to works.

Kirill Bondar  Staff  3/5/2021 6:36:26 AM

There is a recent addition to TeamDesk that might be useful in your scenario
https://www.teamdesk.net/blog/whats-new/passthrough-blocks-in-call-url-and-navigate-actions/

Robert Gustavsson 3/5/2021 7:47:59 AM

Very well