Retreiving data chartd/datasets/dashboards based on

[supermarin1]

Is there the way to export data charts/dashboards based on with REST API v. 1.0.0?

Tried /chart/export/, /database/export/, /dashboard/export/ and have no luck. Or I understand wrong meaning of export?

Please, advise.

[junlincc]

@dpgaspar ^ Daniel could you help answer? thanks!

[willbarrett]

@betodealmeida would you mind weighing in?

[supermarin1]

please, anybody?

[GGPay]

I've used dashboard with q parameters { "order_column": "changed_on_delta_humanized", "order_direction": "desc", "page": 0, "page_size": 25 }

Got response

And then make a request - where id in parentheses is ID of dashboard

http://127.0.0.1:8088/api/v1/dashboard/export/?q=!(3)

Wouldn't say it's proper solution but that the way how i made it work.

[supermarin1]

@GGPay thanks

I can get all info about dashboard/chart/dataset but I'm interesting in possibility to get/export data dashboard/chart/dataset based on.

I tried all API calls and did not find any way to retrieve data at least from DB. Is this possible?

[GGPay]

As i said before - open url in a browser where 142 - is chart ID

Don't forget authenticate.

http://your_superset_host/api/v1/chart/export/?q=!(142)

3 - Dashboard ID

http://your_superset_host/api/v1/dashboard/export/?q=!(3)

And get yaml zip file

[supermarin1]

I've got .zip file with .yaml files which are schemas, not values.

May be smth need to be configured in additional way?

[GGPay]

I don't really understand what are you trying to achieve? Dashboard/Charts/Queries export are export of .yamls schemas. Don't understand why you need export values - just write SQL to database.

Take a look chart/data or reverse frontend request to find what you're looking.

[supermarin1]

And I can't get data from DB through the API?

[dpgaspar]

@supermarin1 like @GGPay take a looks at api/v1/chart/data

[supermarin1]

Yes! That what I was looking for. Thanks @GGPay @dpgaspar

[supermarin1]

The next question:

I have schema and information for ordering from /api/v1/chart/export?q=[chat_ds] (please note order columns is empty)
order_by_cols: [], order_desc: true

Forming the json for api/v1/chart/data POST request "order_desc": true doesn't provide any ordering. Changing to false doesn't make any impact.

How can I get the proper ordering?

[GGPay]

I'm not really famililar with api/v1/chart/data endpoint but have look tests - it's really useful

superset/tests/charts/api_tests.py

[supermarin1]

Thera are no test case covering my case :-( And this is more about /api/v1/chart/export endpoint.

I'm able to get all info from api/v1/chart/export?q=[chart_id] to form post request to /api/v1/chart/data except ordering columns.

There is no chart settings as for sorting

but there is sorting in SQL query (chart -> view query)

As the result - I can't get the same result with API as I can see on UI.

May be there is the way we can get that query?