Forum Documentation Showcase Pricing Learn more

API connector JSON format

Hey everyone, i’m trying to set up an api call that is returning poorly formatted JSON (imo anyways)

here’s the call/format

https://api.sleeper.app/v1/players/nfl/

{
“2103”: {
“injury_start_date”: null,
“fantasy_data_id”: 16426,
“last_name”: “Booth”,
“position”: “OT”,
“weight”: “285”,
“birth_date”: “1991-04-22”,
“team”: null,
“player_id”: “2103”,
“practice_participation”: null,
“fantasy_positions”: [
“OL”
],
“sportradar_id”: “4cd4976e-e230-4935-ad3f-c12876a41350”,
“yahoo_id”: 27841,
“news_updated”: null,
“rotoworld_id”: null,
“depth_chart_position”: null,
“age”: 27,
“depth_chart_order”: null,
“injury_body_part”: null,
“search_first_name”: “cody”,
“gsis_id”: null,
“full_name”: “Cody Booth”,
“search_rank”: 9999999,
“birth_city”: null,
“injury_notes”: null,
“years_exp”: 1,
“number”: 60,
“injury_status”: null,
“high_school”: null,
“practice_description”: null,
“rotowire_id”: 9866,
“college”: “Temple”,
“espn_id”: 17054,
“active”: false,
“sport”: “nfl”,
“birth_country”: null,
“height”: “6’5"”,
“first_name”: “Cody”,
“birth_state”: null,
“search_full_name”: “codybooth”,
“status”: “Inactive”,
“stats_id”: null,
“search_last_name”: “booth”,
“hashtag”: “#CodyBooth-NFL-FA-60
},
“6250”: {
“injury_start_date”: null,
“fantasy_data_id”: 21183,
“last_name”: “Bryant”,
“position”: “DT”,
“weight”: “”,
“birth_date”: null,
“team”: null,
“player_id”: “6250”,
“practice_participation”: null,
“fantasy_positions”: [
“DL”
],
“sportradar_id”: “9ff46edb-988f-4c8a-ad56-0502808ca1a6”,
“yahoo_id”: 32538,
“news_updated”: null,
“rotoworld_id”: null,
“depth_chart_position”: null,
“age”: null,
“depth_chart_order”: null,
“injury_body_part”: null,
“search_first_name”: “eurndraus”,
“gsis_id”: null,
“full_name”: “Eurndraus Bryant”,
“search_rank”: 9999999,
“birth_city”: null,
“injury_notes”: null,
“years_exp”: 0,
“number”: 0,
“injury_status”: null,
“high_school”: null,
“practice_description”: null,
“rotowire_id”: null,
“college”: null,
“espn_id”: 3916426,
“active”: true,
“sport”: “nfl”,
“birth_country”: null,
“height”: “”,
“first_name”: “Eurndraus”,
“birth_state”: null,
“search_full_name”: “eurndrausbryant”,
“status”: “Inactive”,
“stats_id”: null,
“search_last_name”: “bryant”,
“hashtag”: “#EurndrausBryant-NFL-FA-0
},
“4116”: {
“injury_start_date”: null,
“fantasy_data_id”: 18962,
“last_name”: “Garcia”,
“position”: “OT”,
“weight”: “293”,
“birth_date”: “1993-12-10”,
“team”: null,
“player_id”: “4116”,
“practice_participation”: null,
“fantasy_positions”: [
“OL”
],
“sportradar_id”: “a2b6e1f9-1f06-45e3-b6e9-79ec8490e5ef”,
“yahoo_id”: 30198,
“news_updated”: 1560221750273,
“rotoworld_id”: 12247,
“depth_chart_position”: “LT”,
“age”: 25,
“depth_chart_order”: 1,
“injury_body_part”: null,
“search_first_name”: “antonio”,
“gsis_id”: “00-0033922”,
“full_name”: “Antonio Garcia”,
“search_rank”: 9999999,
“birth_city”: null,
“injury_notes”: null,
“years_exp”: 2,
“number”: 79,
“injury_status”: null,
“high_school”: null,
“practice_description”: null,
“rotowire_id”: 11794,
“college”: “Troy”,
“espn_id”: 2972820,
“active”: true,
“sport”: “nfl”,
“birth_country”: null,
“height”: “6’6"”,
“first_name”: “Antonio”,
“birth_state”: null,
“search_full_name”: “antoniogarcia”,
“status”: “Inactive”,
“stats_id”: null,
“search_last_name”: “garcia”,
“hashtag”: “#AntonioGarcia-NFL-FA-79
},
etc etc

So the connector wants to identify this as each category being the leading player ID, but really i want all the keys inside the object to be labeled.

Anyone have an idea on how to do this?