How can I stop a failed API call from deleting the data in my sheet?
For 3 days now I've had a failed API call to FACEBOOK INSIGHTS for Facebook post data.
I'm getting this response Error: FB post fetching error: An unknown error has occurred.
The problem itself is annoying but even more so is that the failure to run deletes all the data from the last successful refresh that was in my Google Sheet. While older data may not be ideal, at least the GDS dash stays active. Now it fails to load anything as the last good refresh is gone, and clients start emailing.
Is there a way to stop this from happening, so that only a successful trigger refresh removes/updates the previous one?