金蝶云星空Install

Summary

Queries purchase requisition records from Kingdee using the selected authentication credential. Specify the fields to return and optionally filter or sort the results; choose whether to return all matches or cap the result count.

Inputs

• 凭证类型 (required) — Select application authorization (recommended, default) or the deprecated account-and-password credential.
• Return All — Defaults to false. When false, Limit sets the maximum number of results; when true, the node requests all results.
• Limit — Maximum results when Return All is false; defaults to 50, with a declared range of 1–2000.
• 查询字段 — Comma-separated field keys to query; defaults to FID,FBillNo.
• 过滤条件 — Optional SQL-style filter expression, such as FForbidStatus = 'A'.
• 排序字段 — Optional sort fields with ASC or DESC, for example FNumber ASC.
• Options — Timeout sets the request timeout in milliseconds; 0 means no timeout. Transform Data defaults to true and controls whether array responses are transformed to object format using the field keys.

Output shape

A list of matching purchase requisition records.

The node returns the query response as n8n items. The selected fields and Transform Data option affect the record representation; the source pack does not include this operation's query implementation, so pagination and exact response formatting are not confirmed.

Examples

Example 1: Find active requisitions

Set 查询字段 to FID,FBillNo,FDate; set 过滤条件 to FForbidStatus = 'A'; optionally set 排序字段 to FID DESC.

Links

• n8n community nodes installation guide