Good afternoon, using Google script I’m trying to get a detailed report from all the times informed in Clockify. In order to do that, i’m using the following code:
function ClockifyGetReport() {
var activeSheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = activeSheet.getSheetByName(‘Test’);
var headers = {“X-Api-Key” : “MyAPIKey”, “content-type” : “application/json”};
var payload = {
“dateRangeStart”: “2022-05-10T00:00:00”,
“dateRangeEnd”: “2023-01-09T23:59:59”,
“summaryFilter”: {
“groups”: [“PROJECT”],
“sortColumn”: “GROUP”
},
“exportType”: “JSON”
};
var clockifyoptions = {
‘method’ : ‘post’,
‘headers’ : headers,
‘payload’ : payload
};
UrlFetchApp.fetch(‘https://api.clockify.me/api/v1/workspaces/{WorkspaceId}/reports/detailed’, clockifyoptions);
}
But I keep getting the following error:
Exception: Request failed for https://api.clockify.me returned code 404. Truncated server response: {“timestamp”:“2023-01-10T19:06:26.110+00:00”,“status”:404,“error”:“Not Found”,“path”:“/v1/workspaces/{WorkspaceId}/reports/detailed”} (use muteHttpExceptions option to examine full response).
Anyone can help me with this issue?