I’m using API calls through Excel VBA to GET, POST, PATCH data tables linking several 3rd party platforms.
For purposes of explanation of my issue, assume the following basic data.
Table-1 contains (3) records, with Field-1 containing data “A”, “B”, “C” respectively.
I can make a List GET call and it retrieves all 3 records properly with correct values in Field-1.
I can make a record GET call for record (1) and it retrieves record (1) with correct Field-1 value of “A”
Now I PATCH record (1) with a new value in Field-1 with “X”.
In my Airtable web grid view instantly showing the updated value of “X”
If I make a list or record GET call again, it still shows record (1) with a Field value of “A” even though I’m looking at the grid view with correct data of “X”. The next day making the same call and I get the correct value of “X”, as if it sat in a cache till an evening update.
I can DELETE record 1 and I still get the same original GET results with record (1) and field-1 value of “A” even though it’s not even there. Again this condition corrects by the following day.
I never saw anything like this. Any Ideas? Thanks in advance.