Get orders using advanced filtering

Add MCP server to your AI tool

Allow AI tools and LLMs to interact with the API documentation portal through MCP.

MCP server URL

https://restapi.wyzio.com/mcp

Standard setup for AI tools providing an mcp.json file

mcp.json
{
  "Wyzio MCP server": {
    "url": "https://restapi.wyzio.com/mcp"
  }
}

Close
GET /api-v1/orders/advanced

Returns a list of orders with support for advanced filtering, sorting, and pagination.

Headers

  • WEAL-TOKEN Required

    API token (can be retrieved from account settings)

  • TARGET-ORGANIZATION-ID

    ID of organization, for which the operation must be performed

Query parameters

  • pageNumber integer

    Page Number

    Default value is 1.

  • sortingField string

    Field to sort by

  • direction string

    Sorting direction

    Values are ASC or DESC. Default value is ASC.

  • sizePerPage integer

    Size per page

    Default value is 60.

  • id string

    Order ID filter.

    Multi-value supported. Example: value1;value2

  • name string

    Order name filter

  • orderId string

    Internal order number / code filter

  • date string

    Order date filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • 01/01/2026..31/12/2026
    • >=01/01/2026
    • <=01/01/2026
    • <>01/01/2026

    Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.

  • description string

    Order description filter

  • contactName string

    Client contact name filter

  • contactId string

    Client contact ID filter.

    Multi-value supported. Example: value1;value2

  • status string

    Order status filter

    Values are OFFERED, OFFERED_SENT, CONFIRMED, CONFIRMED_SENT, BILLABLE, FINISHED, or CANCELLED.

  • isExpensesEnabled boolean

    Whether expenses are enabled for the order

  • orderAmount string

    Order amount filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • creatorContactId string

    Whether the order was created by, or has, the current user's contact ID.

    Multi-value supported. Example: value1;value2

  • hasWarnings boolean

    Whether the order has warnings

  • validated boolean

    Whether the order is validated

  • clientEmail string

    Client email filter

  • isInvoiceGenerated boolean

    Whether the order is currently generating an invoice

  • isPeriodic boolean

    Whether the order is periodic (recurring)

  • isInWorkflow boolean

    Whether the order is currently part of an active workflow

  • parentOrderId string

    Parent order ID filter.

    Multi-value supported. Example: value1;value2

  • departmentId string

    Department IDs filter.

    Supported values:

    • -1 — records where value is not assigned
    • ID
    • Multiple values separated by ;

    Examples:

    • -1
    • 10
    • 10;15;20
  • officeId string

    Office ID filter.

    Multi-value supported. Example: value1;value2

  • vatRateId string

    VAT rate ID filter.

    Multi-value supported. Example: value1;value2

  • requestedPaymentTerms integer(int32)

    Requested payment terms in days filter

  • currencyId string

    Currency ID filter.

    Multi-value supported. Example: value1;value2

  • minimumAmountToInvoice string

    Minimum invoiceable amount filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • ourContactName string

    Our contact name filter

  • yourContactName string

    Client's internal contact name filter

  • periodicityStartDate string

    Recurring order periodicity start date filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • 01/01/2026..31/12/2026
    • >=01/01/2026
    • <=01/01/2026
    • <>01/01/2026

    Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.

  • isDisbursementFeeEnabled boolean

    Whether disbursement fee is enabled for the order

  • isTimesheetsEnabled boolean

    Whether timesheets are enabled for the order

  • timesheetsAccountId string

    Timesheets chart of accounts ID filter.

    Multi-value supported. Example: value1;value2

  • fixedAmount string

    Fixed amount filter (for TIMESHEET_FIXED orders)Supports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • orderArticleId string

    Order article ID filter.

    Multi-value supported. Example: value1;value2

  • orderArticleUnitPrice string

    Order article unit price filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • orderArticleAmount string

    Order article quantity filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • orderArticleDiscount string

    Order article discount filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • orderArticleTotalNet string

    Order article net total filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • <=100.00
    • >=100.00
    • <>100.00
    • 100.00..200.00

    Use <>0 to return only records where the selected amount is not equal to zero.

  • orderArticleStatus string

    Order article status filter

    Values are SHIPPED, PARTIALLY_SHIPPED, NOT_SHIPPED, or SERVICE.

  • historyStatus string

    Order status history entry status filter

    Values are OFFERED, OFFERED_SENT, CONFIRMED, CONFIRMED_SENT, BILLABLE, FINISHED, or CANCELLED.

  • historyDate string

    Order status history entry date filterSupports comparison operators:

    • Range ( .. )
    • Greater than ( > )
    • Greater than or equal ( >= )
    • Less than ( < )
    • Less than or equal ( <= )
    • Not equal ( <> )

    Examples:

    • 01/01/2026..31/12/2026
    • >=01/01/2026
    • <=01/01/2026
    • <>01/01/2026

    Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.

  • addressName string

    Delivery address name filter

  • addressClientName string

    Delivery address client name filter

  • addressStreet string

    Delivery address street filter

  • addressStreetPoBox string

    Delivery address P.O. box / street line 2 filter

  • addressZipCode string

    Delivery address postal code filter

  • addressCity string

    Delivery address city filter

  • addressCountryCode string

    Delivery address ISO 3166-1 alpha-2 country code filter

  • addressRegionCode string

    Delivery address region code filter

  • addressToTheAttentionOf string

    Delivery address 'to the attention of' filter

  • yourReference string

    Client's reference filter

  • orderValidity integer(int64)

    Order validity in days filter

  • paymentAccountId string

    Payment chart of accounts ID filter.

    Multi-value supported. Example: value1;value2

  • hasProformaInvoice boolean

    Whether the order has a proforma invoice

Responses

  • 200 application/json

    OK

    Hide response attributes Show response attributes object
    • id integer(int64)
    • name string
    • orderId string
    • date string(date-time)
    • description string
    • contactName string
    • contactId integer(int64)
    • organizationId integer(int64)
    • warnings string
    • status string

      Values are OFFERED, OFFERED_SENT, CONFIRMED, CONFIRMED_SENT, BILLABLE, FINISHED, or CANCELLED.

    • isExpensesEnabled boolean
    • isPrePaymentAvailable boolean
    • isPartialPaymentAvailable boolean
    • orderAmount number
    • creatorContactId integer(int64)
    • hasWarnings boolean
    • validated boolean
    • clientEmail string
    • clientECorrespondence boolean
    • workflowPermissions string
    • isInvoiceGenerated boolean
    • isPeriodic boolean
    • isInWorkflow boolean
    • flagsAmount integer(int32)
    • activeSubOrderId integer(int64)
    • activeSubOrderInvoicingDate string(date-time)
    • systemValidated boolean
    • clientOrderEmail string
    • clientAdvancedInvoicingNote string
    • hasProformaInvoice boolean
    • parentOrderId integer(int64)
    • parentOrderName string
    • departmentId integer(int64)
    • departmentName string
    • officeId integer(int64)
    • officeName string
    • vatRateId integer(int64)
    • vatRateName object
      Hide vatRateName attributes Show vatRateName attributes object
      • en string
      • fr string
      • de string
      • it string
    • requestedPaymentTerms integer(int32)
    • currencyId integer(int64)
    • currency string
    • minimumAmountToInvoice number
    • ourContactName string
    • yourContactName string
    • periodicityStartDate string(date-time)
    • periodicityType string

      Values are NONE, DAILY, WEEKLY, BI_WEEKLY, EVERY_MONTH, EVERY_2_MONTH, EVERY_3_MONTH, EVERY_4_MONTH, EVERY_6_MONTH, or ANNUAL.

    • dayOfWeek string

      Values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, or SUNDAY.

    • invoicingTime string

      Values are FIRST_DAY, LAST_DAY, FIRST_WORKING_DAY, or LAST_WORKING_DAY.

    • invoicingDay string
    • isDisbursementFeeEnabled boolean
    • isTimesheetsEnabled boolean
    • timesheetsAccountId integer(int64)
    • fixedAmount number
    • orderArticleId integer(int64)
    • orderArticleName object
      Hide orderArticleName attributes Show orderArticleName attributes object
      • en string
      • fr string
      • de string
      • it string
    • orderArticleMeasurement string

      Values are UNIT, ML, DL, L, HL, G, KG, T, H, M, M_2, M_3, KM, or DAY.

    • orderArticleUnitPrice number
    • orderArticleAmount number
    • orderArticleDiscount number
    • orderArticleTotalNet number
    • orderArticleStatus string

      Values are SHIPPED, PARTIALLY_SHIPPED, NOT_SHIPPED, or SERVICE.

    • historyStatus string

      Values are OFFERED, OFFERED_SENT, CONFIRMED, CONFIRMED_SENT, BILLABLE, FINISHED, or CANCELLED.

    • historyDate string(date-time)
    • statusLastChangedDate string(date-time)
    • addressName string
    • addressClientName string
    • addressStreet string
    • addressStreetPoBox string
    • addressZipCode string
    • addressCity string
    • addressCountryCode string
    • addressRegionCode string
    • addressToTheAttentionOf string
    • yourReference string
    • orderValidity integer(int64)
    • paymentAccountId integer(int64)
    • periodic boolean
    • inWorkflow boolean
    • expensesEnabled boolean
    • prePaymentAvailable boolean
    • partialPaymentAvailable boolean
    • invoiceGenerated boolean
  • 400

    400 Bad Request

  • 401

    401 Unauthorized

  • 403

    403 Access Denied

  • 404

    404 Not Found

  • 500

    500 Internal Server Error

GET /api-v1/orders/advanced
curl \
 --request GET 'https://wyzio.app/api-v1/orders/advanced'
Response examples (200)
[
  {
    "id": 42,
    "name": "string",
    "orderId": "string",
    "date": "2026-05-04T09:42:00Z",
    "description": "string",
    "contactName": "string",
    "contactId": 42,
    "organizationId": 42,
    "warnings": "string",
    "status": "OFFERED",
    "isExpensesEnabled": true,
    "isPrePaymentAvailable": true,
    "isPartialPaymentAvailable": true,
    "orderAmount": 42.0,
    "creatorContactId": 42,
    "hasWarnings": true,
    "validated": true,
    "clientEmail": "string",
    "clientECorrespondence": true,
    "workflowPermissions": "string",
    "isInvoiceGenerated": true,
    "isPeriodic": true,
    "isInWorkflow": true,
    "flagsAmount": 42,
    "activeSubOrderId": 42,
    "activeSubOrderInvoicingDate": "2026-05-04T09:42:00Z",
    "systemValidated": true,
    "clientOrderEmail": "string",
    "clientAdvancedInvoicingNote": "string",
    "hasProformaInvoice": true,
    "parentOrderId": 42,
    "parentOrderName": "string",
    "departmentId": 42,
    "departmentName": "string",
    "officeId": 42,
    "officeName": "string",
    "vatRateId": 42,
    "vatRateName": {
      "en": "string",
      "fr": "string",
      "de": "string",
      "it": "string"
    },
    "requestedPaymentTerms": 42,
    "currencyId": 42,
    "currency": "string",
    "minimumAmountToInvoice": 42.0,
    "ourContactName": "string",
    "yourContactName": "string",
    "periodicityStartDate": "2026-05-04T09:42:00Z",
    "periodicityType": "NONE",
    "dayOfWeek": "MONDAY",
    "invoicingTime": "FIRST_DAY",
    "invoicingDay": "string",
    "isDisbursementFeeEnabled": true,
    "isTimesheetsEnabled": true,
    "timesheetsAccountId": 42,
    "fixedAmount": 42.0,
    "orderArticleId": 42,
    "orderArticleName": {
      "en": "string",
      "fr": "string",
      "de": "string",
      "it": "string"
    },
    "orderArticleMeasurement": "UNIT",
    "orderArticleUnitPrice": 42.0,
    "orderArticleAmount": 42.0,
    "orderArticleDiscount": 42.0,
    "orderArticleTotalNet": 42.0,
    "orderArticleStatus": "SHIPPED",
    "historyStatus": "OFFERED",
    "historyDate": "2026-05-04T09:42:00Z",
    "statusLastChangedDate": "2026-05-04T09:42:00Z",
    "addressName": "string",
    "addressClientName": "string",
    "addressStreet": "string",
    "addressStreetPoBox": "string",
    "addressZipCode": "string",
    "addressCity": "string",
    "addressCountryCode": "string",
    "addressRegionCode": "string",
    "addressToTheAttentionOf": "string",
    "yourReference": "string",
    "orderValidity": 42,
    "paymentAccountId": 42,
    "periodic": true,
    "inWorkflow": true,
    "expensesEnabled": true,
    "prePaymentAvailable": true,
    "partialPaymentAvailable": true,
    "invoiceGenerated": true
  }
]