Support 'Accept: 'text/csv'' response?

[skoschik]

Hi,

First off, thank you for the great work on this data provider for PostgREST! It's been a tremendous asset in my project. I would like to request a feature or get your thoughts on supporting the 'Accept: text/csv' header and its response in this provider. PostgREST offers the ability to export data in CSV format by including this header, which could be really useful for exporting lists directly from React Admin.

Background:
I've added the 'Accept: text/csv' header using the meta property that ra-data-postgrest provides via getList. This works great for exporting lists in CSV format directly from PostgREST, but...

Issue:
I'm encountering difficulties with the response handling. The current implementation expects JSON responses, which is incompatible when receiving CSV data from the API.

Feature Request:
Does CSV handling make sense to implement within this library, or do you have guidance on how to achieve it?

Thank you again for your efforts on this project! Looking forward to your insights.

[scheiblr]

Hey @skoschik,

thanks for opening this issue. Making the DP capable of handling the CSV export functionality of PostgREST sounds like a decent idea and I believe it could be realized, but is a question of effort which I currently do not know. What I can think of right now, should be doable:

• I would recommend to create a test-case, which potentially requires additionall mockup code.
• Next, one could check the text/csv in the meta-property could somehow also be used in the accept header: https://github.com/raphiniert-com/ra-data-postgrest/blob/master/src/index.ts#L140
• furhter customization might be required here, though: https://github.com/raphiniert-com/ra-data-postgrest/blob/master/src/index.ts#L147-L164

If you want to give it a try, go for it ;)

Anyways, just for interest and understanding: may I ask you, how you are actually using the DP as you need would like rely on that feature, as the react-admin frontend list-component has already a csv export?

Kind regards

[skoschik]

Hey thanks for the feedback @scheiblr!

Great info and I'll give it a closer look soon.

Also regarding my use case: I believe react-admin CSV exporter does the JSON to CSV serialization on the frontend. For larger datasets it was just too slow (sending and having frontend serialize)