Recently I succeeded in connecting Power Query with an API of a supplier to download data. I can only download 31 days at a time. Can anyone assist me in doing so?
In below is the working version for a single period. I was planning to turn the query into a function and make "from" and "to" dates as text parameters, but I ran into a problem "Web.Contents failed to get contents from... (500)" because of introducing the dates as parameters.