Export json list on TinyDb

[Emiliano_Giannarelli]

I am developing an app to evaluate wines, I use TinyDb to store the list of evaluated wines.
I want to give the possibility to my app users to export the wine list in json. How can I do it?
I have tried a few times and searched the web but I can't find the right solution for me.
Thanks in advance

[Peter]

This extension could help you

How do I use the "Get All TinyDB Extension" by @Juan_Antonio?

Dear @Juan_Antonio , may I ask you about another extension here, because I didn't find corresponding topic. I'm using your extension "Get all TinyDB Extension", which converts TinyDB into JSON. In the Companion I have old TinyDB from my previos project, and extension reads it fine. But, after compilation it doesn't work. Data is writing into TinyDB, I can control it with blocks, but JSON is empty as well CSV. I tested it on Android 5 and Android 12 and have no any idea what can I do... [photo_…

[TIMAI2]

Also

ETinyDB: Extra utilities for Tiny DB

ETinyDB as ExtraTinyDB provides some additional utilities for the TinyDB component. It offers the following features: Export Tiny DB This exports the data stored of a particular namespace or all namespace into the destination file. [ExportTinyDB] [ExportAll] Sample JSON: [ { "namespace": "TinyDB1", "length": 1, "preferences": { "count": "123" } } ] Get JSON Data Similarly you can also get JSON data directly returned. [GetJSON] [GetAllJSON] Used…

[Emiliano_Giannarelli]

It gives me a permissions error

[TIMAI2]

You probably need to remove the file:// from the path generated by the file component...

[Emiliano_Giannarelli]

can you explain to me how?

[Emiliano_Giannarelli]

i remove bau not work

[TIMAI2]

You also need to include the shared directory, e.g. Download, in the path

[ABG]

Here is a Do It Yourself sharing approach, using no extensions.

sharing.aia (1.6 KB)

It leaves it up to the user to choose where they want to drop the JSON output, whether into an open email application, a text editor, or any other app that can accept copy and paste text.

[ABG]

If you want to let users see other users' opinion of wines, you could set up a Google Sheet where users could upload their reviews of wines, one row per wine per user review.

If you are staging reviews in TinyDB before upload, you could add a Sheets RowID to each review (initialy 0) to note if and where the uploaded review landed in the sheet.

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - …

[Emiliano_Giannarelli]

Thanks to all
Maybe the best solution for my APP is sharing but also the others helped me understand

[TIMAI2]

You can always save GetEntries to a file:

(the join block converts the JSON OBJECT to a JSON STRING.)