Hi Team - Using powerquery a web api returns json in below format
{
"responses": [{
"1": {
"id": "1",
"submitdate": "1980-01-01"
}
}, {
"2": {
"id": "2",
"submitdate": "1980-01-01"
}
}, {
"3": {
"id": "3",
"submitdate": "1980-01-01"
}
}]
}
which I am not able to convert to table using powerquery user interface interactions. I guess if some how I can convert it to below json format then powerquery will easily understand it and convert it to table. Please let me know how can I transform above json format to the below one.
{
"responses": [{
"id": "1",
"submitdate": "1980-01-01"
}, {
"id": "2",
"submitdate": "1980-01-01"
}, {
"id": "3",
"submitdate": "1980-01-01"
}]
}
Thanks
{
"responses": [{
"1": {
"id": "1",
"submitdate": "1980-01-01"
}
}, {
"2": {
"id": "2",
"submitdate": "1980-01-01"
}
}, {
"3": {
"id": "3",
"submitdate": "1980-01-01"
}
}]
}
which I am not able to convert to table using powerquery user interface interactions. I guess if some how I can convert it to below json format then powerquery will easily understand it and convert it to table. Please let me know how can I transform above json format to the below one.
{
"responses": [{
"id": "1",
"submitdate": "1980-01-01"
}, {
"id": "2",
"submitdate": "1980-01-01"
}, {
"id": "3",
"submitdate": "1980-01-01"
}]
}
Thanks