I’ve tried searching for answers to this but I’m sure I must be using the wrong search terms as I get close matches but nothing that has pointed me in quite the right direction yet. I’m hopefully that someone can help me understand how to expand the following JSON fragment into a set of features, where each feature contains the same initial set of fields, but only contains one of the final array entries.
Here’s an edited example of the JSON I’m dealing with and how I’d like the out to look.
{"UPRN":"12345678",
"CaseNo":"15/01234/ABCDE",
"Address":"16 Some Rd Surrey SM1 1AA",
"Name":"Miss T Mountain",
"DocumentID":["7654321","7654322","7654323"]}
I’m trying to extract this into 3 features, each of which includes the uprn, CaseNo, address, name and a DocumentID.
I’ve been able to extract the whole array of documentIDs but haven’t figured out how to extract each one in turn and pair it up with the remaining information.
The JSON output I’m dealing with contains a number of such records, in each case the number of document IDs is between 1 and many, so I can’t create explicit references to entries within the array.
I’ve been experimenting with the JSONFragmenter and JSONExpander. I think I just need to understand how to reference the internals of this structure properly.
If anyone can offer me some help to understand how to do this, I would be grateful.
