API Spreadsheets

Product details

Q: So this may come in handy for a current project I have.

We would like to have customers upload a CSV then add that data to MySQL.

Is there row limit for the upload or for the SQL Database or both?

coachmikemontePLUSMar 13, 2022
Founder Team
Leo_PartnerSupport

Leo_PartnerSupport

May 14, 2024

A: Hi @coachmikemonte! Thanks for your question.

To clarify, the total number of rows or size of your database is irrelevant. If the number of rows that your SQL query for the API is within the limits, it is all good.

Hopefully this information helps!

Share
Helpful?
Log in to join the conversation
Verified Purchaser badge

Verified purchaser

Posted: Mar 17, 2022

That makes sense. Glad to hear it.

Can your webhooks be triggered by formulas? Like if I used a formula that was IF(Today() is less than a date in another column, Return TRUE)

Would your system be able to pick up the column changing to the TRUE value to start an automation?

Founder
Verified Purchaser badge

Verified purchaser

Posted: Mar 24, 2022

Ah, not yet! I have added this to our roadmap here: https://trello.com/c/YqeU0SrP/40-monitor-data-changes

The feature is under the heading: monitor data changes and use them to trigger actions