Grafana API broken after update to 8.0.2

[luciotufari]

Grafana version: 8.0.2
O.S. : Ubuntu 16.04.3

• What are you trying to achieve?
  Get data from datasource via API

• How are you trying to achieve it?
  Yes

• What happened?
  Before the last upgrade it works perfectly, now returned values is in dataframe format instead of table

• What did you expect to happen?
  I just want to work with table format API and not dataframe

• Can you copy/paste the configuration(s) that you are having problems with?
  curl -X POST “http://XXX.XXX.XXX.XXX:3000/gotha/api/tsdb/query” -v -H "Authorization: Bearer " -H “Accept: application/json, text/plain, /” --compressed -H “content-type: application/json” -H “x-grafana-org-id: 1” --data-raw ‘{“from”:“1591937499430”,“to”:“1591959099430”,“queries”:[{“refId”:“A”,“intervalMs”:60000,“maxDataPoints”:1502,“datasourceId”:1,“rawSql”:“SELECT name FROM table ORDER BY name;”,“format”:“table”}]}’

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  no error, just data in dataframe format

• Did you follow any online instructions? If so, what is the URL? I follow the API documentation

Thanks in advance, best regards!

[torkel]

Data frame is the new data format that the API returns, we do not provide a backward compatible version of the old API as this is the format that Ǵrafana internal use and the frontend use