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?

I also have an idea for a fantasy sports app are you using sportsdata.io

I am not directly using sportsdata.io, but some of the data i use is downstream from them i believe.