Get total values for list of payables

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/payable/advanced/total

Returns aggregated payables totals based on the specified advanced filters.

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

  • payableByAccountId
  • description string
  • module

    Supported type

    Values are PURCHASE_INVOICES, SALES_INVOICES, or PAYROLL.

  • paymentId
  • invoiceId
  • invoiceDate

    Invoice date filter.

    Supported operators:

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

    Examples:

    • 2026-01-01T00:00:00.000Z..2026-12-31T23:59:59.999Z
    • >=2026-06-01T00:00:00.000Z
    • <=2026-06-01T00:00:00.000Z
  • requestedDate

    Requested date filter.

    Supported operators:

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

    Examples:

    • 2026-01-01T00:00:00.000Z..2026-12-31T23:59:59.999Z
    • >=2026-06-01T00:00:00.000Z
    • <=2026-06-01T00:00:00.000Z
  • plannedDate

    Planned date filter.

    Supported operators:

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

    Examples:

    • 2026-01-01T00:00:00.000Z..2026-12-31T23:59:59.999Z
    • >=2026-06-01T00:00:00.000Z
    • <=2026-06-01T00:00:00.000Z
  • sentDate

    Sent date filter.

    Supported operators:

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

    Examples:

    • 2026-01-01T00:00:00.000Z..2026-12-31T23:59:59.999Z
    • >=2026-06-01T00:00:00.000Z
    • <=2026-06-01T00:00:00.000Z
  • invoiceReference string
  • payableAmount
  • contactId
  • currencyId
  • hasWarnings boolean
  • departmentIds string

    Department IDs filter.

    Supported values:

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

    Examples:

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

    Office IDs filter.

    Supported values:

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

    Examples:

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

    Attribution account IDs filter.

    Supported values:

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

    Examples:

    • -1
    • 10
    • 10;15;20

Responses

  • 200 application/json

    OK

    Hide response attributes Show response attributes object
    • organizationId integer(int64)
    • module string

      Values are ALL, NONE, CONTACTS, CONTACTS_DETAILS, CONTACTS_SUPPLIER, CONTACTS_CLIENT, CONTACTS_BALANCE, CONTACTS_STAFF, CONTACTS_STAFF_DOCUMENTS, CONTACTS_USER, CONTACTS_MAIN_USER, CONTACTS_USER_SECURITY, CONTACTS_USER_PERMISSIONS, CONTACTS_SYSTEM, CONTACTS_DOCUMENTS, CONTACTS_ROLES, CONTACTS_ROLES_SUPPLIER, CONTACTS_ROLES_CLIENT, CONTACTS_ROLES_STAFF, CONTACTS_ROLES_USER, CONTACTS_COMMUNICATIONS, ORGANIZATIONS_USERS_MANAGER, ORGANIZATIONS, ORGANIZATIONS_DETAILS, ORGANIZATIONS_TEMPLATES, ORGANIZATIONS_ACCOUNTING, ORGANIZATIONS_INVOICES, ORGANIZATIONS_SYSTEM, ORGANIZATIONS_SYSTEM_ALLOCATION_KEYS, ORGANIZATIONS_SYSTEM_CODES, ORGANIZATIONS_SYSTEM_EBICS, ORGANIZATIONS_SYSTEM_INVENTORY, ORGANIZATIONS_DOCUMENTS, ORGANIZATIONS_DETAILS_INVOICING, PERMISSION_ROLES, PERMISSION_ROLES_DETAILS, BUSINESS_UNITS, ARTICLE_CATEGORIES, CHART_OF_ACCOUNTS, CHART_OF_ACCOUNTS_DETAILS, ACTIVITY_LOG, CURRENCIES, CURRENCIES_DETAILS, JOURNAL, JOURNAL_DETAILS, JOURNAL_DOCUMENTS, DOCUMENTS, DOCUMENTS_DETAILS, RECONCILIATION, PURCHASE_INVOICES, PURCHASE_INVOICES_DETAILS, PURCHASE_INVOICES_VALIDATION, PURCHASE_INVOICES_ACCOUNTING, PURCHASE_INVOICES_SHIPMENTS, PURCHASE_INVOICES_DOCUMENTS, PURCHASE_INVOICES_ALLOCATION_RULES, PURCHASE_INVOICES_WORKFLOW, SALES_INVOICES, SALES_INVOICES_DETAILS, SALES_INVOICES_VALIDATION, SALES_INVOICES_ACCOUNTING, SALES_INVOICES_DOCUMENTS, SALES_INVOICES_SHIPMENTS, SALES_INVOICES_REPORT, SALES_INVOICES_ALLOCATION_RULES, SALES_INVOICES_WORKFLOW, SALARIES, STOCK_REPORT, STOCK_MOVEMENTS, STOCK_MOVEMENTS_DETAILS, ORDERS, ORDERS_DETAILS, ORDERS_VALIDATION, ORDERS_SHIPMENT, ORDERS_INVOICES, ORDERS_EXPENSES, ORDERS_DOCUMENTS, ORDERS_WORKFLOW, ADVANCED_INVOICING, ADVANCED_INVOICING_GENERATE, ACCOUNTING_PERIODS, ACCOUNTING_PERIODS_DETAILS, ACCOUNTING_PERIODS_LOCK, ACCOUNTING_PERIODS_OPEN_CLOSE, GENERAL_LEDGER, GENERAL_LEDGER_STAFF, REPORT_TEMPLATE, ARTICLES, ARTICLES_DETAILS, PURCHASE_INVOICES_SCAN, PURCHASE_INVOICES_SCAN_DETAILS, RECOGNIZER, BALANCE, BALANCE_SHEET, BALANCE_SHEET_STAFF, PL_REPORT, PL_REPORT_STAFF, CASH_FLOW_REPORT, MY_TIMESHEETS, MY_ACCOUNT, TIME_DETAILS, TIME_DETAILS_DETAILS, TIME_DETAILS_WORKFLOW, TEAM_REVIEW, BUDGETING, BUDGETING_DETAILS, SALARY_CONFIG, SALARY_CONFIG_DETAILS, RECEIVABLES, PAYABLES, PAYABLES_PAYMENT_FILE, PDF_TEMPLATES, PDF_TEMPLATES_DETAILS, DASHBOARD, LATE_NOTICES, MY_DOCUMENTS, MY_DOCUMENTS_PAYROLL, MY_DOCUMENTS_OTHER, MY_DOCUMENTS_EXPORT_FILES, PAYROLL, PAYROLL_DETAILS, PAYROLL_ACCOUNTING, PAYROLL_SWISSDEC, VAT_REPORT, ORDER_REPORTS, ORDER_REPORTS_DETAILS, RATIOS_REPORT, VACATIONS, TRASH_CAN, USER_GROUPS, USER_GROUPS_DETAILS, WORKFLOW, WORKFLOW_DETAILS, MY_WORKFLOW_NOTIFICATIONS, FIXED_ASSETS, UNASSIGNED, EXPENSES, EXPENSES_DETAILS, EXPENSES_DRAFT, EXPENSES_DRAFT_DETAILS, CONTACT_BALANCE_REPORT, ORGANIZATION_CURRENCIES, ORGANIZATION_CURRENCIES_DETAILS, FINANCIAL_STATEMENTS, ALLOCATIONS, or ALLOCATIONS_DETAILS.

    • paymentId integer(int64)
    • invoiceId integer(int64)
    • invoiceDate string(date-time)
    • accountId integer(int64)
    • requestedDate string(date-time)
    • plannedDate string(date-time)
    • minOfRequestedAndPlannedDate string(date-time)
    • sentDate string(date-time)
    • invoiceReference string
    • payableAmount number
    • comment string
    • warnings string
    • contact string
    • contactId integer(int64)
    • currency string
    • currencyId integer(int64)
    • documentFileId integer(int64)
    • fileExtension string
    • hasWarnings boolean
    • entityCreatorContactId integer(int64)
    • paymentFileReference string
    • workflowPermissions string
    • tenantId integer(int64)
  • 400

    400 Bad Request

  • 401

    401 Unauthorized

  • 403

    403 Access Denied

  • 404

    404 Not Found

  • 500

    500 Internal Server Error

GET /api-v1/payable/advanced/total
curl \
 --request GET 'https://wyzio.app/api-v1/payable/advanced/total'
Response examples (200)
{
  "organizationId": 42,
  "module": "ALL",
  "paymentId": 42,
  "invoiceId": 42,
  "invoiceDate": "2026-05-04T09:42:00Z",
  "accountId": 42,
  "requestedDate": "2026-05-04T09:42:00Z",
  "plannedDate": "2026-05-04T09:42:00Z",
  "minOfRequestedAndPlannedDate": "2026-05-04T09:42:00Z",
  "sentDate": "2026-05-04T09:42:00Z",
  "invoiceReference": "string",
  "payableAmount": 42.0,
  "comment": "string",
  "warnings": "string",
  "contact": "string",
  "contactId": 42,
  "currency": "string",
  "currencyId": 42,
  "documentFileId": 42,
  "fileExtension": "string",
  "hasWarnings": true,
  "entityCreatorContactId": 42,
  "paymentFileReference": "string",
  "workflowPermissions": "string",
  "tenantId": 42
}