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 Analyse

AI-generated

Summary

Validate a SQL query against the Sage X3 database through the ChatX3 sub-program, without returning query rows. Use this operation to check syntax; use SQL Select to fetch results.

Inputs

  • SQL Query (required) — SQL query to analyse. Supports named {{name}} parameters and optional [[ ... ]] clauses configured in Query Parameters.
  • Action Code — Action sent to the sub-program; defaults to ANALYSE and can be edited.
  • Query Parameters — Named values substituted into the query. Choose a type to control escaping: Boolean, Contains, Date, List, Number, or Text. Empty values remove optional clauses that reference them; an empty value used elsewhere causes an error.
  • SQL Options — Optional execution caps: Max Lines and Max Time (seconds).
  • Advanced Options — Optional SOAP call settings include code language, pool alias and pool ID overrides, sub-program name, request timeout, and flags to include the raw response, request, or parsed result. Array compaction and trailing-empty trimming affect parsed data when present.

Output shape

A single JSON item per input item, containing either analysed data or an error.

The usual output includes success, status, action, object (SQL), and identifier (empty). It may include returned data, messages, trace, sessionId, technicalInfos, and optional result, raw, or request fields. This operation does not return SQL rows as its purpose is syntax validation. With Continue On Fail enabled, errors are returned in an item containing error, code, and raw fields.

Links

Discussion