title: How to access Clockify API through Excel Power Query
body: <p>I am new to Clockify and to API usage (so I apologize if I express myself not properly). My objective is to automatically load in Excel (via Power Query) the detailed report with all time entries. I have tried the below code and it works ... but for the fact that I got just the latest 50 time entries. </p>
  
  <p>This because, as I understand properly, I should use this base Endpoint: "<a href="https://api.clockify.me/api/v1" rel="nofollow noreferrer">https://api.clockify.me/api/v1</a>" (the one I use is deprecated). Is there a way to make the below work on the correct Endpoint?</p>
  
  <pre><code>let Source = Web.Contents("https://api.clockify.me/api/reports/{your report ID}", [https://api.clockify.me/api", #"X-Api-Key"="{your API Key}"]]), jsonResponse = Json.Document(Source), workspace = jsonResponse[workspace] in workspace
  </code></pre>
  
  <p>Thanks in advance,</p>