You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "ziggekatten (via GitHub)" <gi...@apache.org> on 2024/04/23 14:40:16 UTC

[I] REST API Exports doen not work (dashboard, dataset etc) [superset]

ziggekatten opened a new issue, #28180:
URL: https://github.com/apache/superset/issues/28180

   ### Bug description
   
   Any API endpoint for exporting data returns the same error:
   
   `  "message": "Not a valid rison schema {} is not of type 'array'\n\nFailed validating 'type' in schema:\n    {'items': {'type': 'integer'}, 'type': 'array'}\n\nOn instance:\n    {}`
   
   This happens on 3.1.1, 3.1.2 and 4.0.0 using superset official docker container. 
   
   ### How to reproduce the bug
   
   1. in your browser, goto swagger/v1
   2. Authenticate with tokens
   3. Klick on any GET endpoint example: api/dataset/export
   4. klick try it out
   5. klick execute
   
   ### Screenshots/recordings
   
   ![image](https://github.com/apache/superset/assets/55629049/0d37292f-0f3a-4fc0-bf55-2a99e184717c)
   
   
   ### Superset version
   
   3.1.2
   
   ### Python version
   
   3.10
   
   ### Node version
   
   16
   
   ### Browser
   
   Chrome
   
   ### Additional context
   
   Database used is Postgres 16
   
   LDAP used for authentication (Active Directory)
   
   `FEATURE_FLAGS = {"TAGGING_SYSTEM": True, "RLS_IN_SQLLAB": True, "DRILL_TO_DETAIL": True, "ALERT_REPORTS": True, "DASHBOARD_CROSS_FILTERS": True, "DASHBOARD_RBAC": True, "THUMBNAILS" : True, "THUMBNAILS_SQLA_LISTENERS": True, "ENABLE_TEMPLATE_PROCESSING": True, "ENABLE_TEMPLATE_REMOVE_FILTERS": True, "ENABLE_SCHEDULED_EMAIL_REPORTS": True, "EMAIL_NOTIFICATIONS": True,"EMBEDDED_SUPERSET": True}`
   
   
   ### Checklist
   
   - [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
   - [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
   - [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-4035387508

   Confirmed still present in master per @msyavuz — the issue is related to how the Swagger UI sets up these export endpoints (token in query params). A fix may require updating the Swagger spec or endpoint authorization for the export endpoints. PRs welcome.


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-5028974893

   This isn't the export endpoint being broken, rather it's that `get_export_ids_schema` has no example, so Swagger UI's "Try it out" defaults `q` to `{}` instead of an array like `!(1,2,3)`. Adding an example to the schema would fix the confusion.


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #28180: REST API Exports doen not work (dashboard, dataset etc)
URL: https://github.com/apache/superset/issues/28180


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "Abdulrehman-PIAIC80387 (via GitHub)" <gi...@apache.org>.
Abdulrehman-PIAIC80387 commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-5031716323

   Thanks @rusackas — picking this up. Adding `"example": [1, 2, 3]` to all 6 `get_export_ids_schema` dicts (dashboards, charts, datasets, databases, saved_queries, themes) so Swagger UI's "Try it out" pre-fills a valid array. PR incoming.


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-2795527257

   Maybe @dosu-bot can help, but I haven't a chance to try to reproduce this, and it's been silent for quite a while. I assume this is still an issue?


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "FiiL123 (via GitHub)" <gi...@apache.org>.
FiiL123 commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-2354780247

   This is not working for us either in 4.0.2. 
   @michael-s-molina can someone please check.


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "msyavuz (via GitHub)" <gi...@apache.org>.
msyavuz commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-3085066610

   I can confirm it still exists. In web-app we put a token in the query parameters along with the dashboard id's. This is probably an issue with how swagger is setup for these endpoints


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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


Re: [I] REST API Exports doen not work (dashboard, dataset etc) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #28180:
URL: https://github.com/apache/superset/issues/28180#issuecomment-5040410578

   Thanks for picking this up @Abdulrehman-PIAIC80387, #42265 adds examples to the six `get_export_ids_schema` schemas so Swagger's Try it out pre-fills a valid array instead of `{}`. That should close this out once it lands.


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

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