fuzzysteve

import requests
import os
import json

appkey="nope"
userid="nuhu"
apikey="nahmate"


basedir="export"

fuzzysteve

import requests
from sqlalchemy import create_engine,MetaData,Table,Column,INTEGER,FLOAT,VARCHAR,UnicodeText,DECIMAL,Boolean,select,literal_column
import requests_cache
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed

from tqdm import tqdm

fuzzysteve

let
    Source = Json.Document(Web.Contents("https://www.fuzzwork.co.uk/blueprint/api/blueprint.php?typeid="&Text.From(Excel.CurrentWorkbook(){[Name="blueprintid"]}[Content]{0}[Column1]))),
    blueprintDetails = Source,
    activityMaterials = blueprintDetails[activityMaterials],
    #"1" = activityMaterials[1],
    #"Converted to Table" = Table.FromList(#"1", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"typeid", "name", "quantity", "maketype"}, {"Column1.typeid", "Column1.name", "Column1.quantity", "Column1.maketype"})
in
    #"Expanded Column1"

fuzzysteve

// ==UserScript==
// @name         New Userscript
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  try to take over the world!
// @author       You
// @match        https://zkillboard.com/*
// @grant        none
// ==/UserScript==