Automating .csv uploads

5 views
Skip to first unread message

Q&A Bot

unread,
Mar 17, 2021, 8:31:07 AMMar 17
to seektab...@googlegroups.com

Q:
I've been enjoying using your service tremendously. I'm looking for a way to automate csv uploads without using a service such as Zapier or Flow. 
Is there an endpoint available I can push csv files to, i.e. together with a cube id, to refresh the data in that cube?

You can use SeekTable web API for this purpose: 
  • Method: POST
  • URL: https://www.seektable.com/api/cube/import/csv?cubeId=<your_cube_id_to_refresh>&filename=<optional_csv_file_name>
  • Headers:
    • Authorization: <your_API_key>
  • Body: CSV data  -- OR -- 'multipart/form-data' (this API is compatible with HTML <form>-based uploads)
For example:

> curl -k -F "file=@sales.csv" -H "Authorization: YOUR_SEEKTABLE_ACCOUNT_API_KEYhttps://www.seektable.com/api/cube/import/csv?cubeId=CUBE_ID_TO_REFRESH

where
  • sales.csv  -- path to the local CSV file
  • YOUR_SEEKTABLE_ACCOUNT_API_KEY    -- value from "Manage Account" -> "Get API Key"
  • CUBE_ID_TO_REFRESH    -- cube guid (you can get it from the URL inside SeekTable app)

Reply all
Reply to author
Forward
0 new messages