importing dynamic json file

[Jannis68]

Hi, 

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:

https://fantasy.premierleague.com/drf/entry/722115/event/1/picks

• 722115 = my team_id
• 1 = round number

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:

 

best,

Jan Nylund

[Anonymous]

@Jannis68,

Please check parameters in the query editor of attached PBIX file.

Regards,
Lydia

[Jannis68]

Hi,

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?

best,

Jan

[Anonymous]

@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....

Regards,
Lydia

[Jannis68]

Hi,

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 😞

https://fantasy.premierleague.com/drf/entry/722115/event/1/picks

https://fantasy.premierleague.com/drf/entry/7707/event/1/picks

https://fantasy.premierleague.com/drf/entry/722115/event/2/picks

https://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 

best,

Jan

[Anonymous]

@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