How to extract directly from JSON files

Since GA4.4 it has been possible to extract data from JSON file structures. This can be done either through a stream provided by webmon or directly from a file.

Before extraction, the JSON data is converted into XML, and the structure changes accordingly. In the conversion an additional top layer (/object) is added to the tree.

So looking at this:

{
 "content": {
 "data": {
 "agents_away": 0,
 "agents_invisible": 0,
 "agents_online": 1
 },
 "department_id": null,
 "topic": "agents",
 "type": "update"
 },
 "status_code": 200
}

This will be converted into:

<?xml version="1.0" encoding="UTF-8"?>
<object>
<content>
<data>
<agents_away>0</agents_away>
<agents_invisible>0</agents_invisible>
<agents_online>1</agents_online>
</data>
<department_id/>
<topic>agents</topic>
<type>update</type>
</content>
<status_code>200</status_code>
</object>

As you can see, all headers are converted straight into tag names instead of attributes, which makes it more diffucult to rotate around children tags. In normal XML we would rotate around all children in data by using

/object/content/data/tr (or similar end tag)

row names would be created for each child seen and we could only extract the value.

In this case we can rotate around

/object/content/data/* where rownames would be created using "name()" and value would be extracted using "text()"

The finished XML would look like this: