I am new to this and learning but...
I have a JSON object and am trying to extract the attributes to load to PostGreSQL and I am hitting my head against a wall.
The format of the JSON is generally as so:
{
model: 1,
version: 2,
content: l
{
x=1,
y=2
},{
x=3,
y=4
}
]
}
I want to output something along the lines of:
model, version, x, y
1, 2, 1, 2
1, 2, 3, 4
For the life of ne I cannot work it out, to me the documentation and step by steps are not clear.
I am using a standard JSON reader. Whatever I try, flattener, fragmentation, I cannot opreate on the content.
I had an instance where I managed to get all extracted using an extractor but this would populate the attributes for each item in the content array and concat together to look like this:
model, version, x, y
11, 22, 13, 24
The real JSON is a lot more complicated but at this very basic level, I am still not there.