2d:null 2e:["$","title",null,{"children":"MineQ Asset Data | ptomlinsongti | Observable"}] 33:T40c,function createTable(data){ if (data) { //get properties name from object const dataProperties = Object.keys(data.items[0]); //create headers for table cells let tableHeads = ""; dataProperties.forEach((item) => { tableHeads += `${item}`; }); //create rows for table from data let tableRow = ""; data.items.forEach((item) => { //create cells in rows from data let tableCell = ""; dataProperties.forEach((prop) => { tableCell += `${item[prop]}`; }); tableRow += `${tableCell}` }); //Generate html code for table return html`

${tableHeads} ${tableRow}

`; } }34:[] 31:{"id":"68d4df7c80dfcbf4","slug":"mineq-asset-data","title":"MineQ Asset Data","thumbnail":"527e4716022ebfab0ea5c63d75e2c811d56c28260cf9591c8caaae9ab6411c52","access_level":"public","create_time":"$D2018-09-04T02:50:55.917Z","update_time":"$D2018-10-23T01:43:35.493Z","view_time":null,"first_public_time":"$D2018-09-04T03:48:33.633Z","has_unpublished_edits":null,"fork":{"id":"1df517c222727bd5","slug":"mineq-field-data-service","title":"MineQ Field Data Service","owner":{"id":"7329d081429dfcaa","login":"ptomlinsongti","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"7329d081429dfcaa","login":"ptomlinsongti","name":"","avatar_url":"https://avatars-next.observableusercontent.com/86ccbc9730b9c39c477fa87b131b9fcb08ee51a770047ad804f45e2e7ae90f0f","tier":"starter_2024"},"version":825,"publish_version":825,"role":null,"authored":false,"authors":[{"type":"individual","id":"1ffab0e88c3f53a4","login":"ptomlinsongti","name":"","avatar_url":"https://avatars-next.observableusercontent.com/86ccbc9730b9c39c477fa87b131b9fcb08ee51a770047ad804f45e2e7ae90f0f","tier":null}],"members":[{"type":"individual","id":"1ffab0e88c3f53a4","login":"ptomlinsongti","name":"","avatar_url":"https://avatars-next.observableusercontent.com/86ccbc9730b9c39c477fa87b131b9fcb08ee51a770047ad804f45e2e7ae90f0f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"MineQ Asset Data","cells":[{"id":3,"value":"md`# MineQ Asset Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"md `This page page provides a view of MineQ Asset Data in an environment`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"viewof clientid = text({title: \"ClientId\", placeholder: \"mineq-portal\", description: \"The client you are authorizing as. Try mineq-portal\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"viewof clientsecret = text({title: \"ClientSecret\", placeholder: \"mineq-portals3cRetK3y\", description: \"The client secret/password you are authorizing as. Try this: mineq-portals3cRetK3y\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"viewof scope = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"md `## Environments\nThe data is available in different environments`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"viewof environment = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":722,"value":"md `## Asset Details`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":758,"value":"viewof startEntity = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"viewof numberOfEntities = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":740,"value":"assets_url =requesturl(\"/api/v1/Assets?startEntityIndex=\"+startEntity+\"&numberOfEntities=\"+numberOfEntities)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":738,"value":"asset_details = requestdata(assets_url)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":772,"value":"simplified_asset_details = simplify_asset_details(asset_details)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"viewof csv_assets = createCSV(simplified_asset_details)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":819,"value":"simplified_device_details = simplify_device_details(asset_details)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"viewof csv_device = createCSV(simplified_device_details)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":695,"value":"accesstoken = security_response.access_token","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":692,"value":"security_response= fetch(security_url+\"/connect/token\", {\n headers: new Headers({\n \"Authorization\": \"Basic \"+basicauth,\n \"Content-Type\": \"application/x-www-form-urlencoded;charset=UTF-8\"\n }),\n method: \"POST\",\n body: `grant_type=client_credentials&scope=${scope}`\n}).then(response => {\n if (!response.ok) throw new Error(response.status);\n return response.json();\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":459,"value":"basicauth = base64.encode(clientid +\":\"+ clientsecret )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"function encode(){\n console.log(clientid +\":\" + clientsecret)\n return btoa(clientid + clientsecret)\n //return \"xyz\"\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"function getSecurityServiceURL(){\n switch(environment) {\n case \"qa\":\n return \"https://mineq-qa-securityserviceapi.azurewebsites.net\"\n case \"cpm-test\":\n return \"https://mineq-cpm-securityserviceapi.azurewebsites.net\"\n default:\n return \"https://mineq-dev-securityserviceapi.azurewebsites.net\" \n }\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"security_url = getSecurityServiceURL()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"function gettoken(){\n //return \"fetch the token\" + clientid + clientsecret + scope\n fetch(security_url+\"/connect/token\", {\n headers: new Headers({\n \"Authorization\": `Basic ${base64.encode(`${clientid}:${clientsecret}`)}`,\n \"Content-Type\": \"application/x-www-form-urlencoded;charset=UTF-8\"\n }),\n method: \"POST\",\n body: `grant_type=client_credentials&scope=${scope}`\n}).then(response => {\n if (!response.ok) throw new Error(response.status);\n return response.json();\n})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"function authorizationheader(){\n return \"Bearer \"+accesstoken\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"function requesturl(path){\n return \"https://mineq-\"+environment+\"-assetserviceapi.azurewebsites.net\"+path\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":331,"value":"function requestdata(url) {\n return fetch(url, {\n headers: new Headers({\n \"Accept\": \"application/json\",\n \"Authorization\": \"Bearer \"+accesstoken\n }),\n }).then(response => {\n if (!response.ok) throw new Error(response.status);\n return response.json();\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"base64 = require(\"base-64\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":764,"value":"function createCSV(data){\n if (data) {\n //get properties name from object\n const dataProperties = Object.keys(data.items[0]);\n \n //create headers for table cells\n let tableHeads = \"\";\n dataProperties.forEach((item) => {\n tableHeads += `${item},`;\n });\n \n //create rows for table from data\n let tableRow = \"\";\n data.items.forEach((item) => {\n //create cells in rows from data\n let tableCell = \"\";\n dataProperties.forEach((prop) => {\n tableCell += `${item[prop]},`\n });\n \n tableRow += `${tableCell}\\n`\n });\n \n //Generate html code for table\n return html`

${tableHeads}\\n${tableRow}

`; \n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"import {text} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":635,"value":"function append(element, input, update) {\n element.append(input);\n input.addEventListener(\"input\", update);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":776,"value":"function simplify_asset_details(details) {\n var newdetails = [];\n for(var i=0;i