importing dynamic json file

Question

Hi,&nbsp;&nbsp;I am a keen player of fantasy Premier League, and are looking for a way to load team-picks for the players in my private league. The link below shows the structure of the link:&nbsp;https://fantasy.premierleague.com/drf/entry/722115/event/1/picks&nbsp;722115 = my team_id1 = round number&nbsp;I am looking for a simple M script that can update a flat table based on a table of team_ids and round_numbers. Furhtermore, the array of round number should be within the range of 1 and last round played (can be a parameter). Below is a copy of the current Advanced Editor:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;best,Jan Nylund&nbsp;&nbsp;&nbsp;

anonymous · Answer

Jannis68,Please check parameters in the query editor of attached PBIX file.Regards,Lydia

jannis68 · Answer

Hi,&nbsp;a good start. I looking for a way to update my table with all rounds played and all players in my league. Both players and rounds could be in separate tables. If I had performed this in Python, I would have used a look. Is there a similar function here?&nbsp;best,Jan&nbsp;&nbsp;

anonymous · Answer

Jannis68，Yes. You can choose "Query" when creating parameters. For more details, please review this similar thread:https://community.powerbi.com/t5/Desktop/Using-a-table-column-as-a-list-of-values-for-a-parameter/td-p/395121.
Regards,Lydia

jannis68 · Answer

Hi,&nbsp;still not there, as far as I can see you only end up with the picks for one player for one round. What I am looking for is a smooth way to open the follwoing links (and to add rounds automatically ):&nbsp;https://fantasy.premierleague.com/drf/entry/722115/event/1/pickshttps://fantasy.premierleague.com/drf/entry/7707/event/1/pickshttps://fantasy.premierleague.com/drf/entry/722115/event/2/pickshttps://fantasy.premierleague.com/drf/entry/7707/event/2/picks.....Both Player and Round could be a list, my question is how to merge these lists into&nbsp;&nbsp;best,Jan&nbsp;

anonymous · Answer

Jannis68,What do you mean merge lists? In your scenario, you would need to create two parameters , one for team id, one for round, and you should choose "Query" as suggested value when creating these parameters.Regards,Lydia

Forum Discussion

importing dynamic json file

5 Replies

Related content

Import dataflowgen2 JSON file.

Fabric having issues importing or ingesting json files and responses

Error importing dataflow (json)

ELT JSON / Semi structured

Importing dynamic named worksheets