How to obtain a Basecamp API token for connecting Card Table in Zapier

Question

I am wanting to create a weekly report (via Zapier)We are migrating from "To-do" lists to "Card Table" and need a weekly report demonstrating “all the activity for that week, and upcoming week - project specific.The next steps for Zapier is to attain the "Basecamp Personal Access Token". I’ve spoken to Basecamp and they said this would need to be requested via Zapier. *current triggers are everything but card tables.

Sparsh from Automation Jinn · Answer

Hey ​@HEA787,Card Tables are not supported natively right now through Zapier as of right now. You can see all the triggers/ actions for basecamp here-https://zapier.com/apps/basecamp/integrationsBut there is a workaround is throughBaecamp 4 API (bc3-api) and poll for changes. See more about Basecamp API documentation here-https://github.com/basecamp/bc3-apiYou will will probably have to call multiple endpointsCallGET /buckets/{project_id}/card_tables/{card_table_id}/columns.json→ get all column IDs for that card table.For each column,GET /buckets/{project_id}/card_tables/{card_table_id}/columns/{column_id}/cards.json→ pull the cards.After that you can store it in Google Sheets/ Zapier tables and send a weekly report from there. I know it can get a bit more complex and technical but if it’s important for you, you can give this approach a try. Hope it helps!PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded