GitHub user khashashin closed the discussion with a comment: Is it possible to 
remove the field "query" in the result json ?

@dosu is there any active PRs or discussions about this issue? Currently on 
version 5.0.0 the endpoint /api/v1/dashboard/3/datasets exposes the raw query 
under `sql` attribute of `result` response array:

```json
{
  result: [{
    "sql": "SELECT \r\n  year,\r\n  value as 
co2_emission_total_per_person\r\nFROM \"https://example.com/datasource.json\"";,
  }]
}
```

There is also other unnecessary information such:

```json
{
  result: [{
    "select_star": "SELECT\n  *\nFROM main.\"EM City 
co2_emission_total_per_person\"\nLIMIT 100\nOFFSET 0",
    "perm": "[EM City].[EM City co2_emission_total_per_person](id:4)",
    "schema": "main",
    "table_name": "EM City co2_emission_total_per_person",
    "datasource_name": "EM City co2_emission_total_per_person",
  }]
}
```

GitHub link: 
https://github.com/apache/superset/discussions/32765#discussioncomment-14688179

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: 
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to