Skip to content

Instantly share code, notes, and snippets.

@fuzzysteve

fuzzysteve/gist:232f7dd4ff3c8ec7ee45ff7acf61d61b

Created June 6, 2020 16:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fuzzysteve/232f7dd4ff3c8ec7ee45ff7acf61d61b to your computer and use it in GitHub Desktop.
Save fuzzysteve/232f7dd4ff3c8ec7ee45ff7acf61d61b to your computer and use it in GitHub Desktop.
Download ZIP
power query - Query blueprints
Raw
gistfile1.txt
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"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment