Hi, is there a way I can get the whole table data using an API?

You can export your table data by following these steps: 1. Open the table you want to export 2. Click Actions > Export > Download CSV This will give you a CSV file containing all your table data.

Source: Export and Download a File

Was that helpful?

Looks like you're still looking for help.

If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

Hey there, thanks for reaching out! Currently, we don't have external/traditional APIs to call Clay outside of the main UI. One of the reasons we don't have external APIs enabled is because we have several tools that already work under API systems and thus it would be a complex setup given the variety of actions you can implement within Clay, at least for the time being. It can still work similarly with tools we have like Webhooks to auto-import records into a workflow and then using HTTP API integrations to push it to your custom API. Another workaround here would be sending all of the data into a separate database like Google Sheets and performing the query there. Let me know if you have any other questions or concerns. :)

Sounds good! Let us know if you have any other questions or concerns. :)

Thanks, Umer! Appreciate you following up with us. Keep in touch if you have any new troubles!