hi there!
i’m having some trouble with the api and get/post requests and timing issues and had reached out to support - they recommended i post here to get some feedback. as i write this, i realize it’s not a c# specific issue (at least i don’t think), so i apologize in advance.
tl;dr: how long does it take for a change in a table to reflect in a GET request?
the message i sent to them:
hi luis! good morning. yes, i’m having trouble understanding timing when using the api to update a row, and to getting a row.
say i have a table, with column name datawritten that is of type checkbox.
i can post, and update that checkbox to true. i can then “get” that row, and see that it’s been updated to true.
the issue i’m facing is that i go to reset the checkbox back to “false” (manually), then when i go to read the table again, it’s still showing the old, i’m guessing, cached value of true. i feel like i’ve waited 30s, 1m, and up to maybe 2min, before, and still see the issue.
i have not quite figured out how long it takes for the api to get the updated value from the table and it’s really problematic for my particular scenario.
i’m not doing many requests either, it’ll probably be less then 50 at most in an hour, i’d say.
right now, i’m just doing testing with my application trying to figure out how to get the rest api working properly so it’s at most only a few requests while i’m debugging my app.
sorry for the longwinded question/answer. hopefully it all makes sense.
thanks in advance for any, and all help
API, Workflows, Integrations and all things built on Coda