Jump to content
We have recently updated our Privacy Statement, available here ×

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

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

×
×
  • Create New...