Actions8
- Endpoint Actions
- Pipeline Actions
- Query Actions
- Script Actions
- Table Actions
Query → Create SQL Query
AI-generatedSummary
Create a new SQL query (view) in Peliqan by specifying a unique query name and the SQL query string defining the view.
Inputs
- Query Name (required) — The name to assign to the new SQL query (view). This must be a unique string identifier for the query.
- SQL Query (View) (required) — The SQL statement that defines the view. This query string is used to create the SQL view in the Peliqan system.
Output shape
a single JSON object representing the newly created query details or confirmation response from the Peliqan API
The output contains the JSON response from the Peliqan API after creating the SQL query view. Fields included and format depend on the Peliqan API response and may include identifiers and metadata about the created query.
Examples
Example 1: Create SQL Query with a name and SQL string
Provide 'Query Name' and 'SQL Query (View)' strings; node sends a POST request to Peliqan API endpoint 'api/database/tables/create-sql-query/' with name and query parameters.