I have an issue that keeps popping up now and again when one of my automation scripts tries to import data from a SharePoint list but can not obtain at connection to SharePoint.
The import wizard drops the existing table, but can’t import any data. So the table remains empty.
I need to refresh the data in this table on a daily basis, but every now and then it fails and manual intervention is required.
Is there a way to setup the import wizard so it will check the SharePoint connection and then abort before deleting the existing table?
As this is part of an automation script, could I use a logic gate before the import begins to identify if a SharePoint connection has been successful?
Any help welcome.