How to convert result in json response to Data frame in python pandas

HI all i have json responce from below

responce = requests.get(url, auth=(user, pwd), headers=headers)  print(responce.json())  

output:

{'result': [{'promoted_by': '', 'parent': '', 'u_vendor_name': '', 'caused_by': '', 'watch_list': '', 'u_mim_coordinator': '', 'upon_reject': 'cancel', 'sys_updated_on': '2021-03-17 11:38:05', 'u_escalation_reason': '', 'approval_history': '', 'skills': '', 'number': 'INC1250551', 'proposed_by': '', 'lessons_learned': '', 'state': '2', 'sys_created_by': 'ertyuu', 'knowledge': 'false', 'order': '', 'cmdb_ci': '', 'delivery_plan': '', 'contract': '', 'impact': '3', 'u_desk_number': '', 'active': 'true', 'work_notes_list': '', 'priority': '3', 'sys_domain_path': '/', 'business_duration': '', 'group_list': '', 'u_region_impacted': '', 'u_mim_team_contacted_at': '', 'approval_set': '', 'major_incident_state': '', 'universal_request': '', 'short_description': 'issue in opening the server  FRPARVM61190617', 'correlation_display': '', 'u_error_code': '', 'work_start': '', 'u_site_impacted': '', 'additional_assignee_list': '', 'u_geography_impacted': '', 'notify': '1', 'service_offering': '', 'sys_class_name': 'incident', 'closed_by': '', 'follow_up': '', 'parent_incident': '', 'reopened_by': '', 'u_set_contact_type': 'Yes', 'reassignment_count': '1', 'assigned_to': {'link': 'https://dev123.service-now.com/api/now/table/sys_user/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'sla_due': '', 'comments_and_work_notes': '', 'u_service_owner_causing_service': '', 'u_bridge_attendees': '', 'u_category': {'link': 'https://dev123.service-now.com/api/now/table/u_group_it_custom/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'escalation': '0', 'u_incident_caused_by_change': 'false', 'upon_approval': 'proceed', 'correlation_id': '', 'timeline': '', 'made_sla': 'true', 'promoted_on': '', 'child_incidents': '0', 'hold_reason': '', 'task_effective_number': 'INC12504561', 'u_rejection_cause': '', 'resolved_by': '', 'sys_updated_by': 'aagent', 'opened_by': {'link': 'https://dev123.service-now.com/api/now/table/sys_user/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'u_short_description': '', 'user_input': '', 'sys_created_on': '2021-03-05 07:08:27', 'sys_domain': {'link': 'https://dev123.service-now.com/api/now/table/sys_user_group/global', 'value': 'global'}, 'proposed_on': '', 'actions_taken': '', 'u_causing_service': '', 'route_reason': '', 'calendar_stc': '', 'closed_at': '', 'u_vendor_dependency': '', 'business_service': {'link': 'https://dev123.service-now.com/api/now/table/ertyu/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'business_impact': '', 'rfc': '', 'time_worked': '', 'expected_start': '', 'u_cancel_reason': '', 'u_other_vendor': '', 'u_payroll': 'false', 'opened_at': '2021-03-05 07:08:27', 'work_end': '', 'caller_id': {'link': 'https://dev123.service-now.com/api/now/table/sys_user/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'reopened_time': '', 'resolved_at': '', 'subcategory': '', 'work_notes': '', 'close_code': '', 'assignment_group': {'link': 'https://dev123.service-now.com/api/now/table/sys_user_group/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'business_stc': '', 'cause': '', 'description': 'i was getting a blank screen after opening can u please help me on priority', 'calendar_duration': '', 'close_notes': '', 'sys_id': '0987654we45679i8u76345678', 'contact_type': 'self-service', 'incident_state': '2', 'urgency': '3', 'problem_id': '', 'company': {'link': 'https://dev123.service-now.com/api/now/table/core_company/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}, 'u_type': 'it_incident', 'activity_due': '', 'severity': '3', 'overview': '', 'comments': '', 'u_multiple_resolving_teams_involved': '', 'approval': 'not requested', 'due_date': '', 'sys_mod_count': '5', 'u_bridge_details': '', 'reopen_count': '0', 'sys_tags': '', 'u_describe_rejection_cause': '', 'u_mjr_inc_mgt_timeline': '', 'location': {'link': 'https://dev123.service-now.com/api/now/table/cmn_location/0987654we45679i8u76345678', 'value': '0987654we45679i8u76345678'}}]}  

https://stackoverflow.com/questions/66703279/how-to-convert-result-in-json-response-to-data-frame-in-python-pandas March 19, 2021 at 02:07PM