GET/projects/api/v3/reporting/financial/trends.json

Get financial report trends.

Returns metrics over time: the same paged set of entities repeated across each period, gap-filled with zeros. The endpoint forces date grouping; pass exactly one entity dimension in groupBy (e.g. company ⇒ company,date). startDate and endDate are required. orderBy accepts name, <metricKey> (aggregated over the range), or <periodIndex>-<metricKey> (0-based, chronological) to rank by one period's column; the candidate set is always the entities active across the full range.

Query Params

  • Name
    startDate
    Type
    string
    Description

    start date

  • Name
    orderMode
    Type
    string
    Description

    order mode

    Default
    asc
    Allowed values
    • asc
    • desc
  • Name
    orderBy
    Type
    string
    Description

    order by field; for /trends: name, <metricKey> (full-range aggregate), or <periodIndex>-<metricKey> (0-based, chronological)

  • Name
    endDate
    Type
    string
    Description

    end date

  • Name
    dateGranularity
    Type
    string
    Description

    date granularity (only when date in groupBy)

    Allowed values
    • daily
    • weekly
    • monthly
    • quarterly
    • yearly
  • Name
    pageSize
    Type
    integer
    Description

    number of items in a page

    Default
    50
  • Name
    page
    Type
    integer
    Description

    page number

    Default
    1
  • Name
    userIds
    Type
    array[integer]
    Description

    filter by user ids

    Format
    Comma separated values
  • Name
    tasklistIds
    Type
    array[integer]
    Description

    filter by tasklist ids

    Format
    Comma separated values
  • Name
    tasklistBudgetIds
    Type
    array[integer]
    Description

    filter by tasklist budget ids

    Format
    Comma separated values
  • Name
    taskIds
    Type
    array[integer]
    Description

    filter by task ids

    Format
    Comma separated values
  • Name
    projectIds
    Type
    array[integer]
    Description

    filter by project ids

    Format
    Comma separated values
  • Name
    projectBudgetIds
    Type
    array[integer]
    Description

    filter by project budget ids

    Format
    Comma separated values
  • Name
    metrics
    Type
    array[string]
    Description

    selected fact metrics to include

    Format
    Comma separated values
  • Name
    include
    Type
    array[string]
    Description

    include

    Format
    Comma separated values
    Allowed values
    • companies
    • projects
    • users
    • tasks
    • tasklists
    • projectbudgets
    • tasklistbudgets
    • timelogs
    • allocations
  • Name
    groupBy
    Type
    array[string]
    Description

    group by dimensions (ordered chain)

    Format
    Comma separated values
    Allowed values
    • company
    • project
    • projectbudget
    • tasklist
    • tasklistbudget
    • task
    • user
    • timelog
    • allocation
    • billablerate
    • costrate
    • date
  • Name
    filter
    Type
    array[any]
    Description

    advanced filter (JSON)

    Format
    Comma separated values
  • Name
    companyIds
    Type
    array[integer]
    Description

    filter by company ids

    Format
    Comma separated values

Responses

  • Code
    200
    Type
    object
    Schema
    Description
    200 OK
    FinancialReportTrendsResponse is the top-level response for the financial report trends endpoint.
  • Code
    400
    Type
    object
    Schema
    Description
    400 Bad Request
    ErrorResponse defines how []Error should be marshaled to JSON.
  • Code
    500
    Type
    object
    Schema
    Description
    500 Internal Server Error
    ErrorResponse defines how []Error should be marshaled to JSON.

Examples

200 OK

FinancialReportTrendsResponse
{  "data": [    {      "granularity": "string",      "period": "string",      "periodData": [        {          "dateGroup": "string",          "dimensions": {            "additionalProp": 0          },          "relationships": {            "additionalProp": {              "id": 0,              "meta": {},              "type": "string"            }          },
Download Swagger