Actions41
- ── Framework ── Actions
- DataServer (Generic) Actions
- Employees (HR) Actions
- Payroll Actions
- Invoice (Stock) Actions
- Stock Movement Actions
- Accounts Payable/Receivable Actions
- Accounting Entry Actions
- Customers / Suppliers Actions
- Users Actions
- Companies Actions
- Enrollment (Education) Actions
Stock Movement → Get Movement
AI-generatedSummary
Retrieve stock movement records from TOTVS RM by applying optional SQL filters, selecting specific fields, and overriding company code or context if needed.
Inputs
- SQL Filter — Standard RM SQL filter string to restrict which movement records to retrieve (e.g., CODCOLIGADA=1 AND CODSITUACAO='A'). Supports =, LIKE, AND, OR, IN.
- Select Fields — Comma-separated list of specific fields to return from the stock movement records. Leave empty to return all fields.
- Company Code Override — Number to override the default company code defined in the credential. Use 0 to keep the credential's company code.
- RM Context — Additional RM context string (e.g., CODSISTEMA=S;CODUSUARIO=admin;CODFILIAL=1). Leave empty to use credential defaults.
Output shape
a list of stock movement record objects matching the given filter and selection criteria
If no filter is provided, the operation may return many records; it is recommended to specify filters or limit the scope. The operation returns JSON objects representing stock movements retrieved from the configured TOTVS RM environment.
Examples
Example 1: Retrieve active stock movements for company 1 selecting specific fields
Set SQL Filter to "CODCOLIGADA=1 AND CODSITUACAO='A'", Select Fields to desired columns such as "MOVIMENTO,QUANTIDADE", and optionally override company code or add context.