Open APIs
GitHub – public-apis/public-apis: A collective list of free APIs
HTTP API for Latest Covid-19 Data – Pipedream
Request
Excel
Paste URL
Auth, this is open so anon
Result in Power Query Editor
ELT process
Into table
Press list on rawData
View on record
Unpivoted only selected
Drill down
lets view a record
A record
Into table for that record is success
Revert the last step in the query settings and try to convert the list to table.
Power Query Web connector – Power Query | Microsoft Learn
Funny data, just error
Lets start fresh
makeup-api.herokuapp.com/api/v1/products.json
There is also an Advanced Editor
