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

[Martin Nicholson]

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

[Wes Couturier]

Hello Dan,

 

I would suggest you try to use a Fetch block to see if you can use the Include tab in order to grab the field as hierarchical data.

 

If you can't do it there, does Scribe give you the option to use the Query Block's include tab for that data

 

Wesley C.

Scribe Support

[Martin Nicholson]

Hi Wesley, just tried the fetch block and query block, the include tab doesn't offer any access to the field. When I run the current map in debug the data that i'm wanting to expose is in a field as shown in the snippet below (this is being returned by a lookup block)

 

 

 

I want to be able to determine in an if statement in a subsequent update block if hours = 730, or similar.