Doc too big for API / Zapier, any workarounds?

Hey all!

I was trying to connect my doc with Zapier and apparently it’s too big! :frowning:

Has anyone found any workarounds that can help solve this? I.e. is there a way to sync another doc with Zapier and then transfer the data from that doc into my main one?

Thanks!
Ben

image

1 Like

Interesting… Just adding the hyperlink for those curious: https://help.coda.io/en/articles/3370370

Interesting wasn’t quite the word that came to mind when it happened haha :sweat_smile:

Hopefully someone will be able to help us with a workaround here!

1 Like

Hey, @Ben_Swanson,
I believe this post bellow might help you. It helped me.

This doc is too big to sync

Thanks @Breno_Nunes!

I also chatted to support, adding what they said here in case it helps someone else:

  • There are now workarounds, the only solution is to reduce the size of your doc (because large docs trying to use the API effects overall systemwide API performance)
  • They can’t provide you with a way to find out the size of your doc
  • For the purpose of syncing, the size of the doc won’t change/be refreshed until it’s been backed up by their automatic backup system

TLDR: For now it seems the best you can do is delete a bunch of stuff in your doc and then wait for an undetermined period of time and try again.

They said they are working on increasing the size limit though!

Hey @Ben_Swanson,

I’m no Coda support, but I know a thing or two about oversize docs since I deal with them in my coda-expert-for-hire practice way too more often than I’d like to. I outlined a lot in the post linked above. There you can see how to figure out the doc size. For more detailed breakdown (i.e. by table) I composed myself a script to inspect that:

Quick actionable steps to reduce doc size:

Also here’s a large thread on big doc perf: Realistic number of rows in a table

Keep in mind that deleting bunch of stuff will only have effect after 12 hours (IIRC), that’s the time when you can still restore deleted rows and they are still stored in the doc.

5 Likes

Wow, this is great, thanks @Paul_Danyliuk, very actionable insights, I really appreciate them, thank you!!

Hey, @Ben_Swanson, if you would like to know the (uncompressed) size of your Doc, you have to access the DevTools on Chrome.
For that, while opening your Doc, you have to press Command+Option+i or Ctrl+Shift+i
There’s a tab called Network. Go there and press Command+r or Ctrl+r
On the bottom left of the DevTool, you will see the amount of resources that was loaded for that Doc.

4 Likes

A workaround could be the cross-doc feature.

No @Premshay_Hermon :pensive:
Cross-doc is based on coda api :pensive:

@Breno_Nunes Thanks for this!!!

1 Like

One strategy I have been able to implement is using CrossDoc; I crossdoc my zapier-linked table into a new doc, Zapbook. I copy my original zap and reconnect it from original doc to Zapbook and then map the zap to this sync table. Set sync to hourly.

I have this working on docs that are not able to connect to zapier.