Orders

List orders

Lists orders with the public contract's filters: status, contact, project, order number, date overlap and creation or update ranges.

Action

orders.findMany

At a glance

Property	Value
Domain	`orders`
Group in the editor	Orders › Orders
Runs as	The owner of the workflow, with their permissions
Permission	View access to at least one of: Sales, Orders, Deliveries. Administrators always pass; a module outside the plan blocks everyone.
Destructive	No: the public MCP catalogue does not mark it as destructive
Also available in	REST API, MCP (`filmo_orders_list`)

Inputs

limitnumberdefault:100

Limits: min 1, max 500

createdOnstring

Limits: advanced

createdAfterstring

Limits: advanced

createdBeforestring

Limits: advanced

createdFromstring

Limits: advanced

createdTostring

Limits: advanced

updatedOnstring

Limits: advanced

updatedAfterstring

Limits: advanced

updatedBeforestring

Limits: advanced

updatedFromstring

Limits: advanced

updatedTostring

Limits: advanced

statusenum<string>

Available options: draft, reserved, prepared, in_use, returned, completed, cancelled

statusesstring[]

Filter by status, as a list: repeat the parameter or separate the values with commas. Accepts up to 50 values and returns whatever matches any of them.

Available options: draft, reserved, prepared, in_use, returned, completed, cancelled

contactIdstring

contactIdsstring[]

Filter by contactId, as a list: repeat the parameter or separate the values with commas. Accepts up to 50 values and returns whatever matches any of them.

projectIdstring

projectIdsstring[]

Filter by projectId, as a list: repeat the parameter or separate the values with commas. Accepts up to 50 values and returns whatever matches any of them.

overlapsFromstring

Limits: advanced

overlapsTostring

Limits: advanced

orderNumberstring

orderNumberIsstring

Limits: advanced

orderNumberContainsstring

Limits: advanced

startsOnstring

startsAfterstring

startsBeforestring

startsFromstring

startsTostring

endsOnstring

endsAfterstring

endsBeforestring

endsFromstring

endsTostring

Outputs

itemsobject[]

Show child attributes

items.idstring

items.orderNumberstring

items.externalReferencestring | null

items.statusenum<string>

Available options: draft, reserved, prepared_partially, prepared, picked_up_partially, picked_up, returned_partially, returned, checked_in_partially, checked_in, archived, cancelled

items.startDatestring

items.endDatestring

items.rentalDaysnumber | null

items.projectIdstring | null

items.projectNamestring | null

items.contactjson | null

items.itemsCountnumber

items.subTotalPricestring

items.discountTotalstring | null

items.insuranceTotalstring

items.depositTotalstring

items.taxesPricestring

items.netPricestring

items.grossPricestring

items.tagsstring[]

items.customFieldsobject[] | null

Show child attributes

items.customFields.idstring

items.customFields.namestring

items.customFields.valuejson | null

items.sourcestring | null

items.createdAtstring

items.updatedAtstring

items.tagRefsobject[]

Show child attributes

items.tagRefs.idstring

items.tagRefs.namestring

totalnumber

nextCursorstring | null

Was this page helpful?