@Shaina_Torgerson
I have a Webhook Automation compositioning RunActions+RefreshTable to refresh my dynamic synch tables.
I’m using the API for the webhook, and I’m getting a 202 success.
However, in the UI I’m seeing “CODA ERROR” and nothing is refreshing.
Please help, this is blocking me.
I have a feeling this is because I’m not paying for the Teams membership you guys have.
You can’t use RefreshTable from within any kind of automation, including webhooks, regardless of what membership you’re on. According to the docs, the 202 response indicates only “that the automation trigger was queued for processing,” and says nothing about the actual success of that automation. You might try sending the requestId that is returned with the 202 to the /mutationStatus endpoint to get more details about how the webhook automation is being processed.
I’ve encountered this issue before. I’ve tried one workaround that doesn’t work–I created a table where each column is a button that refreshes a sync table, then tried pressing these buttons through the /pushButton API endpoint. The first response returns 202. Sending the requestId to /mutationStatus says only {completed=false} and indicates no error. But nothing happens. It’s technically not an automation, but it’s clear that Coda doesn’t want you programmatically refreshing your sync tables by any means. My next idea is to try something like Playwright, but I haven’t gotten there yet.
ok super awesome, thank you for your help and it’s nice meeting someone on the same wavelength and yeap i was thinking of doing some playwright stuff too but just wanted to synch here before i put too much into it