I have a series of JSON documents that I'm querying over where at a particular level the resulting data is either a list or a record. In the case where the data is shown as a List the JSON is typically a block of nodes like this:
"Nodes": {
"Node": [
{
"OS": {
"_name": "Windows Server 2012 R2",
"_vendor": "Unknown",
"_version": "6.3",
"_arch": "Unknown"
},
"_id": "HOST1",
"_cpu": "amd64"
},
{
"OS": {
"_name": "Unknown",
"_vendor": "Unknown",
"_version": "Unknown",
"_arch": "Unknown"
},
"_id": "HOST2",
"_cpu": "Unknown"
}
]
}In the case where it's listed as a Record it's a single record of the same data as follows:
"Nodes": {
"Node": {
"OS": {
"_name": "Windows Server 2008 R2",
"_vendor": "Unknown",
"_version": "6.1",
"_arch": "Unknown"
},
"_id": "HOST1",
"_cpu": "amd64"
}
}Being extremely new to working this in Power BI I'm assuming that since I'm out of options in the Desktop UI that I likely need to parse this down using M code. I'm assuming I can test if the type of entry is a List or a Record and IF/Else the results but I can't seem to figure out the right sequence. I've seen a few other examples but haven't been able to get those to work and get a result. Any pointers? Thanks!
