AppSheet database URL type plus exporting to JSON

AppSheet AppSheet Q&A
1

I have an AppSheet table with a “Link” column of type URL. I have an export bot that exports to JSON, and the

“Link”: “<<[Link]>>”

If the column has data in it, the output is something like this:

“Link”: “https://www.example.com/”

If it doesn’t, the output is this:

"Link": "{\"Url\":\"\",\"LinkText\":\"\"}"

For giggles, I tried the HYPERLINK() function:

"Link": "<<HYPERLINK([Link], "Some text here")>>"

For that, the export is still just the URL:

“Link”: “https://www.example.com/”

So, a couple of questions:

  1. Is there a way to get a full HYPERLINK() result properly exported?
  2. How do I get the export to expand the JSON content?

This is the result I would like to see:

"Link": {
  "Url": “https://www.example.com/”,
  "LinkText": "Some text here"
}

Thanks.

2

I’d think:

<<If: ISNOTBLANK([Link])>>
"Link": {
  "Url": "<<LINKURL([Link])>>",
  "LinkText": "<<LINKTEXT([Link])>>"
}
<<EndIf>>

See also:

Attn @AleksiAlkio @Aleksi

1 Like
3

Thank you.

If there was an RTFM tag, I would add it to my post. :person_facepalming:

1 Like
4

You have to know what to look (or ask) for, and it isn’t always obvious.

5

True, and thanks, but a search for the word “link” or “url” in the function list would have done the trick. I’m normally a little more careful before posting. It’s really just a little humorous self-flagellation for missing that.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.