Skip to main content
Version: Next

Get From Json 8

Enables to extract the values from json by eight paths

Description​

Extracts the object or primitive from json by eight paths.

The path is specified in dotted form. To extract an element inside an array, the property needs to be included inside brackets, e.g. '[name]'.

Examples​

GetFromJSON({ "a": { "b": "hello"}}, 'a.b') -> "hello"
GetFromJSON({ "a": [ { "b": "hello", "c": "boo 1" }, { "b": "coucou" , "c": "boo 2" }] } , 'a.[b]') -> ["hello","coucou"]
GetFromJSON({  "a": [ { "b": { "c": "boo 1" } }, { "b": { "c": "boo 2" } } ] } , 'a.[b].c') -> ["boo 1","boo 2"]

Full doc of the syntax supported: <a href="https://www.npmjs.com/package/jsonpath-plus" target="_blank">jsonpath-plus</a>.

A list will be returned having multiple results found.

If the path was not found the result of the related output would be null. If one of the paths was not found the Error Flow would be triggered.

Inputs​

  • Path5 (String): The property path
  • Path7 (String): The property path
  • Path6 (String): The property path
  • Path8 (String): The property path
  • Path4 (String): The property path
  • Path1 (String): The property path
  • Source (Object): The JSON object or string to find from
  • Path3 (String): The property path
  • Path2 (String): The property path

Outputs​

  • Value2 (Object): The object or primitive found by Path2
  • Value4 (Object): The object or primitive found by Path4
  • Value1 (Object): The object or primitive found by Path1
  • Value6 (Object): The object or primitive found by Path6
  • Value7 (Object): The object or primitive found by Path7
  • Error Flow (Error Flow)
  • Value8 (Object): The object or primitive found by Path8
  • Value3 (Object): The object or primitive found by Path3
  • Value5 (Object): The object or primitive found by Path5