Expresions to work with JSON text

[silentfred]

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!

[Aurelien]

Hi @silentfred 

with AppSheet there is no such expression yet.

[silentfred]

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

[Aurelien]

Agree 🙂

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

[Aurelien]

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 🙂

More information here:

Quick start: Call Apps Script from an automation 

[silentfred]

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

[Aurelien · Accepted solution]

Yes. 

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