JSON
Extract List

11min
﻿
<iframe width="560" height="315" src="https://www.youtube.com/embed/m2p3IRI46aE" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<iframe width="560" height="315" src="https://www.youtube.com/embed/m2p3IRI46aE" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
﻿
The Extract List action is one of the actions at your disposal to work with Json data. Extract List enables you to extract a list of values from a JSON or a JSON array.
The action will be able to query/extract data from a JSON input using a JSONPath expression and save it to a variable.
Extract List was previously called Json Mapper to list.
﻿
Overview
The action is used to filter the Json data that we will import in our process for future use.
Input Field 1: “Input JSON” - Input your JSON object / Array or a data model.
Input Field 2:  “Query” - The Input Jquery expression for obtaining the desired key value of your Json input.
Output Field: "Output" - Returns a list of values corresponding to the JQuery expression.

How to
The variables need to be adjusted according to your expected result for each process.
Example 1
  1.    Create a new process and give it a name.
  2.    Drag the Extract List action to the canvas and link it to the other actions.
﻿
3.    Add the needed variables.
﻿
﻿﻿<%JSONin%> will contain the JSon data, the default will use. The variable will be of Type Json, Single Value.
JSON
{
	"store": {
		"book": [
			{
				"category": "reference",
				"author": "Peter Mark Roget",
				"title": "Rogets 21st Century Thesaurus",
				"price": 8.74
			},
			{
				"category": "fiction",
				"author": "Melanie Finn",
				"title": "The Hare",
				"price": 12.89
			},
			{
				"category": "fiction",
				"author": "Kristin Hannah",
				"title": "The Four Winds",
				"isbn": "0-573-21321-3",
				"price": 8.69
			},
			{
				"category": "fiction",
				"author": "Lauren Oyler",
				"title": "Fake Accounts",
				"isbn": "0-698-19225-3",
				"price": 21.39
			}
		],
		"bicycle": {
			"color": "blue",
			"price": 19.65
		}
	}
}
{
	"store": {
		"book": [
			{
				"category": "reference",
				"author": "Peter Mark Roget",
				"title": "Rogets 21st Century Thesaurus",
				"price": 8.74
			},
			{
				"category": "fiction",
				"author": "Melanie Finn",
				"title": "The Hare",
				"price": 12.89
			},
			{
				"category": "fiction",
				"author": "Kristin Hannah",
				"title": "The Four Winds",
				"isbn": "0-573-21321-3",
				"price": 8.69
			},
			{
				"category": "fiction",
				"author": "Lauren Oyler",
				"title": "Fake Accounts",
				"isbn": "0-698-19225-3",
				"price": 21.39
			}
		],
		"bicycle": {
			"color": "blue",
			"price": 19.65
		}
	}
}
﻿
﻿﻿<%Filter%> will contain the JQuery expression that we will use in order to extract from the Json input data. The variable will be of Type String and Single Value. The query will retrieve the last book in order (notice that the result of the query will be a list with one value). This is the filter for obtaining the last book: $..book[-1:]

﻿<%result%> will be our actions output. The variable will be a List of type Json.
  4.    Click the Extract List action to access its configurations and add the variables created at the previous space.
﻿
  5.    Save, Validate and Run the process. 
  6.    The process will ask for the inputs, we could leave the defaults as is for now.
﻿
7.    Click Run.
  8.  Click Check Instance to view the results.
﻿
Further queries
We will continue with further examples of queries by only changing the <%Filter%> and showcasing the returned results for the same Json input, below the examples.
﻿<%Filter%> will use $..book[0,1] to obtain the first two books:
﻿
﻿
﻿<%Filter%> will use $..book[?(@.isbn)] to filter all books with isbn number:
﻿
﻿<%Filter%> will use $..book[?(@.price<10)] to filter all books cheaper than 10:
﻿
﻿
Example 2﻿﻿﻿﻿
  1.    Create a new process and give it a name.
  2.    Drag the Extract List action to the canvas and link it to the other actions.
﻿
3.    Add the needed variables.
﻿
﻿﻿<%input%> will contain the Json data, the default will use. The variable will be of Type JSon, Single Value.
JSON

[ { "name": "Eric", "invoicenumber": "INV99901", "duedate": "2021-08-30T07:00:00.000Z", "amount": 122.45, "phonenumber": "0700000000", "emailaddress": "[email protected]" }, { "name": "Chris", "invoicenumber": "INV99902", "duedate": "2021-08-03T07:00:00.000Z", "amount": 144.99, "phonenumber": "0711111111", "emailaddress": "[email protected]" }, { "name": "Diana", "invoicenumber": "INV99903", "duedate": "2021-08-30T07:00:00.000Z", "amount": 99.99, "phonenumber": "0722222222", "emailaddress": "[email protected]" } ]

[ { "name": "Eric", "invoicenumber": "INV99901", "duedate": "2021-08-30T07:00:00.000Z", "amount": 122.45, "phonenumber": "0700000000", "emailaddress": "employee@procesio.com" }, { "name": "Chris", "invoicenumber": "INV99902", "duedate": "2021-08-03T07:00:00.000Z", "amount": 144.99, "phonenumber": "0711111111", "emailaddress": "otheremployee@procesio.com" }, { "name": "Diana", "invoicenumber": "INV99903", "duedate": "2021-08-30T07:00:00.000Z", "amount": 99.99, "phonenumber": "0722222222", "emailaddress": "employee@procesio.com" } ]
﻿
﻿<%filter%> will contain the JQuerry expression that we will use on our data. The variable will be of Type String and Single Value. In this case ..name
﻿<%result%> will be our actions output.
  4.    Click the Extract List action to access its configurations and add the variables created at the previous space.
﻿
  5.    Save, Validate and Run the process. 
  6.    The process will ask for the inputs, we could leave the defaults as is for now.
﻿
 7.    Click Run.
  8.  Click Check Instance to view the results. We will see that all first names from the json were saved in the variable.
﻿
Updated 16 Feb 2024
Did this page help you?
Extract Object
Read File