michoelchaikin

/**
* A script to help identifying which Analytics tables a record is stored in.
*
* It works by retrieving the count for every table in the account and saving that to browser local storage
* The next time the script is run, it will compare the current count for each table, and identify any tables
* that have changed.
*
* USAGE:
*
* This script is intended to be copied and pasted into browser dev console. I recommend using the Chrome Snippets Feature

michoelchaikin

import requests
import json
import pandas as pd
import os
from oauthlib import oauth1
from requests_oauthlib import OAuth1Session

def parse_suiteql_response(response):
    response_json = json.loads(response.text)