31: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}

`; } }32:[] 2f:{"title":"MineQ Asset Data","cells":[{"id":3,"value":"md`# MineQ Asset Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"md `This page page provides a view of MineQ Asset Data in an environment`\n","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":230,"value":"viewof scope = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":210,"value":"md `## Environments\nThe data is available in different environments`","pinned":false,"hidden":false,"mode":"ojs"},{"id":207,"value":"viewof environment = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":722,"value":"md `## Asset Details`","pinned":false,"hidden":false,"mode":"ojs"},{"id":758,"value":"viewof startEntity = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":761,"value":"viewof numberOfEntities = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":740,"value":"assets_url =requesturl(\"/api/v1/Assets?startEntityIndex=\"+startEntity+\"&numberOfEntities=\"+numberOfEntities)","pinned":false,"hidden":false,"mode":"ojs"},{"id":738,"value":"asset_details = requestdata(assets_url)","pinned":false,"hidden":false,"mode":"ojs"},{"id":772,"value":"simplified_asset_details = simplify_asset_details(asset_details)","pinned":false,"hidden":false,"mode":"ojs"},{"id":510,"value":"viewof csv_assets = createCSV(simplified_asset_details)","pinned":false,"hidden":false,"mode":"ojs"},{"id":819,"value":"simplified_device_details = simplify_device_details(asset_details)","pinned":false,"hidden":false,"mode":"ojs"},{"id":423,"value":"viewof csv_device = createCSV(simplified_device_details)","pinned":false,"hidden":false,"mode":"ojs"},{"id":695,"value":"accesstoken = security_response.access_token","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":459,"value":"basicauth = base64.encode(clientid +\":\"+ clientsecret )","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":663,"value":"security_url = getSecurityServiceURL()","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":327,"value":"function authorizationheader(){\n return \"Bearer \"+accesstoken\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":339,"value":"function requesturl(path){\n return \"https://mineq-\"+environment+\"-assetserviceapi.azurewebsites.net\"+path\n}","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":431,"value":"base64 = require(\"base-64\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":508,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":632,"value":"import {text} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":635,"value":"function append(element, input, update) {\n element.append(input);\n input.addEventListener(\"input\", update);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":776,"value":"function simplify_asset_details(details) {\n var newdetails = [];\n for(var i=0;i