This code is largely derived from sources found online. As such, I didn't think it was unreasonable to compile it into a series of extracts to use in your own projects.
In here we have code to perform an off-line sync with sharepoint lists, to perform an HTTP request, to check whether tables exist, and drop them if they do, and to produce Base64 encoded SHA1 signed AES ecrypted (with multiple rounds) text.
Function names:
- ResyncWithSharepoint(URL)
- SyncTable(TableName) (Note this depends on the tables having a Sharepoint Link already established with the prefix sp)
- HttpOK(URL)
- Sleep(microseconds)
- ifTableExists(tableName, DatabaseFileName)