website logo
πŸ”­Overview
πŸ’ΌPlatform Actions
πŸ’œIntegrations
🧰Custom Actions
πŸ› οΈDeveloper's Guide
Navigate through spaces
⌘K
πŸ“•Call API
πŸ“•Generate Document
πŸ“•Call Subprocess
πŸ“•Decisional
βš“Decisional Further Reading
πŸ“•Join
πŸ“•Delay
πŸ“•For Each
πŸ“•Throw
πŸ“•Get File Data
πŸ“•Map Process Data
βœ‰οΈSend Email
πŸ“¬Inbound email
πŸ“Database
πŸ“Documents
πŸ“DateTime
πŸ“FTP/sFTP
πŸ“Json
πŸ“XPath
πŸ“Lists
πŸ“Numerical
πŸ“Strings
πŸ“Converters
πŸ“Excel
πŸ“Scripting
πŸ“Utilitary
πŸ“Pdf
❀️Community-Made
πŸ“Beta
Docs powered by
Archbee
Json

Json Mapper

7min
<iframe width="560" height="315" src="https://www.youtube.com/embed/RW3cRYng1Bg" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
ο»Ώ

The Json Mapper action is one of the actions at your disposal to work with Json data. JSON Mapper enables you to extract a value 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.

You can use this website to test your JPath queries.

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 Field1: β€œResult” ( JSON Object value corresponding to the query)

How toο»Ώο»Ώ

1. Create a new process and give it a name.

2. Drag the Json mapper action to the canvas and link it to the other actions.

Document image
ο»Ώ

3. Add the needed variables.

Document image
ο»Ώ
  • ο»Ώ<%input%> will contain the JSon data, the default will use
JSON
|
[ { "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. In this exaplte the <%filter%> will be ..name
  • ο»Ώ<%result%> will be our actions output.

4. Click the Json mapper action to access its configurations and add the variables created at the previous space.

Document image
ο»Ώ

5. Save, Validate and Run the process.

6. The process will ask for the inputs, w could leave the defaults as is for now.

Document image
ο»Ώ

7. Click Run.

8. Click Check Instance to view the results. We will se that the first name from the json was saved in the variable. Keep in mind that the action will extract only one value from a JSON or a JSON array.

Document image
ο»Ώ

ο»Ώ

Updated 31 Aug 2023
Did this page help you?
PREVIOUS
Upload File
NEXT
Json Mapper To List
Docs powered by
Archbee
TABLE OF CONTENTS
Overview
How toο»Ώο»Ώ
Docs powered by
Archbee