Grafana API broken after update to 8.0.2

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?

  • 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!

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