LabeljoyNew version
XML and JSON files hold data in a tree rather than in rows, so Labeljoy looks for the part of the tree that repeats - one branch per record - and makes each branch a row. In the Data connection wizard, choose XML or JSON, pick the file with the folder button next to File name, and then which part of it holds the records, under Source.
| XML | |
| Source | The first choice is the file's root element: its children are the records. Then comes every element that repeats right under the root. |
| The fields | The elements inside each record, plus its attributes, which get an @ in front: @id. A record with neither has one field, Value, with its text. |
| SQL query | For records deeper in the tree: type an XPath expression that selects them, such as //order/item. |
| JSON | |
| Source | Every list at the top of the file. A list of objects is under Tables, with a field for each property; a list of plain values is under Collections, with one field, Value. A file that is a list itself shows up under its own name. |
| The fields | The properties found in the first 50 records. A property that holds an object or a list comes through as its JSON text. |
| SQL query | For a list deeper in the file: type its path, such as data.items. |
Namespaces in an XML file don't get in the way: elements are matched by their names without the prefix. Everything arrives as text.
