Edit Table outside NextCloud (API?)

[Taxicletter]

Hello,
I'm not sure this forum is for these type of questions, so if it's not, feel free to remove or close this issue. Also, you may let me know where would be the place for this question.

I was wondering if I could use the API link to edit a table outside NextCloud.
For two things: working with a desktop application feels faster and more user-friendly, and to use functions not available in Tables. (For instance: batch editing a field: selecting rows where you want to fill in the same value for a cell, for instance. I saw a feature request, pointing to another issue, but I don't see the solution in either of the issues).
The user friendly-ness is mainly because you cannot click on a cell, you have to open the row to edit a cell. Which is cumbersome. It looses the usefulness of a selection-box, for instance.
I found the API information, but that's to complicated for me. I'm no programmer. Or can I just open the API-link with a spreadsheet application?

[datenangebot]

Hi and thanks for your issue.

You can ask questions at the forum (https://help.nextcloud.com/) to ask for community answers.
Here at Github is fine if you want to ask directly a developer. 😄
I just tagged your issue as question and not a bug or whatever...

First, a direct inline editing is on the roadmap, see here: #364
For now you can just use the web frontend. Maybe some community members are working on different endpoints like I know for an android client. These apps use the API interface...

It is not possible to open the API link and use the data as you expect because you have to setup some special security stuff to, well, secure your data. And with this interface the data is formatted in a structured way for computers.

What you can do is to export the data as csv and paste it into your favorite spreadsheet application. A reimport should also be possible, but importing means adding data, so you have to remove the old ones.

Hope that helps?

Cheers

[Taxicletter]

Thank you. I didn't know the NextCloud forum would be also for specific apps. I now see that's the case and I will look there.
Nice to know editing in an individual cell will be made possible. There is indeed a good Android client for Tables, I use it on my phone (of course).
I indeed used Numbers on Mac to edit a whole column, and then imported it again in an emptied Table. That worked perfect, that's true.

[datenangebot]

Sounds great.
Thanks for the feedback.
Will close this issue.