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”, ...
Support was helpful.
Turns out that excel caches html data and that was the issue (only on airtable??). Here was the support fix found
The response from your URL is being cached somewhere in MSXML2.XMLHTTP60
Put a random parameter like a timestamp t...
Thanks, will do. I perform the same operations with API calls to our CMMS software and it works great both ways.
As a back story, I had the opposite issue with the CMMS calls. I could not patch a particular field in the table. No errors, confirmed...
