Hi team,
It worked for me this way:
df3 = pd.json_normalize(json2["value"], "Addresses")
print(df3)
ContactId AssociatedEntity
0 35aa05d1-21c7-493d-96e3-3c966732
ac7a9ec8-b71b-486b-8b3b-41b6bc11f936
1 ca717463-734d-4f2f-a01e-6ff0c806
bda08493-7ae0-47cf-8d3
Hi team,
My need is to extract particular sub-elements (ContactId and
AssociatedEntity) from below json using pandas.
Json:
{
"odata.metadata": "https://example1.com/odata/$metadata#Contacts";,
"value": [
{
"Addresses": [
{
"ContactId": "35aa05d1-21c7-493d-96e