Number of input and output field

Number of input field	:	One
Number of output field	:	One

The GetKeyByValueJSON function is used to retrieve a value based on a specific field. This function is applied to data that is the output of the JSONPathParser function.

There are three parameters that must be provided to this function:

• Key(s)
  The key or keys to be selected from the input data.
• Key-Value-Separator
  The string that separates a key name from its value.
• Key_Value-Pair-Separator
  The string that separates each key-value pair.

Example usage of GetKeyByValueJSON in HGrid247

1.

Input	{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95}
Key(s)	category,author,title,price
Key-Value-Separator	:
Key-Value-Pairs-Separator	,
Result	reference          Nigel Rees          Sayings of the Century          8.95

2.

Input	{book:{{category=reference,author=Nigel Rees,title=Sayings of the Century,price=8.95,location={id#01,rack#rack-1}},{category=fiction,author=Evelyn Waugh,title=Sword of Honour,price=12.99},{category=fiction,author=Herman Melville,title=Moby Dick,isbn=0-553-21311-3,price=8.99},{category=fiction,author=J. R. R. Tolkien,title=The Lord of the Rings,isbn=0-395-19395-8,price=22.99}},bicycle:{color=red,price=19.95}}
Key(s)	book,bicycle
Key-Value-Separator	:
Key-Value-Pairs-Separator	,
Result	{{category=reference,author=Nigel Rees,title=Sayings of the Century,price=8.95,location={id#01,rack#rack-1}},{category=fiction,author=Evelyn Waugh,title=Sword of Honour,price=12.99},{category=fiction,author=Herman Melville,title=Moby Dick,isbn=0-553-21311-3,price=8.99},{category=fiction,author=J. R. R. Tolkien,title=The Lord of the Rings,isbn=0-395-19395-8,price=22.99}}          {color=red,price=19.95}