IntellX for Sage X3 icon

IntellX for Sage X3

Read, create or modify a Sage X3 object via the XCHATX3OBJ sub-program (JSON in, JSON out)

Actions9

SQL Select

AI-generated

Summary

Execute a SQL query against the Sage X3 database through the ChatX3 sub-program and return its rows. Use named parameters for filters, optional clauses for filters that may be omitted, and SQL Options to cap rows or execution time.

Inputs

  • SQL Query (required) — The query to execute. Use {{name}} placeholders for Query Parameters and wrap optional clauses in [[ ... ]].
  • Query Parameters — Named values substituted into the query. Choose Text, Number, Boolean, Date, Contains, or List to control escaping and formatting. An empty value removes an optional clause that uses it; a placeholder outside an optional clause must have a value.
  • Action Code — The X3 action sent to the sub-program; defaults to SELECT and can be edited.
  • SQL Options — Optionally set Max Lines to cap returned rows or Max Time (Seconds) to cap execution time inside Sage X3.
  • Simplify — When enabled, return a compact result with rowCount, columns, and rows. The node derives column names from the SELECT list where it can; otherwise Sage X3's returned keys may be used.
  • Row Format — For simplified output, choose rows as arrays ordered by columns or as objects keyed by column name. Defaults to objects.
  • Advanced Options — Optional SOAP and output settings, including request timeout, code language and pool overrides, raw response/request/result inclusion, and array trimming or compaction.

Output shape

One item per input item, containing the SQL result.

With Simplify off, returns the standard X3 response fields such as success, status, action, object (SQL), data, and any messages or session information. With Simplify on and rows recognized, returns rowCount, columns, and rows, with failure details when applicable. If simplified rows cannot be recognized, returns the standard response and sets simplified to false. Enabling request, raw response, or result inclusion adds corresponding debugging fields.

Links

Discussion