Allow client-side export of data provider data

[aptkingston]

Describe the feature request We should add the ability to locally export data - i.e. export all data that's currently inside any data provider. I propose we enhance the current "Export data" action so that you can select a table (the current functionality, depends on "row selection" being enabled), or you can select a data provider (new functionality).

Our current "Export data" implementation sends up row IDs and the server fetches and exports them, but this is therefore limited to internal or SQL tables. We should simply allow a dump of all the data that a data povider has already fetched and is sitting in the frontend.

This provides a few benefits:

• Allows exporting data from any datasource, including custom queries
• Is still compatible with internal and SQL tables, if you just want a quick dump of the page of data you can see
• Respects data provider filters, so if you've filtered a data provider down to only provide a certain subset of your data, then this is all that will be exported
• Works with the existing action
• Targets a different component type so there's no breaking change to add this

The ability to export data from custom queries was requested in Discord.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity.

[vbhv4GritFinancial]

Any updates on this?

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity.