Below is a short sample of the JSON output I am working with.
{
"total": 41,
"first": "https://api.idxbroker.com/clients/soldpending?offset=0",
"last": "https://api.idxbroker.com/clients/soldpending?offset=36",
"next": "https://api.idxbroker.com/clients/soldpending?offset=6",
"previous": null,
"data": {
"c151!%187557": {
"address": "138 E 50th Street",
"cityName": "Savannah",
"detailsURL": "c151/187557",
"listingID": "187557",
"state": "Georgia",
"zipcode": "31405"
},
"c151!%203935": {
"address": "4 Mallard Drive",
"cityName": "Savannah",
"detailsURL": "c151/203935",
"listingID": "203935",
"state": "Georgia",
"zipcode": "31419"
},
"c151!%182876": {
"address": "2 Lake Heron Court W",
"cityName": "Pooler",
"detailsURL": "c151/182876",
"listingID": "182876",
"state": "Georgia",
"zipcode": "31322"
},
"c151!%201014": {
"address": "2 Pipers Pond Lane",
"cityName": "Savannah",
"detailsURL": "c151/201014",
"listingID": "201014",
"state": "Georgia",
"zipcode": "31404"
},
"c151!%217162": {
"address": "52 Litchfield Drive",
"cityName": "Savannah",
"detailsURL": "c151/217162",
"listingID": "217162",
"state": "Georgia",
"zipcode": "31419"
},
"c151!%206778": {
"address": "330 Kelsall Drive",
"cityName": "Richmond Hill",
"detailsURL": "c151/206778",
"listingID": "206778",
"state": "Georgia",
"zipcode": "31324"
}
}
}
I’ve tried flip to convert columns to rows, but the 1st row ends up being the column headers.
Any suggestions as to how I can flatten this so that I have columns for address, cityName, detailsURL, listingID, state, zipcode?
The resulting data should look like the following except with proper column headings:
Thanks so much in advance for any suggestions.