Peliqan icon

Peliqan

Get data from Peliqan

Actions8

Query → Create SQL Query

AI-generated

Summary

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.

Links

Discussion