Webhook Automation for RunActions+RefreshTable response is OK, but ERROR in coda

@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.

1 Like

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

In the ‘Activity’ tab of the Rule the Coda error is shown when triggered from a webhook with a good header (200 returned from Coda showing success of the call, not of the Action).

I’d vote to see the test fail in this case as well as the Webhook return a 500 server error if it can’t refresh the table maybe. the event triggered by the push button ‘test’ succeeds and refreshes the table while the event triggered by the webhook fails.

thanks for your post which clarified this.

See below the test succeeds.