Is there a method of parsing a json formatted string that is stored in a field which a lookup or fetch block retrieves?

Information is stored in a json formatted string field which i would retrieve via a lookup for fetch block and then use an update block to query the contents of the field which contains the json formatted string.

For example the json would contain an hours key pair, I would like to use a formula in an update block to test if hours > 50, if so set field to 50

(2) Answers