Hi all,
I try to use the API to create a table from a CSV file, and afterwards I want to append rows from a second CSV file.
Creating the table with https://DOMAIN/dtable-server/api/v1/dtables/:base_uuid/import-csv/ works fine.
Trying to append a CSV using https://DOMAIN/dtable-server/api/v1/dtables/:base_uuid/append-csv/ does not work correctly (I used curl and httpie for testing):
- If I use the regular append command, I get an 400 error: “SyntaxError: Unexpected token - in JSON at position 0”.
- If I replace Content-type:‘application/json’ with enctype:‘multipart/form-data’ in the command (which actually is used in the “import-csv” request, and honestly I don’t understand why we should set JSON content-type here), the appending is done correctly, but the command takes about a minute to finish and then stops with a 504 error (gateway timeout).
Any ideas? Can anybody assure that the syntax for appending CSVs that is currently given in the API docs is correct?
I use Seatable 2.8 on an on-premise system.
Thanks a lot!
Simon