Power Query to extract data from a password protected website

[Hypnopoison]

Hi all, I was hoping I could ask for some advice on Power Query please.

I have an email marketing platform which I would like to link my Excel file to using Power Query.
I am the owner of the account and have the user name and password for this site, but when trying the query 'From other sources' > 'From web', it doesn't work.

It just gives me a table with column headers: Kind, Name, Children, Text

I'm relatively new to the world of Power Query - and any advice on how best to achieve this would be really appreciated (and save me hours of manually typing into a spreadsheet to monitor email marketing results too)


Thanks
Debbie

 

[Hypnopoison]

Hi, just to let you know I solved it. I contacted my email marketing provider and they provided me with API details and key. I've needed to connect a few different sets of data to get what I need but it works. Just need to work out how to only extract data form a specific time period now, say last 3 months each time (rather than updating everything), and I'll have a super simple tool for extracting and analysing campaign performance. Sooo excited