API responses for Data explorer queries are only available when an API key is generated with global scope.
Tried with different scope options existing now (read, read_lists) but it didnt work with them.
It would be great if we have limited API key scope created for this operation.
I second this feature request, was surprised it doesn’t exist yet!
We have several teams that invoke reports from an external source (e.g. spreadsheet) and they want to be able to do that without putting overly sensitive secrets in the external tooling.
A data_explorer scope was recently added. It allows you to make POST requests to the /queries/:id/run route.