I completed an API pull, and end up with a return with a dict of values show below —

this is one instance of the return, there is about 650 more in the dictionary.

[{‘ref’: ‘#40:5492’,
‘id’: ‘23250’,
‘values’: [‘23250’,
‘Amortization Term’,
‘This column captures the total duration or time period over which the loan is scheduled to be completely paid-off (amortized)’,
‘AT-23250’,
‘7697’,
‘INSTRMNT_CRDT’,
”,
”,
’99’,
‘SFK EDM’,
‘Unknown’,
”,
‘0.0’,
”,
”,
”,
”,
‘Optional’,
‘Creator’,
’12’,
‘2022-01-13’,
‘2024-03-29’,
‘ENTERPRISE’,
‘Enterprise’,
”,
”]}

I want to create a dataframe from this dict where these are the BOLDED values,and the list below are ‘id’,
‘name’,
‘definition’,
‘refNumber’,
‘dataSetId’,
‘dataSetName’,
‘dbName’,
‘dbFormat’,
‘systemId’,
‘systemName’,
‘origination’,
‘discoveryReviewStatus’,
‘confidenceScore’,
‘editabilityRole’,
‘editability’,
‘glossaryId’,
‘glossaryName’,
‘mandatory’,
‘createdBy’,
‘createdById’,
‘createdDate’,
‘lastUpdatedDate’,
‘segments’,
‘segmentsName’,
‘DataStructure’,
‘DBTableName’the respective headers

[]

I am generally new to python so this is new work for me.