40:null 41:["$","title",null,{"children":"Importing and Viewing Data for VegaLite | Vega-Lite for Deneb in PowerBI | Observable"}] 47:[] 45:{"id":"5935d65b7fe74ce2","slug":"importing-and-viewing-data-for-vega-lite","title":" Importing and Viewing Data for VegaLite ","thumbnail":"5e66f7b5b2f857c02efc44458ce619ef406c687c86e78d13490491ad8b1786a1","access_level":"public","create_time":"$D2023-10-27T06:59:02.393Z","update_time":"$D2023-10-28T12:28:26.973Z","view_time":null,"first_public_time":"$D2023-10-27T06:59:02.393Z","has_unpublished_edits":null,"fork":{"id":"4c64412ef0575941","slug":"notebook-template","title":" NotebookTitle ","owner":{"id":"8535cc563d5b77a4","login":"pbiqueryous-templates","name":"PQI Queryous Templates"}},"stars":1,"starred":false,"owner":{"type":"team","id":"0ed04f365ec32e6d","login":"pbiqueryous","name":"Vega-Lite for Deneb in PowerBI","avatar_url":"https://avatars-next.observableusercontent.com/e29cba4009f63490b2e844f375dbd2fb18aa7b45714b154178fd511fe19c1305","tier":"starter_2024","bio":"","following":false},"version":717,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"095ccf69e3466ab9","login":"pbi-queryous","name":"PBI Queryous","avatar_url":"https://avatars-next.observableusercontent.com/0e362e0326315a8b72bf30cfe2bf107a47fb597d0f8798eeb7f6330b2bbb725a","tier":null,"bio":"","following":false}],"members":[{"type":"team","id":"0ed04f365ec32e6d","login":"pbiqueryous","name":"Vega-Lite for Deneb in PowerBI","avatar_url":"https://avatars-next.observableusercontent.com/e29cba4009f63490b2e844f375dbd2fb18aa7b45714b154178fd511fe19c1305","tier":"starter_2024","role":"editor"},{"type":"individual","id":"095ccf69e3466ab9","login":"pbi-queryous","name":"PBI Queryous","avatar_url":"https://avatars-next.observableusercontent.com/0e362e0326315a8b72bf30cfe2bf107a47fb597d0f8798eeb7f6330b2bbb725a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"132c6e647d8c7e1c","slug":"vega-lite-for-powerbi-deneb","title":"Vega-Lite for PowerBI (Deneb)","owner":{"id":"0ed04f365ec32e6d","login":"pbiqueryous","name":"Vega-Lite for Deneb in PowerBI"}},"type":"notebook","body":{"titling":"auto","title":" Importing and Viewing Data for VegaLite ","cells":[{"id":0,"value":"# **Importing and Viewing Data for VegaLite**
\n _How to import data to start building visuals_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"md`🧙‍♂️ [GitHub Repos](https://github.com/PBIQueryous) | 🕊️ [Twitter](https://twitter.com/PBIQueryous)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":59,"value":"contents(\"h1, h2, h3\", \"My Table of Contents\", true)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":117,"value":"## Importing Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":119,"value":"To begin, we need to have some sample data, something to work with.\nLet's look at a few methods","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":121,"value":"
\n### Manual data input","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":245,"value":"showtypes(dummyDataView)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":213,"value":"###

Import data from Vega Repo","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":247,"value":"mdhl` \nWe can also utilise Vega's data repository from Github...\n\n~~~js \n • vegaData = require(\"vega-datasets@1\", \"vega-datasets@2\") // import vega_datasets \n~~~\n\n...and then select a dataset\n\n~~~js\n • exampleDataCars = vegaData[\"cars.json\"]() // load and parse cars data\n~~~\n\n...and display the top, slicing for the top 20 rows\n\n~~~js\n • show(exampleDataCars.slice(0, 20))\n • exampleDataCars = vegaData[\"cars.json\"]() // load and parse cars data\n~~~\n${show(exampleDataCars.slice(0, 20), undefined, \"*\")}\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"mdhl`\nIn it's raw form, a 'dataset' will look something like this:\n\n~~~js\n\"data\": {\n \"values\": [\n {\"Column1\": \"A\", \"Column2\": 28}, {\"Column1\": \"B\", \"Column2\": 55}, {\"Column1\": \"C\", \"Column2\": 43}, \n {\"Column1\": \"D\", \"Column2\": 91}, {\"Column1\": \"E\", \"Column2\": 81}, {\"Column1\": \"F\", \"Column2\": 53},\n {\"Column1\": \"G\", \"Column2\": 19}, {\"Column1\": \"H\", \"Column2\": 87}, {\"Column1\": \"I\", \"Column2\": 52}\n ]\n}\n~~~\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"
\nIn **Javascript** we can turn this dataset into an object (variable)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":151,"value":"dataObject = // \"data\": {\n\n/* \"values\" */ [\n { Column1: \"A\", Column2: 28 },\n { Column1: \"B\", Column2: 55 },\n { Column1: \"C\", Column2: 43 },\n { Column1: \"D\", Column2: 91 },\n { Column1: \"E\", Column2: 81 },\n { Column1: \"F\", Column2: 53 },\n { Column1: \"G\", Column2: 19 },\n { Column1: \"H\", Column2: 87 },\n { Column1: \"I\", Column2: 52 }\n]\n// }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"mdhl`
\nWe can show the table schema\n~~~js\n • showtypes(dataObject)\n~~~\n\n> **Table Schema View:** _dataObject_\n${showtypes(dataObject)}\n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"showtypes(dataObject)","pinned":true,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"mdhl`\nAnd show the table itself\n~~~js\n • show(dataObject, null, 150)\n~~~\n> **View table**\n${show(dataObject, null, 150)}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":574,"value":"show(dataObject, null, 150)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"
\nWe can also list the column headers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"Object.keys(dataObject[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"mdhl`
\nThere are also several ways in which we can display the data table\n~~~js\n • Inputs.table(dataObject, { width: 200 })\n~~~\n> Display **dataObject**\n>\n${Inputs.table(dataObject, { width: 200 })}\n// Important to note that the data isn't encoded as a table, rather it is a list of objects\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":523,"value":"##### I'll try and alternative method using _viewof_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":440,"value":"viewof selection = Inputs.table(dataObject, { width: 200, required: false })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"selection // now I can return the columns as an array","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":456,"value":"mdhl`
\n\nWe can rename the columns as necessary\n> **Renamed Table:**\n>\n${Inputs.table(dataObject, {\n columns: [\"Column1\", \"Column2\"],\n header: {\n Column1: \"Category\",\n Column2: \"Value\"\n },\n width: 200,\n required: false\n})}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"mdhl`#### Example\nReturn the table as a **_viewof_** object\n~~~js\n import {textcolor} from \"@observablehq/text-color-annotations-in-markdown\"\n viewof viewDataObject = Inputs.table(dataObject, { width: 200 })\n~~~\n${Inputs.table(dataObject, { width: 200 })}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"viewof dataObjectAndColumns = Inputs.table(dataObject, { width: 200 })","pinned":true,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"#### Example:\nReturn the table as an array object, including the data and list of columns","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":185,"value":"newDataTable = dataObjectAndColumns","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"viewof dummyDataView = Inputs.table(dummyData, { width: 500 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"
\nDisplay the table as a proper Table and derive new columns!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":549,"value":"DummyDataTable = dummyDataView","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"DummyDataTable","database":"$undefined"},{"id":635,"value":"
\nDisplay the data as a SQL table and use SQL to add columns!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":619,"value":"SELECT Product, Company, Sales, CASE WHEN Sales > 1500 THEN 'Expensive' ELSE 'Cheap' END AS \"NewCol\"\n FROM \"dummyDataView\"\nWHERE \"Sales\" >= ${1500}\nORDER BY \"Company\" ASC\nLIMIT 5 OFFSET 0","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"var:dummyDataView"},{"id":128,"value":"// Here I am definine my data as a JSON array\ndummyData = [\n { Product: \"Tasmanian Tiger Laptop\", Company: \"Falcon Systems\", Sales: 1500 }, // row 1\n { Product: \"Quagga Pro Laptop\", Company: \"Hawk Electronics\", Sales: 2200 }, // row 2\n { Product: \"DodoBook Laptop\", Company: \"Eagle Computing\", Sales: 1800 }, // row 3 etc...\n {\n Product: \"Thylacine Elite Laptop\",\n Company: \"Owl Innovations\",\n Sales: 2700\n },\n { Product: \"Saber-Toothed Tiger PC\", Company: \"Falcon Systems\", Sales: 1300 },\n { Product: \"Megalodon Max PC\", Company: \"Eagle Computing\", Sales: 2100 },\n { Product: \"Dire Wolf Laptop\", Company: \"Hawk Electronics\", Sales: 2400 },\n {\n Product: \"Giant Sloth Pro Laptop\",\n Company: \"Owl Innovations\",\n Sales: 1900\n },\n { Product: \"QuokkaBook Pro Laptop\", Company: \"Owl Innovations\", Sales: 2800 },\n { Product: \"Aurochs Plus PC\", Company: \"Falcon Systems\", Sales: 1400 }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"Object.keys(dummyDataView[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"show(exampleDataCars.slice(0, 20), undefined, \"*\")","pinned":true,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"mdhl`\nHere we can:\n\\* display the table\n\\* filter top 20 rows\n\\* select columns\n\\* define the width of the table view\n\n~~~js\n • show(exampleDataCars.slice(0, 20), [\"Name\", \"Horsepower\"], 200)\n • show(exampleDataCars.slice(start as int, end as int), [\"Column1\", \"Column2\"], width as integer)\n~~~\n\n> **block quote** this and try this \n${show(exampleDataCars.slice(0, 20), [\"Name\", \"Horsepower\"], 200)}\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"show(exampleDataCars.slice(0, 20), [\"Name\", \"Horsepower\"], 200)","pinned":true,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":579,"value":"## > Next steps: building a visual","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":583,"value":"VegaLite({\n $schema: \"https://vega.github.io/schema/vega-lite/v5.json\",\n description: \"A simple bar chart with rounded corners at the end of the bar.\",\n data: {\n values: [\n { a: \"A\", b: 28 },\n { a: \"B\", b: 55 },\n { a: \"C\", b: 43 },\n { a: \"D\", b: 91 },\n { a: \"E\", b: 81 },\n { a: \"F\", b: 53 },\n { a: \"G\", b: 19 },\n { a: \"H\", b: 87 },\n { a: \"I\", b: 52 }\n ]\n },\n mark: { type: \"bar\", cornerRadiusEnd: 4 },\n encoding: {\n x: { field: \"a\", type: \"ordinal\", title: \"Category\" },\n y: { field: \"b\", type: \"quantitative\", title: \"Amount\" }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"

\n# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":54,"value":"#### _external libraries_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":691,"value":"vegaData = require(\"vega-datasets@1\", \"vega-datasets@2\") // import vega_datasets","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":690,"value":"Object.keys(vegaData) // view object names as list","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":689,"value":"exampleDataCars = vegaData[\"cars.json\"]() // load and parse cars data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"vegaData[\"cars.json\"].url","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":687,"value":"#### external libraries","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":47,"value":"#### _my libraries_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":56,"value":"import { showMe } from \"@pbiqueryous-repo/show-me\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"import {\n try_it as addNote,\n note as note,\n details as details\n} from \"@pbiqueryous-repo/callout-boxes\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"import { style, selectingCells } from \"@pbiqueryous-repo/keyboard-shortcuts\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"import { vegaDataViewer } from \"@pbiqueryous-repo/vega-data-viewer\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"import {\n toc as contents, // src = import { toc as contents } from \"@jonfroehlich/collapsible-toc\"\n indenttoc as indenttoc,\n fmt as fmt,\n hl as mdhl,\n printVegaJSON as printVega,\n vegalite as VegaLite,\n vegaEmbed as Vega,\n printTableTypes as showtypes, // src = import { printTableTypes } from \"@jonfroehlich/data-utilities\"\n printTable as show, // src = import { printTable as showtable } from \"@jonfroehlich/data-utilities\"\n note as note\n} from \"@pbiqueryous-repo/tools\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 46:"$45:body"