AMIS MISA icon

AMIS MISA

Tích hợp AMIS MISA cho n8n

Actions11

Stock → Get Many

AI-generated

Summary

Fetches AMIS MISA stock records across pages and returns each record as an n8n item with the configured stock fields. Optionally filters by user ID or AMIS filter JSON and sorts the results.

Inputs

  • Return All — Defaults to true and fetches records across pages. When false, Limit sets the maximum number of records.
  • Limit — Maximum records to fetch when Return All is false; defaults to 100.
  • Page Size — Records requested per page; defaults to 100.
  • Max Records — Safety cap on records fetched; defaults to 10,000. Return All fails if the cap is reached while a full page remains.
  • Max Output Items — Maximum output items; defaults to 50,000. Execution fails if the fetched record count exceeds it.
  • Request Timeout (Seconds) — Per-request timeout; defaults to 120 seconds.
  • User ID Contains — Filters stocks whose ListUserID contains this value. If Filter JSON is supplied, that filter takes precedence; otherwise, a blank value fetches without this filter.
  • Sort By — Sort field. For this operation, supported selectors are Stock Code, Stock Name, and Accounting Stock Code; unsupported selections fall back to Stock Code.
  • Sort Direction — Ascending or descending sort direction; defaults to ascending.
  • Advanced Options: Custom Filter JSON — Raw AMIS custom filter JSON. If supplied, it is sent in preference to the User ID Contains filter.
  • Advanced Options: Filter JSON — Raw AMIS Filter JSON. If supplied, it takes precedence over User ID Contains.
  • Advanced Options: Custom Sort JSON — Raw AMIS sort JSON. If supplied, it takes precedence over Sort By and Sort Direction.

Output shape

A list of n8n items, one per stock record.

Each item contains the stock columns StockCode, StockName, Address, ListOrganizationUnitCode, AccountingStockCode, Inactive, ListUserName, and StockID. Missing values are returned as empty strings. The operation reads AMIS data and does not modify stocks.

Examples

Example 1: Fetch every accessible stock record in ascending stock-code order, including its name, address, organization-unit codes, accounting stock code, inactive status, user names, and ID.

Leave Return All enabled. Optionally set Page Size, Max Records, or Request Timeout (Seconds).

Example 2: Fetch stocks whose associated user list contains a specific user ID.

Set User ID Contains to the desired user ID, leave Filter JSON and Custom Filter JSON blank, and choose the desired paging and sort settings.

Example 3: Apply an AMIS-specific stock filter or sort.

Set Filter JSON or Custom Filter JSON and/or Custom Sort JSON in Advanced Options. These raw JSON fields take precedence over the corresponding friendly stock filters or sort controls.

Links

Discussion