Onderwerp: Import XML into Excel or Power BI

Hello, I am new in sokker. I have been trying to import my team's data into excel or Power BI but haven't been able to do so. I understand that in the web browser is possible to access the XML after "logging" and the authentication gets stored as a cookie. I don't know how to do so with Power Query. Does anybody knows how to retrieve a team's data into Excel or Power BI?
Thanks

I know it does not technically answer your question but...is hopefully helpful.

Are you trying to do something that cannot be done with Sokker Asistente?
https://sokker.org/forum_topic/ID_forum/1259/ID_topic/3432409/pg/1
https://raqueto.com/sokker/asistente

or older and unmaintained but still somewhat usable:

Sokker Viewer:
https://sokker.org/forum_topic/ID_forum/12246/ID_topic/3328684/pg/1
https://www.dropbox.com/s/u7s2byyiu7607eq/sokker_viewer64.zip?dl=1

Sokker Organizer:
https://sokker.org/forum_topic/ID_forum/1259/ID_topic/3481864/pg/1
https://sites.google.com/site/sokkerorganizer/

I don't use Excel, nor Power BI. Didn't use the Sokker APIs either, but maybe this will be of any help.

Documentation for API that you can use to get JSON data. https://sokker.org/apidoc.html
Information about accessing XML files. https://sokker.org/xmlinfo
(gewijzigd)
(gewijzigd)

You could use api json https://sokker.org/apidoc.html as source of data.

After that, didn't know if Power Query is capable to get web json files.
Maybe start here : https://learn.microsoft.com/en-us/power-query/connectors/json
(gewijzigd)