Update A Query
This endpoint allows you to update a specific query within a project. The HTTP PUT request should be made to /data/projects/:projectId/queries/:queryId, where :projectId is the unique identifier of the project and :queryId is the unique identifier of the query being updated. The request should include a raw payload with the following parameters:
- displayName: (string) The display name of the query
- inputQuery: (string) The input query for the query
- queryType: (string) The type of the query
- id: (string) The unique identifier of the query
The response will include the updated details of the query, such as:
- id: The unique identifier of the query
- displayName: The updated display name of the query
- name: The updated name of the query
- queryType: The type of the query
- inputQuery: The updated input query for the query
- lastValidInputQuery: The last valid input query for the query
- columns: Details of the columns in the query result
- createdTime: The timestamp when the query was created
- modifiedTime: The timestamp when the query was last modified
- visualInput: Visual input details (if available)
- aiText: AI-generated text (if available)
Here is an example of the response:
{ "id": "545274742546891676", "displayName": "newName", "name": "newname", "queryType": "PLAIN", "inputQuery": "SELECT name from \"airtable\".\"deneme\".\"projects\"", "lastValidInputQuery": "SELECT name from \"airtable\".\"deneme\".\"projects\"", "columns": [ { "name": "name", "displayName": "name", "dataType": "varchar", "jdbcDataType": 12, "columnSize": 2147483647, "decimalDigits": 0, "numPrecRadix": null, "nullable": 2, "charOctetLength": null, "ordinalPosition": 1 } ], "createdTime": "2024-01-23T08:03:34.660949Z", "modifiedTime": "2024-01-23T08:06:48.459155Z", "visualInput": null, "aiText": null }
PUT
/
data
/
projects
/
{projectId}
/
queries
/
{queryId}
Authorizations
Authorization
string
headerrequiredBearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Path Parameters
projectId
string
requiredqueryId
string
requiredBody
application/json · object
The body is of type object
.
Response
200 - application/json
The response is of type object
.