2022.1

Table Of Contents
In the DataMapper the JsonPath can be absolute (start with $ which is the root) or relative to the
current position (start with . which is the current element).
A JsonPath can be relative or absolute. Note, however, that with a relative JsonPath going up
to a parent element is not possible.
Tip
The full JsonPath to an element is displayed at the bottom left of the window when you
select it. To copy the path, right-click it and select Copy.
Note
If a key in a JSON file has a name that looks like a function (e.g. "TLIST(A1)"), then the
Extract step has to use a JsonPath with bracket notation instead of the default dot
notation. For information about the bracket notation see
https://goessner.net/articles/JsonPath/.
From a Text or a PDF file
In a PDF or Text file, transactional data appears on multiple lines and can be spread over
multiple pages.
1. Add a Goto step if necessary. Make sure that the cursor is located where the extraction
loop must start. By default the cursor is located at the top of the page, but previous steps
may have moved it. Note that an Extract step does not move the cursor.
1. Select an element in the first line item.
2. Right-click on the selection and select Add Goto. The Goto step will move the
cursor to the start of the first line item.
Page 270