I get the following JSON response from an API call

[
[
{
“field”: “ID”,
“value”: 29
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:18”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “2500”
}
],
[
{
“field”: “ID”,
“value”: 28
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:16”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “15400”
}
]
]

and need to create a table in Power Query for further processing. The table will have a column Date (from date created) and a column ‘Sales amount’ from Sales amount. No idea how do I approach this? 

​I get the following JSON response from an API call [
[
{
“field”: “ID”,
“value”: 29
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:18”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “2500”
}
],
[
{
“field”: “ID”,
“value”: 28
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:16”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “15400”
}
]
] and need to create a table in Power Query for further processing. The table will have a column Date (from date created) and a column ‘Sales amount’ from Sales amount. No idea how do I approach this?     Read More

​