Actions133
- 员工 Actions
- 系统用户 Actions
- 物料 Actions
- 计量单位 Actions
- 物料清单 Actions
- 存货类别 Actions
- 组织机构 Actions
- 付款单 Actions
- 收款单 Actions
- 付款申请单 Actions
- 应付单 Actions
- 应收单 Actions
- 凭证 Actions
- 科目余额表 Actions
- 采购订单 Actions
- 采购申请单 Actions
- 收料通知单 Actions
- 采购入库单 Actions
- 销售订单 Actions
- 发货通知单 Actions
- 销售出库单 Actions
- 即时库存 Actions
- 库存同步 Actions
- 出库申请单 Actions
- 直接调拨单 Actions
- 其他出库单 Actions
- 其他入库单 Actions
- 委外订单 Actions
- 委外领料单 Actions
- 委外超耗单 Actions
- 计划订单 Actions
- 生产订单 Actions
- 生产领料单 Actions
- 生产补料单 Actions
- 生产退料单 Actions
- 生产汇报单 Actions
- 生产入库单 Actions
- 检验单 Actions
- 生产退料请检单 Actions
- 采购普通发票 Actions
- 采购增值税专用发票 Actions
- 进项费用普通发票 Actions
- 进项费用增值税发票 Actions
- 销售增值税专用发票 Actions
- 销售普通发票 Actions
- 金税开票单 Actions
- 成本管理 Actions
物料 → 单据查询
AI-generatedSummary
Queries material records from Kingdee Cloud Galaxy, selecting requested fields and applying optional filters and sorting. Returns records up to the configured limit or all available results; choose the recommended application authorization credential to connect.
Inputs
- 凭证类型 (required) — Select application authorization (recommended, default) or the deprecated account-password credential and configure the matching credential.
- Return All — When enabled, requests all results. Otherwise, Limit controls the maximum number returned (default 50; range 1–2000).
- 查询字段 — Select material fields to return. Defaults to material ID, code, and name.
- 自定义查询字段 — Add extra field names as a comma-separated string or expression array; these are merged with the selected fields and deduplicated.
- 过滤条件 — Optional SQL-style filter, such as
FForbidStatus = 'A'orFName like '%物料%'. - 排序字段 — Optional sort field and direction, such as
FNumber ASCorFMaterialId DESC. - Options — Timeout sets the response-header wait limit in milliseconds; 0 means no timeout. Transform Data defaults to true and controls transforming array responses to object format using field keys.
Output shape
A list of material records, with fields determined by the selected and custom query fields.
The node returns the query response as n8n items. The configured Limit applies unless Return All is enabled. Errors stop execution unless Continue On Fail is enabled.