> ## Documentation Index > Fetch the complete documentation index at: https://www.bloxs.io/llms.txt > Use this file to discover all available pages before exploring further. # Get purchase orders filtered and paged > Get a paged list of existing purchase orders, optionally filtered to the given parameters. ## OpenAPI ````json POST /api/v1/invoices/purchaseorders/filter { "openapi": "3.0.4", "info": { "title": "Invoices V1", "description": "Welcome to BETA version of the new Invoices API - intended for client public testing before the launch of the final version. During this BETA phase, we'll be improving the API based on specific client's feedbacks.", "version": "v1" }, "security": [ {} ], "tags": [ { "name": "Budgets" }, { "name": "Compactions" }, { "name": "ConceptPurchaseInvoices" }, { "name": "JournalPosts" }, { "name": "Journals" }, { "name": "LedgerAccounts" }, { "name": "Metadata" }, { "name": "PaymentReminders" }, { "name": "PurchaseInvoices" }, { "name": "PurchaseOrders" }, { "name": "SalesInvoices" }, { "name": "SalesInvoiceServices" } ], "paths": { "/api/v1/invoices/purchaseorders/filter": { "post": { "tags": [ "PurchaseOrders" ], "summary": "Get purchase orders filtered and paged", "description": "Get a paged list of existing purchase orders, optionally filtered to the given parameters.", "operationId": "GetPurchaseOrdersFilteredPaged", "requestBody": { "content": { "application/json": { "schema": { "$ref": "#/components/schemas/PurchaseOrderSearchRequest" } } } }, "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/PurchaseOrderSearchResult" } } } } }, "x-d360-narrative-url": "

Get Purchase Orders Filtered and Paged (POST)

Retrieves a paged, optionally filtered list of existing purchase orders.

A developer calls this endpoint to search for purchase orders matching one or more criteria (for example by owner, relation, or amounts), or to retrieve the full set of purchase orders in manageable pages when no filter is needed.


Request Fields

Field

Type

Required

Description

paging.pageSize

integer, 1 to 1000, nullable

Optional

The number of purchase orders to return per page. Defaults to 100 when not given.

paging.pageNumber

integer, 1 to 9999, nullable

Optional

The page number to retrieve. Defaults to 1 when not given.

sorting.columnName

string, nullable

Optional

The name of the field to sort the results by.

sorting.order

integer (enum), nullable

Optional

The sort direction. Allowed values: 0 = Ascending, 1 = Descending.

filter.reference

string, nullable

Optional

Filters on the purchase order's internal identifier (Reference/Code).

filter.externalIdentifier

string, nullable

Optional

Filters on the purchase order's external API identifier.

filter.ownerReference

string, nullable

Optional

Filters on the owner whose financial administration the purchase order belongs to.

filter.relationReference

string, nullable

Optional

Filters on the supplier the purchase order was issued to.

filter.proposalReference

string, nullable

Optional

Filters on the reference of the supplier's quote (proposal) the purchase order is based on.

filter.proposalTotalAmountExcl.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the quote's total amount excluding VAT. If omitted, there is no lower bound.

filter.proposalTotalAmountExcl.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the quote's total amount excluding VAT. If omitted, there is no upper bound.

filter.totalAmountExcl.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the purchase order's total amount excluding VAT. If omitted, there is no lower bound.

filter.totalAmountExcl.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the purchase order's total amount excluding VAT. If omitted, there is no upper bound.

filter.invoicedAmount.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the amount already invoiced against the purchase order. If omitted, there is no lower bound.

filter.invoicedAmount.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the amount already invoiced against the purchase order. If omitted, there is no upper bound.

filter.outstandingAmount.from

number (double), nullable

Optional

Inclusive lower bound for filtering on the amount not yet invoiced. If omitted, there is no lower bound.

filter.outstandingAmount.to

number (double), nullable

Optional

Inclusive upper bound for filtering on the amount not yet invoiced. If omitted, there is no upper bound.


Response Fields

Field

Type

Required

Description

paging.pageSize

integer, 1 to 1000, nullable

Optional

The page size used to produce this result set.

paging.pageNumber

integer, 1 to 9999, nullable

Optional

The page number returned in this result set.

sorting.columnName

string, nullable

Optional

The field the results are sorted by.

sorting.order

integer (enum), nullable

Optional

The sort direction applied. Allowed values: 0 = Ascending, 1 = Descending.

purchaseOrders

array of objects, nullable

Optional

The list of purchase orders matching the filter for this page. See sub-fields below.

purchaseOrders.reference

string, nullable

Optional

The internal identifier (Reference/Code) of the purchase order.

purchaseOrders.externalIdentifier

string, nullable

Optional

The external API identifier of the purchase order, if any.

purchaseOrders.ownerReference

string, nullable

Optional

The internal identifier of the owner whose financial administration the purchase order belongs to.

purchaseOrders.relationReference

string, nullable

Optional

The internal identifier of the supplier the purchase order was issued to.

purchaseOrders.proposalReference

string, nullable

Optional

The reference of the supplier's quote (proposal) the purchase order is based on.

purchaseOrders.subject

string, nullable

Optional

The subject or description line of the purchase order.

purchaseOrders.proposalTotalAmountExcl

number (double), nullable

Optional

The total amount excluding VAT stated on the supplier's quote, in the administration's base currency (major units).

purchaseOrders.workflowState

integer (enum)

Optional

The approval workflow state of this purchase order. Allowed values: 1 = Draft, 2 = OnHold, 3 = Cancelled, 4 = ApprovalWorkflow, 7 = Final, 9 = Disapproved, 10 = OwnerApprovalWorkflow, 11 = DisapprovedByOwner.

purchaseOrders.finalizationState

integer (enum)

Optional

The invoicing progress of this purchase order, independent of workflowState. Allowed values: 0 = Open, 1 = Completed, 2 = Closed.

purchaseOrders.totalAmountExcl

number (double)

Optional

The total purchase order amount excluding VAT, in the administration's base currency (major units).

purchaseOrders.invoicedAmount

number (double), nullable

Optional

The amount already invoiced against this purchase order, in the administration's base currency (major units).

purchaseOrders.outstandingAmount

number (double), nullable

Optional

The amount of this purchase order not yet invoiced, in the administration's base currency (major units).

" } } }, "components": { "schemas": { "PurchaseOrderSearchRequest": { "type": "object", "properties": { "paging": { "$ref": "#/components/schemas/PagingInfo" }, "sorting": { "$ref": "#/components/schemas/SortingInfo" }, "filter": { "$ref": "#/components/schemas/PurchaseOrderSearchRequestFilter" } }, "additionalProperties": false }, "PurchaseOrderSearchResult": { "type": "object", "properties": { "paging": { "$ref": "#/components/schemas/PagingInfo" }, "sorting": { "$ref": "#/components/schemas/SortingInfo" }, "purchaseOrders": { "type": "array", "items": { "$ref": "#/components/schemas/PurchaseOrderSearchResultFilter" }, "nullable": true } }, "additionalProperties": false }, "PagingInfo": { "type": "object", "properties": { "pageSize": { "maximum": 1000, "minimum": 1, "type": "integer", "format": "int32", "nullable": true }, "pageNumber": { "maximum": 9999, "minimum": 1, "type": "integer", "format": "int32", "nullable": true } }, "additionalProperties": false }, "SortingInfo": { "type": "object", "properties": { "columnName": { "type": "string", "nullable": true }, "order": { "type": "integer", "description": "Ascending = 0\nDescending = 1", "format": "int32", "x-enumNames": [ "Ascending", "Descending" ] } }, "additionalProperties": false }, "PurchaseOrderSearchRequestFilter": { "type": "object", "properties": { "reference": { "type": "string", "nullable": true }, "externalIdentifier": { "type": "string", "nullable": true }, "ownerReference": { "type": "string", "nullable": true }, "relationReference": { "type": "string", "nullable": true }, "proposalReference": { "type": "string", "nullable": true }, "proposalTotalAmountExcl": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "totalAmountExcl": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "invoicedAmount": { "$ref": "#/components/schemas/CompareFilterModelDecimal" }, "outstandingAmount": { "$ref": "#/components/schemas/CompareFilterModelDecimal" } }, "additionalProperties": false }, "PurchaseOrderSearchResultFilter": { "type": "object", "properties": { "reference": { "type": "string", "nullable": true }, "externalIdentifier": { "type": "string", "nullable": true }, "ownerReference": { "type": "string", "nullable": true }, "relationReference": { "type": "string", "nullable": true }, "proposalReference": { "type": "string", "nullable": true }, "subject": { "type": "string", "nullable": true }, "proposalTotalAmountExcl": { "type": "number", "format": "double", "nullable": true }, "workflowState": { "type": "integer", "description": "Draft = 1\nOnHold = 2\nCancelled = 3\nApprovalWorkflow = 4\nFinal = 7\nDisapproved = 9\nOwnerApprovalWorkflow = 10\nDisapprovedByOwner = 11", "format": "int32", "x-enumNames": [ "Draft", "OnHold", "Cancelled", "ApprovalWorkflow", "Final", "Disapproved", "OwnerApprovalWorkflow", "DisapprovedByOwner" ] }, "finalizationState": { "type": "integer", "description": "Open = 0\nCompleted = 1\nClosed = 2", "format": "int32", "x-enumNames": [ "Open", "Completed", "Closed" ] }, "totalAmountExcl": { "type": "number", "format": "double" }, "invoicedAmount": { "type": "number", "format": "double", "nullable": true }, "outstandingAmount": { "type": "number", "format": "double", "nullable": true } }, "additionalProperties": false }, "CompareFilterModelDecimal": { "type": "object", "properties": { "from": { "type": "number", "format": "double", "nullable": true }, "to": { "type": "number", "format": "double", "nullable": true } }, "additionalProperties": false } } } } ````