FlowmageDocs

Summary report

BetaReads data

Runs Clockify's summary report, grouped the way you choose.

Settings

SettingWhat it is
ConnectionRequiredThe Clockify connection the step signs in with.
Workspace id overrideLeave empty to use the workspace on the connection. Pick another workspace the same key can reach, or type its id — the List workspaces node gives you the ids. The id pickers on this node list from it.
Period"ABSOLUTE" or "TODAY" or "YESTERDAY" or "THIS_WEEK" or "LAST_WEEK" or "PAST_TWO_WEEKS" or "THIS_MONTH" or "LAST_MONTH" or "THIS_YEAR" or "LAST_YEAR"
Fromtext
Totext
Answer asRows come back as data you can loop over. Every other choice comes back as a file — which shape Clockify sends that file in is owed one run against a real workspace.
Group byThe grouping chain, in order — Project then Person gives a row per project with its people underneath.
Chart"" or "BILLABILITY" or "PROJECT"
Sort by"GROUP" or "DURATION" or "AMOUNT" or "EARNED" or "COST" or "PROFIT"
PeoplePicked from the list Clockify offers.
ProjectsPicked from the list Clockify offers.
ClientsPicked from the list Clockify offers.
TasksPicked from the list Clockify offers.
TagsPicked from the list Clockify offers.
Billable"" or "true" or "false"
Approval"ALL" or "APPROVED" or "UNAPPROVED"
Invoicing"ALL" or "INVOICED" or "UNINVOICED"
Description containstext
Only entries with no descriptiontrue/false
Round the way the workspace doestrue/false
Amounts"HIDE_AMOUNT" or "EARNED" or "COST" or "PROFIT" or "EXPORT"
Direction"ASCENDING" or "DESCENDING"
Time zonetext
Week starts on"MONDAY" or "TUESDAY" or "WEDNESDAY" or "THURSDAY" or "FRIDAY" or "SATURDAY" or "SUNDAY"
Anything elseAnything else from Clockify's report filter, merged over the fields above. The fields above win only where this leaves a key out.
Technical details
KeyValue
connectiontexta connection id from `requires.connections` (provider `clockify`)
workspaceIdtexta value from the vendor's own list
dateRangeType"ABSOLUTE" or "TODAY" or "YESTERDAY" or "THIS_WEEK" or "LAST_WEEK" or "PAST_TWO_WEEKS" or "THIS_MONTH" or "LAST_MONTH" or "THIS_YEAR" or "LAST_YEAR", by default "LAST_MONTH"
dateRangeStarttextused when `dateRangeType` is "ABSOLUTE"
dateRangeEndtextused when `dateRangeType` is "ABSOLUTE"
exportType"JSON" or "CSV" or "XLSX" or "PDF" or "ZIP", by default "JSON"
groupslist of {group: text}, by default [{"group":"PROJECT"}]
summaryChartType"" or "BILLABILITY" or "PROJECT"
sortColumn"GROUP" or "DURATION" or "AMOUNT" or "EARNED" or "COST" or "PROFIT", by default "GROUP"
userIdstexta value from the vendor's own list
projectIdstexta value from the vendor's own list
clientIdstexta value from the vendor's own list
taskIdstexta value from the vendor's own list
tagIdstexta value from the vendor's own list
billable"" or "true" or "false"
approvalState"ALL" or "APPROVED" or "UNAPPROVED", by default "ALL"
invoicingState"ALL" or "INVOICED" or "UNINVOICED", by default "ALL"
descriptiontext
withoutDescriptiontrue/false, by default false
roundingtrue/false, by default false
amountShown"HIDE_AMOUNT" or "EARNED" or "COST" or "PROFIT" or "EXPORT", by default "HIDE_AMOUNT"
sortOrder"ASCENDING" or "DESCENDING", by default "ASCENDING"
timeZonetext
weekStart"MONDAY" or "TUESDAY" or "WEDNESDAY" or "THURSDAY" or "FRIDAY" or "SATURDAY" or "SUNDAY", by default "MONDAY"
filterobject (any keys), by default {}

Output

FieldType
groupOneGroupsarray
totalsarray
fileReport file, or nothing when the answer is rowsany
file.base64Report file (base64)string
file.namestring
file.contentTypestring
file.sizeSize in bytesnumber
Sample output, and the expression for each field
  • filenull
  • groupOne[]
  • totals[]

Errors

When a step of this node stops a run, the run page shows a code. Look it up:

Example step

The step as a flow file holds it. Replace each value in <…>.

{
  "config": {
    "amountShown": "HIDE_AMOUNT",
    "approvalState": "ALL",
    "billable": "",
    "clientIds": "",
    "connection": "<connection id>",
    "dateRangeEnd": "",
    "dateRangeStart": "",
    "dateRangeType": "LAST_MONTH",
    "description": "",
    "exportType": "JSON",
    "filter": {},
    "groups": [
      {
        "group": "PROJECT"
      }
    ],
    "invoicingState": "ALL",
    "projectIds": "",
    "rounding": false,
    "sortColumn": "GROUP",
    "sortOrder": "ASCENDING",
    "summaryChartType": "",
    "tagIds": "",
    "taskIds": "",
    "timeZone": "",
    "userIds": "",
    "weekStart": "MONDAY",
    "withoutDescription": false,
    "workspaceId": ""
  },
  "label": "Summary report",
  "type": "clockify.summaryReport",
  "version": 1
}