Stupid Question: How do I "get data" with the Coda API?

Sorry if this is a stupid question, I am an absolute beginner with programming - but here we go:

Is it possible to use the Coda API to return a table as an array? I’ve been reading the documentation for a few hours, and so far I’m only able to list rows and see their names/index/url. How do I get data from the actual columns? Is it possible?

Helping with budget/forecasting at a non-profit, and we’re syncing data back and forth between Coda and GSheets daily and it’s 100% manual right now.

Would really appreciate any guidance on this!

Hello, Wesley, and welcome to the community!

If you want to use API, you should probably look at listRows method. There is an example in Python. This method returns JSON, and all rows data is in items field. What language do you use? What type of array do you want to get?

But also maybe Integromat integration will fit your needs without programming at all.

(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)

Denis - thanks for the reply!

listRows did the trick. It was my first time working with JSON, so I thought I was pulling the wrong thing… Google was able to carry me through.

Thanks again for taking the time to help, I really appreciate it!