2d:null 2e:["$","title",null,{"children":"MineQ Field Data Service | 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":"1df517c222727bd5","slug":"mineq-field-data-service","title":"MineQ Field Data Service","thumbnail":"02234c2c0333df784727c65e5ff7148b16b1694803425237a675c338bca31c38","access_level":"public","create_time":"$D2018-05-18T03:34:19.719Z","update_time":"$D2018-09-20T02:36:15.065Z","view_time":null,"first_public_time":"$D2018-05-18T05:09:30.567Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"7329d081429dfcaa","login":"ptomlinsongti","name":"","avatar_url":"https://avatars-next.observableusercontent.com/86ccbc9730b9c39c477fa87b131b9fcb08ee51a770047ad804f45e2e7ae90f0f","tier":"starter_2024"},"version":657,"publish_version":657,"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":3,"collection":null,"type":"notebook","body":{"title":"MineQ Field Data Service","cells":[{"id":3,"value":"md`# MineQ Field Data Service`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"md `This service provides the ability to query Measurements, GeoMeasurements and Events which are recorded in the MineQ platform.`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"md `## API Documentation`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"md `The API documentation is available at [swaggerhub](https://app.swaggerhub.com/apis/QuartileOne/mine-q_data_service) and also available directly from each service deployment [mineq-(environment)-dataserviceapi.azurewebsites.net/swagger](http://mineq-dataserviceapi.azurewebsite.net/swagger) in your browser.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"md `## Access and Authorization`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"md `To be able to access it is necessary to acquire credentials that can be used against the mineq security service which provides an [Open Id Connect](http://openid.net/connect/) implementation.\n\nTo access an API every service expects the client to authenticate against the security service and by provide a client id, client secret and a scope describing what service is to be accessed. The response includes a token which then must be provided as part of each API request.\n\nThe client id and secrets for different environments are available through a request to [developer@mineq.com.au.](mailto:developer@mineq.com.au)\n\nEnter your credentials below:`","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":63,"value":"md `### Access Token`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"md `The request to the security service has the following format.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"html `

curl -v -X POST -H \"authorization: Basic base64 encoding of {clientid} +\":\"+{clientsecret}\" -d \"grant_type=client_credentials&scope={scope}\" https://mineq-{environment}-securityserviceapi.azurewebsites.net/connect/token

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"md `The following example dynamically updates as you change input on this this page`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"html `

curl -H \"Authorization : 'Basic ${basicauth}\" -H \"Content-Type\": \"application/x-www-form-urlencoded;charset=UTF-8\" https://mineq-${environment}-securityservice.azurewebsites.net/connection/token

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":474,"value":"md `Which generates a response as below`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"security_response= fetch(\"https://mineq-\"+environment+\"-securityserviceapi.azurewebsites.net/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":478,"value":"md `The token itself is the access_token property`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":450,"value":"accesstoken = security_response.access_token","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"md `The token is expected to be included in an authorization header with each and every request to the api as per the following example.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":472,"value":"html `

curl -H \"'Authorization' : 'Bearer '+{token}\" https://mineq-dev-dataserviceapi.azurewebsites.net/api/v1/Data

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"md `## Environments\nThe api 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":583,"value":"md`### Query options`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"html `Content Type\n\n

Application/Json is the only content type currently supported.

\n\nPaging\n\n

This request returns the first 200 field data items by default.

\n\n

It it possible to use the paging parameters startEntityIndex and numberOfEntities to select a smaller or larger set and

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"viewof startEntity = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":592,"value":"viewof numberOfEntities = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"md `## Usage scenarios`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"md `To get data you always need to indicate which field data type you are querying through the Type property. `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"viewof field_data_type = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":335,"value":"md`You then use other optional properties to filter the results as described in the following samples`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":315,"value":"md `### GET All measurements for a time period`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"viewof startdate = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"viewof enddate = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"html `The access url needs to have the additional query parameters`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"measurement_for_period_query= \"&StartDateUTC=\"+startdate+\"&EndDateUtc=\"+enddate+\"&startEntity=\"+startEntity+\"&numberOfEntities=\"+numberOfEntities","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"md`The request url will be `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":354,"value":"measurement_for_period_url =requesturl(measurement_for_period_query)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":364,"value":"md`As a curl request`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":362,"value":"html `

curl -H \"'Authorization' : '${authorizationheader()}\" https://mineq-${environment}-dataserviceapi.azurewebsites.net/api/v1/Data?Type=${field_data_type}&StartDateUTC=${startdate}&EndDateUtc=${enddate}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"md`The response from the API is below`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"measurement_for_period = requestdata(measurement_for_period_url)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"viewof table_period = createTable(measurement_for_period)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"md `### Query for all Measurement for the Asset Dozer`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"\nviewof asset = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"md `Request URL`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":574,"value":"measurement_for_asset_query= \"&Asset=\"+asset+\"&startEntity=\"+startEntity+\"&numberOfEntities=\"+numberOfEntities","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"md`The response from the API is below`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":389,"value":"measurement_for_asset = requestdata(requesturl(measurement_for_asset_query))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":517,"value":"viewof table_asset = createTable(measurement_for_asset)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"md `### Query for the engine_speed for Asset Dozer1`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"viewof measurement = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"md `Request URL`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"html `

\n${requesturl(\"&Definitions=\"+measurement+\"&Asset=\"+asset)}\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":597,"value":"measurement_for_measurement_query = \"&Definitions=\"+measurement + \"&StartDateUTC=\"+startdate+\"&EndDateUtc=\"+enddate +\"&startEntity=\"+startEntity+\"&numberOfEntities=\"+numberOfEntities","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"md`The response from the API is below`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":408,"value":"measurement_for_measurement = requestdata(requesturl(measurement_for_measurement_query))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"md `# Release`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"md `[Release Notes](https://github.com/quartileone/MineQDataService/blob/development/RELEASE.md)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"html `

`","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":302,"value":"function gettoken(){\n //return \"fetch the token\" + clientid + clientsecret + scope\n fetch(\"https://mineq-dev-securityserviceapi.azurewebsites.net/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+\"-dataserviceapi.azurewebsites.net/api/v1/Data?Type=\"+field_data_type+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":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"}],"files":"$W34","stdlib":"1","titling":"auto"}} 32:"$31:body"