0

I am struggling to pull reported data in Clockify to google spreadsheet, here's the code I am trying to trigger.

function getClockifyReport() {
  const headers = {
    "headers": {
      "X-Api-Key": "[APIKEY]",
      "content-type": "application/json",
      "Accept": "*/*"
    }
  };
  
  const workspaceId = "WORKSPACE_ID";
  
  const url = `https://reports.api.clockify.me/v1/workspaces/${workspaceId}/reports/detailed?userGroupIds=all&projectIds=all&clientIds=all&billable=null&invoiced=null&approved=null&sortByDate=null&sortAscending=null&page=1&pageSize=50&considerDurationFormat=null&roundingMinutes=null&formatted=false`;
  
  const response = UrlFetchApp.fetch(url, headers);
  const data = JSON.parse(response.getContentText());
  
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet 1");
  sheet.clear();
  sheet.appendRow(["Description", "Start Time", "End Time", "Duration", "User", "Client", "Project"]);

  data.timeEntries.forEach((entry) => {
    sheet.appendRow([
      entry.description,
      entry.timeInterval.start,
      entry.timeInterval.end,
      entry.timeInterval.duration,
      entry.user.name,
      entry.client.name,
      entry.project.name
    ]);
  });
}

If you'd like to test the script, open a google spreadsheet > Extensions > apps script. Clockify documentation: https://docs.clockify.me/

What am I doing wrong?

Tried adjusting the code like 100 times and spent hours of research without any luck on solving this.

I am expecting to pull all available reported data in clockify by users, and automate the reporting process in google spreadsheets.

Wassim
  • 1
  • 1
  • I have to apologize for my poor English skill. Unfortunately, I cannot undertand your current issue. Can I ask you about the detail of your current issue? – Tanaike Mar 07 '23 at 23:13
  • I need to pull reported data from Clockify API service to automate the reporting process in Google Spreadsheets. However, I am struggling to do so using the code I provided as it's not working as it should, and the process involves authentication, querying the data, and transferring it to the destination. I am looking for someone who can review the code and documentation I provded and help build a better version if the code is the problem. the goal is to pull data from Clockify to Google Spreadsheet using Apps script function and this is done best via Javascript. – Wassim Mar 08 '23 at 19:26

1 Answers1

0

from what I see there are couple of things fundamentally wrong with your code, starting with the headers. You never specify the type of the request being sent.

If you look at the documentation you'll see that the request for getting the report is actually a POST request with a body, without any parameters. So, to begin with, specify type of the request, add a valid body, remove the parameters and then see how it goes from there. Open a detailed report using a desired date range on the clockify app and maybe see how the request looks like. Ignore the parameters in the URL, as they are not being sent to the server, which you'll see in the network tab. The app behaves differently, and generates reports asynchronously, but the initial request remains the same.

Cheers.

blabla
  • 1