Skip to content

Instantly share code, notes, and snippets.

from requests import Session # pip install requests
from signalr import Connection # pip install signalr-client
def handle_received(**kwargs):
print('received', kwargs)
def print_error(error):
print('error: ', error)
@willinspire
willinspire / Google Script Cache-Busting IMPORTHTML.md
Last active June 15, 2023 16:16 — forked from ranaroussi/Google docs cache-busting importdata.md
It is not easy to refresh the IMPORTHTML functions in Google Sheets due to cashe limitations. The resulting limitations are old data instead of new data being pulled into the Sheet upon running a Script to reload the IMPORTHTML function. This Google Script is a "Cache-Busting" function which circumvents this problem.
// Set your variables below
SHEET_NAME="MC-Import-Data"
URL="https://coinmarketcap.com/currencies/views/all/"

// Create a trigger to refresh every 5 minutes
function myFunctionA() {
  ScriptApp.newTrigger("getData")
  .timeBased()
 .everyMinutes(5)