Forum Discussion
API URL and Parameters
Is it possible to set the ?_limit=1500 amount via a Parameter? Want to have a parameter that I can type in 1500 and have it apply to all my API connections. Thanks! Json.Document(Web.Contents("...
The syntax you are giving me is not setting the limit. The limit is setting to the default of 100. This is what I have:
= Json.Document(Web.Contents("https://acme.demo.com/api/v1/" & "sessionrecords.json" & "?_limit=&ParameterLimit" & "_offset=10000", [Timeout=#duration(0, 0, 45, 0), Headers=[#"Content-Type"="application\json", Authorization="Token XXXXXXXXXXXXXXXXXXXXXXXXXXX"]]))