Expresions to work with JSON text

AppSheet AppSheet Q&A
1

Hi all,

Would love to know if there are any expressions that can parse or extract data from json strings.

Something like JSON_PARSE/ JSON_EXTRACT

Usecase is reading data from PSQL in a json column and making sense of it without dodgy string manipulation.

Thanks!

2

Hi @silentfred

with AppSheet there is no such expression yet.

1 Like
3

It would be an extremely useful capability to have - I’m new to the community here, how does one request a feature?

4

Agree :slightly_smiling_face:

and here: https://www.googlecloudcommunity.com/gc/Feature-Ideas/Regular-Expressions-Please/idi-p/325840

https://www.googlecloudcommunity.com/gc/Feature-Ideas/REGEX-expressions-and-an-optional-occurrence-parameter-for/idi-p/366052

1 Like
5

an optional workaround for you could be to use Regex with an Apps Script file.

This requires to writedown expression, and eventually sync the app to retrieve the result :slightly_smiling_face:

More information here:

Quick start: Call Apps Script from an automation

6

Not sure regex would suite json parsing well - sounds like a hacky way to extract fields. Native json parsing would be ideal

7

Yes.

You may want to create a new post in the “feature ideas” category.

1 Like