[/ https://stackoverflow.com/questions/62938315/how-to-transform-json-derived-from-url-over-sql-table-or-pandas-dataframe
]
Добрый ден,
вот какой формат данных JSON


{
"d":{
"results":[
{
"__metadata":{

"uri":"https://my333968.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection(')",
"type":"c4codata.ServiceRequest",
"etag":"W/\"datetimeoffset\\'2020-04-15T09%3A55%3A37.5404120Z\\'\""
},
"ObjectID":"00163E2BE81A1EE7A7A930207E204E20",
"ID":"6",
"Name":"Test Ticket - Ignore",
"CompleteDuedatetimeContent":"2017-09-27T11:47:48Z"
}
]
}
}


вот что я хочу получит

Object ID ID Name CompleteDuedatetimeContent
00163E2BE81A1EE7A7A930207E204E20 6 Test Ticket - Ignore 2017-09-27T11:47:48Z



помогите