Internet of Things (IoT) Using the Tessel to post data



Open climate.js or ambient.js (based on which module you have) in your editor. At the top of your existing code insert the following function:

// Connect to SAP HANA
var http = require('http');
var httpOptions = {
host: 'XX.XX.XX.XX',
port: 80,
path: '/CODEJAMMER/johndoe/myiot/mydata.xsodata/DATA', method: 'POST',
headers: {
            'Authorization': 'Basic Q09ERUpBTU1FUjpDb2RlSmFtMjAxNQ==',
            'Content-Type': 'application/json'
         }
};



The function creates an http object with the proper hostname or IP address of your server and the location of your XSODATA file you created. Insert the IP address for your server in this line: host: 'XX.XX.XX.XX',



One difference between this and “Postman” is that you need to add in your “Authorization” line. In “Postman” you entered the username and password and refreshed the headers. This calculated the authorization hash. Switch back to your Postman window and copy the entire Authorization value from the header tab.

Paste the string you copied into the header section of the new function. Depending on your username and password, it may be the same as shown here.



Update the path in your httpOptions variable file to match your name (e.g. replace johndoe in the path with your name).



At the bottom of your JavaScript file, insert the function below. This function that takes your JSON formatted information and sends it via the HTTP connection you established.

// Generate JSON output and send over POST request to HANA
// Brightness field added if the ambient module is used in the future
function updateHANA(temp,humid) {
    // catch HTTP request errors
    var req = http.request(httpOptions).on('error', function(err){ console.error(err); });
    var jsonData = {
        "ID": "1",
        "BRIGHTNESS": "27",
        "TEMPERATURE": temp,
        "HUMIDITY": humid,
    };
    var strData = JSON.stringify(jsonData);
    console.log(strData);
    req.write(strData);
    req.end();
};



To invoke the new functions in your code you will insert a call to the updateIoT function where data is sent to the console log for output. For example in climate.js, insert the following just after the call to console.log():

updateIoT(temp.toFixed(4), humid.toFixed(4));



Change the timeout from 300 to 3000 (3 seconds).

setTimeout(loop, 3000);



Before running your script, you need to connect the Tessel to the Internet. Run the following command line file (in your CMD or Terminal window) replacing SSID and password with the appropriate Wi-Fi credentials (if you are at home or the office, use what is appropriate):

tessel wifi -n SSID -p password

If you are successful, you should see something like this in the console/terminal:



Now run your code with the command below. You should see an output in your terminal/command window as shown below. You can refresh the query in the catalog to see the data inserted into HANA.

tessel run climate.js







In addition to viewing the data directly, you can view the OData service in a browser or application. To view the OData service in the browser, double-click the mydata.xsodata file to open it in your editor, then click the green run button. This will open a new browser tab to the OData service document.



The URL to the service document is shown below (for johndoe). To see your data, add /HISTORY to see the XML feed or /HISTORY?$format=json for JSON format to the end of the URL as shown here:

• Service Document: http://52.90.177.151/CODEJAMMER/johndoe/myiot/mydata.xsodata
• XML Version: http://52.90.177.151/CODEJAMMER/johndoe/myiot/mydata.xsodata/HISTORY
• JSON Version: http://52.90.177.151/CODEJAMMER/johndoe/myiot/mydata.xsodata/HISTORY?$format=json

The JSON formatted output:



The XS OData service also allows you to build applications to display the data. You could do this with SAP Web IDE or any number of tools. To keep things simple, you will modify the index.html file that was added to your project when you did the Create Application step.
Replace the existing file contents with the HTML/JavaScript contents below to add a table to the page. There is more than one way to do this so feel free to explore and discover!

<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta charset="UTF-8"/>
<title>My Sensor Data</title>
<script id='sap-ui-bootstrap'
src='/sap/ui5/1/resources/sap-ui-core.js'
data-sap-ui-theme='sap_goldreflection'
data-sap-ui-libs='sap.ui.core,sap.ui.commons,sap.ui.table'></script>

<script language="JavaScript">
var oModel = new sap.ui.model.odata.ODataModel("/CODEJAMMER/johndoe/myiot/mydata.xsodata/", false);
var arrayHeaders = new Array();
var ROW_COUNT = 40;

oTable = new sap.ui.table.Table("test",{tableId: "tableID", visibleRowCount: ROW_COUNT});
//Bring the table onto the UI
oTable.placeAt("sensor_table");
//Table Column Definitions
var oMeta = oModel.getServiceMetadata();
var oControl;
for ( var i = 0; i < oMeta.dataServices.schema[0].entityType[0].property.length; i++) {
      var property = oMeta.dataServices.schema[0].entityType[0].property[i];

    oControl = new sap.ui.commons.TextField().bindProperty("value",property.name);
    oTable.addColumn(new sap.ui.table.Column({label:new sap.ui.commons.Label({text: property.name}), template: oControl, sortProperty: property.name, filterProperty: property.name, filterOperator: sap.ui.model.FilterOperator.EQ, flexible: true, width: "125px" }));
}                      
oTable.setModel(oModel);
var sort1 = new sap.ui.model.Sorter("ID");
oTable.bindRows("/DATA",sort1);
</script>
</head>
<body>
<div id="sensor_table"> </div>
</body>
</html>

The web view is shown here. Note that since this pages uses the SAPUI5 JavaScript framework, this is now a responsive web app and if you were to open this on your tablet or smartphone you would see a similar view but it would fit better to the screen of your device.