You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/02/19 09:04:35 UTC
[GitHub] [superset] supermarin1 opened a new issue #13232: Retreiving data chartd/datasets/dashboards based on
supermarin1 opened a new issue #13232:
URL: https://github.com/apache/superset/issues/13232
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.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] GGPay commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
GGPay commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802150078
As i said before - open url in a browser where 142 - is chart ID
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 yml zip file
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] GGPay edited a comment on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
GGPay edited a comment on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802150078
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
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] dpgaspar commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802280659
@supermarin1 like @GGPay take a looks at `api/v1/chart/data`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] junlincc commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-782515327
@dpgaspar ^ Daniel could you help answer? thanks!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] GGPay commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
GGPay commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-801670696
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.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-800144123
please, anybody?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-804844189
Fighting with request json. It's complex and incomprehensible -(
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802268777
And I can't get data from DB through the API?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-805128439
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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 edited a comment on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 edited a comment on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-809273474
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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-809273474
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 get the same result with API as I can see on UI.
May be there is the way we can get that query?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] GGPay edited a comment on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
GGPay edited a comment on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802150078
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 yml zip file
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 removed a comment on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 removed a comment on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-804844189
Fighting with request json. It's complex and incomprehensible -(
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] willbarrett commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-783766992
@betodealmeida would you mind weighing in?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 edited a comment on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 edited a comment on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-805128439
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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] GGPay commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
GGPay commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802259478
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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] GGPay commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
GGPay commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-805461870
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`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-805087660
Yes! That what I was looking for. Thanks @GGPay @dpgaspar
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-801873713
@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?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] supermarin1 commented on issue #13232: Retreiving data chartd/datasets/dashboards based on
Posted by GitBox <gi...@apache.org>.
supermarin1 commented on issue #13232:
URL: https://github.com/apache/superset/issues/13232#issuecomment-802241459
I've got .zip file with .yaml files which are schemas, not values.
May be smth need to be configured in additional way?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org