I am trying to get data into Excel Power Query from an API with API key
In Postman it works with this:
https://api.spoonacular.com/recipes/complexSearch?query=pasta&maxFat=25&number=10
x-api-key 28fa216f987c42bea1f3xxxxxxxxxxxx
I am trying to use the “Web-API” key but Excel returns “You can only use an internet-API-key when the name on the internet-API-key is delivered” (translated)
How do I get these data into Excel Power Query?
Thank you.
//Michael
New contributor
Michael Vejlgård is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.