Get sales estimates grid

Page number (1-based)

Number of items per page

View identifier for saved grid configurations

Quick search text. Searches across: title, displayTitle

JSON string containing filter configuration.

Available Fields:

• id (string): Estimate ID
• type (string): Estimate type (PROJECT_DOCUMENT or EXPRESS_QUOTATION)
• title (string): Estimate title
• displayTitle (string): Display title (combined title/offerNumber based on documentStyle)
• organizationId (string): Organization ID
• projectId (string): Project ID
• taskId (string): Task ID (only for EXPRESS_QUOTATION)
• createdAt (date): Creation timestamp
• status (string): Estimate status (Draft, Final, WaitingForApproval, Pending, etc.)
• priceFixed (number): Fixed price
• priceSubscriptions (number): Subscription price
• pricePerUnit (number): Per-unit price
• createdById (string): Creator user ID
• offerNumber (number): Offer number (for PROJECT_DOCUMENT type)

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): Estimate ID (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• type (string): Estimate type (PROJECT_DOCUMENT or EXPRESS_QUOTATION) (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• title (string): Estimate title (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• displayTitle (string): Display title (combined title/offerNumber based on documentStyle) (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• organizationId (string): Organization ID (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
• taskId (string): Task ID (only for EXPRESS_QUOTATION) (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• createdAt (date): Creation timestamp (date filter). Available comparisons: equal, not_equal, >, <, >=, <=, between, lastMonth, thisMonth, is_empty, is_not_empty
• status (string): Estimate status (Draft, Final, WaitingForApproval, Pending, etc.) (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• priceFixed (number): Fixed price (number filter). Available comparisons: equal, not_equal, >, <, >=, <=, is_empty, is_not_empty
• priceSubscriptions (number): Subscription price (number filter). Available comparisons: equal, not_equal, >, <, >=, <=, is_empty, is_not_empty
• pricePerUnit (number): Per-unit price (number filter). Available comparisons: equal, not_equal, >, <, >=, <=, is_empty, is_not_empty
• createdById (string): Creator user ID (string filter). Available comparisons: contain, not_contain, equal, starts_with, ends_with, is_empty, is_not_empty
• offerNumber (number): Offer number (for PROJECT_DOCUMENT type) (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: Estimate ID
• type: Estimate type (PROJECT_DOCUMENT or EXPRESS_QUOTATION)
• title: Estimate title
• displayTitle: Display title (combined title/offerNumber based on documentStyle)
• organizationId: Organization ID
• organizationName: Organization name
• projectId: Project ID
• projectName: Project name
• taskId: Task ID (only for EXPRESS_QUOTATION)
• taskShortNumber: Task short number (only for EXPRESS_QUOTATION)
• createdAt: Creation timestamp
• status: Estimate status (Draft, Final, WaitingForApproval, Pending, etc.)
• total: Total price (for express quotations)
• priceFixed: Fixed price
• priceSubscriptions: Subscription price
• pricePerUnit: Per-unit price
• createdById: Creator user ID
• createdByName: Creator name
• offerNumber: Offer number (for PROJECT_DOCUMENT type)

Sort Structure:

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

Default Sort: createdAt (desc)

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

Available Fields: id, type, title, displayTitle, organizationId, organizationName, projectId, projectName, taskId, taskShortNumber, createdAt, status, total, priceFixed, priceSubscriptions, pricePerUnit, priceSubscriptionsDetail, pricePerUnitDetail, createdById, createdByName, offerNumber, formattedOfferNumber