Get overdue invoices grid

Page number (1-based)

Number of items per page

View identifier for saved grid configurations

Quick search text. Searches across: number

JSON string containing filter configuration.

Available Fields:

• id (string): Invoice ID
• number (string): Invoice number
• projectId (string): Project ID
• type (set): Invoice type (Mixed, Subscription, TimeBased, ExpressQuotation, SingleProject, InterimPayment)
• createdAt (date): Invoice creation date
• sentAt (date): Date when invoice was sent
• dueDate (date): Payment due date
• firstReminderAt (date): Date when first reminder was sent
• secondReminderAt (date): Date when second reminder was sent
• netto (number): Net amount (before taxes and fees)
• status (set): Invoice status (New, Sent)
• overdueDays (number): Number of days overdue

Filter Structure:

[
  {
    "type": "string|number|date|set|boolean|array|task_status|task_type",
    "fieldName": "field_name",
    "value": {
      "comparison": "comparison_type",
      "value": "filter_value"
    }
  }
]

Group Filters (AND/OR Combinations):

[
  {
    "type": "group",
    "fieldName": "group0.18807479823070028",
    "value": {
      "type": "or",
      "filters": [
        {
          "type": "string",
          "fieldName": "fileName",
          "value": {
            "comparison": "contain",
            "value": "aa"
          }
        },
        {
          "type": "number",
          "fieldName": "rowCount",
          "value": {
            "comparison": ">=",
            "value": 33
          }
        }
      ]
    }
  }
]

Available Comparison Operators:

• id (string): Invoice ID (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• number (string): Invoice number (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• projectId (string): Project ID (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• type (set): Invoice type (Mixed, Subscription, TimeBased, ExpressQuotation, SingleProject, InterimPayment) (set filter). Available comparisons: in, not_in, is_empty, is_not_empty
• createdAt (date): Invoice creation date (date filter). Available comparisons: equal, not_equal, >, <, >=, <=, between, lastMonth, thisMonth, is_empty, is_not_empty
• sentAt (date): Date when invoice was sent (date filter). Available comparisons: equal, not_equal, >, <, >=, <=, between, lastMonth, thisMonth, is_empty, is_not_empty
• dueDate (date): Payment due date (date filter). Available comparisons: equal, not_equal, >, <, >=, <=, between, lastMonth, thisMonth, is_empty, is_not_empty
• firstReminderAt (date): Date when first reminder was sent (date filter). Available comparisons: equal, not_equal, >, <, >=, <=, between, lastMonth, thisMonth, is_empty, is_not_empty
• secondReminderAt (date): Date when second reminder was sent (date filter). Available comparisons: equal, not_equal, >, <, >=, <=, between, lastMonth, thisMonth, is_empty, is_not_empty
• netto (number): Net amount (before taxes and fees) (number filter). Available comparisons: equal, not_equal, >, <, >=, <=, is_empty, is_not_empty
• status (set): Invoice status (New, Sent) (set filter). Available comparisons: in, not_in, is_empty, is_not_empty
• overdueDays (number): Number of days overdue (number filter). Available comparisons: equal, not_equal, >, <, >=, <=, is_empty, is_not_empty

Note: Use quickSearch parameter for simple text search instead of adding it to filters.

JSON array of sort objects.

Sortable Fields:

• id: Invoice ID
• number: Invoice number
• projectId: Project ID
• type: Invoice type (Mixed, Subscription, TimeBased, ExpressQuotation, SingleProject, InterimPayment)
• createdAt: Invoice creation date
• sentAt: Date when invoice was sent
• dueDate: Payment due date
• firstReminderAt: Date when first reminder was sent
• secondReminderAt: Date when second reminder was sent
• netto: Net amount (before taxes and fees)
• status: Invoice status (New, Sent)
• overdueDays: Number of days overdue

Sort Structure:

[
  {
    "field": "field_name",
    "direction": "asc|desc"
  }
]

Default Sort: overdueDays (desc)

Comma-separated list of field names to include in response items. If not provided, all fields are returned.

Available Fields: id, number, projectId, type, createdAt, sentAt, dueDate, firstReminderAt, secondReminderAt, netto, status, overdueDays