金蝶云星空Install

Summary

Retrieves a list of Kingdee sale orders from the cloud system, supporting filtering, sorting, and field selection.

Inputs

• authentication (required) — The type of credential to use. '应用授权（推荐）' (kingdeeAppAuthApi) is recommended and supported; '账户密码（已废弃）' (kingdeePasswordApi) is deprecated.
• returnAll — If true, fetches all matching records. If false, relies on the 'Limit' parameter to cap results.
• limit — Maximum number of results to return. Only used when 'Return All' is false. Defaults to 50, valid range 1-2000.
• fieldKeys — Comma-separated list of fields to retrieve. Defaults to 'FID,FBillNo'. Example: 'FID,FBillNo,FDate,FBillTypeID'.
• filterString — SQL-like filter condition to narrow results. Example: 'FForbidStatus = 'A'' or 'FName like ''%张%'''.
• orderString — Sort order for results. Format: 'fieldName ASC/DESC'. Supports multi-field sorting. Example: 'FNumber ASC, FID DESC'.
• options — Advanced options object containing 'timeout' (ms, 0 for no limit) and 'transformData' (boolean, default true).

Output shape

A list of items, each containing an object with the fields specified in 'fieldKeys'.

If 'Return All' is false, only records up to the 'Limit' are returned. The 'Transform Data' option in 'options' converts the raw API array response into a structured object format.

Examples

Example 1: Fetch up to 100 recent active sales orders.

Authentication: 应用授权（推荐）; Return All: false; Limit: 100; Filter: FForbidStatus = 'A'; Order: FDate DESC

Example 2: Retrieve all sales orders containing 'Project A' in the name, returning only the Bill Number and Creation Date.

Authentication: 应用授权（推荐）; Return All: true; Field Keys: FBillNo,FDate; Filter: FName like '%Project A%'; Order: FDate ASC

Links

• n8n community nodes installation guide