Here is a list of sample request and response for the smart farming app.
Request from XDK to Gateway for light and environment feed
1 2 3 4 |
{ "DeviceID":"XDX1", "lux":"2121" } |
1 2 3 4 5 6 |
{ "DeviceID":"XDX1", "temp":"25000", "pressure":"21211", "humidity":"45" } |
Feed upload to Salesforce Analytics
1 2 |
DeviceID,DateTime,Lux XDX1,20180328 103410.918,2121 |
1 2 |
DeviceID,DateTime,Temperature,Humidity,Pressure XDX1,20180328 103410.918,25.00,45,21211 |
Salesforce Analytics GET Request and Response
- Lux
1 2 3 |
{ "query":"q = load \"0Fb7F000000XmenSAC/0Fc7F000002EnxoSAC\";q = foreach q generate DateTime as DateTime, DeviceID as DeviceID, Lux as Lux;q = order q by DateTime desc ;q = limit q 15;" } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
{ "action":"query", "responseId":"4IUpUk8Up-PM1jIdp8bgo-", "results":{ "metadata":[ { "columns":[ { "name":"DateTime", "type":"string" }, { "name":"DeviceID", "type":"string" }, { "name":"Lux", "type":"string" } ], "groups":[ ] } ], "records":[ { "DateTime":"20180613 074410.516", "DeviceID":"XDX1", "Lux":"6255" }, { "DateTime":"20180613 074410.515", "DeviceID":"XDX1", "Lux":"13230" } ] }, "query":"q = load \"0Fb7F000000XmenSAC/0Fc7F000002EnxoSAC\";q = foreach q generate DateTime as DateTime, DeviceID as DeviceID, Lux as Lux;q = order q by DateTime desc ;q = limit q 2;", "responseTime":280 |
- Environment
1 2 3 |
{ "query":"q = load \"0Fb7F000000PYhISAW/0Fc7F000002EnxtSAC\";q = foreach q generate DateTime as DateTime, DeviceID as DeviceID, Temperature as Temperature,Humidity as Humidity,Pressure as Pressure;q = order q by DateTime desc ;q = limit q 2;" } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
{ "action":"query", "responseId":"4IUpteW6AAqM9jIdp8bgo-", "results":{ "metadata":[ { "columns":[ { "name":"DateTime", "type":"string" }, { "name":"DeviceID", "type":"string" }, { "name":"Temperature", "type":"string" }, { "name":"Humidity", "type":"string" }, { "name":"Pressure", "type":"string" } ], "groups":[ ] } ], "records":[ { "DateTime":"20180613 074410.569", "DeviceID":"XDX1", "Humidity":"61", "Pressure":"90990", "Temperature":"26.78" }, { "DateTime":"20180613 074410.568", "DeviceID":"XDX1", "Humidity":"61", "Pressure":"90988", "Temperature":"26.77" } ] }, "query":"q = load \"0Fb7F000000PYhISAW/0Fc7F000002EnxtSAC\";q = foreach q generate DateTime as DateTime, DeviceID as DeviceID, Temperature as Temperature,Humidity as Humidity,Pressure as Pressure;q = order q by DateTime desc ;q = limit q 2;", "responseTime":1597 |
Salesforce Analytics Response to Flow Service
1 2 3 4 5 6 7 8 9 10 11 12 |
[ { "ID":"XDX1", "Lux":"121212", "DateTimeF":"20180613 074410.569" }, { "ID":"XDX1", "Lux":"12333", "DateTimeF":"20180613 074410.566" } ] |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[ { "ID":"XDX1", "Temp":"26.78", "Pressure":"90990", "Humidity":"61", "DateTimeF":"20180613 074410.569" }, { "ID":"XDX1", "Temp":"26.77", "Pressure":"90988", "Humidity":"61", "DateTimeF":"20180613 074410.568" } ] |
Master Data Hub product query request /response
1 |
<?xml version="1.0" encoding="UTF-8"?> <RecordQueryRequest limit="100" offsetToken=""> <filter> <fieldValue> <fieldId>SKU</fieldId> <operator>EQUALS</operator> <value>Xdk101</value> </fieldValue> </filter> </RecordQueryRequest> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
[ { "description":"Smart Neo Light", "name":"Smart Light (Pro)", "active":"Y", "category":"IoT", "code":"123121", "color":"White", "default_vendor":"XYZ Lights", "display_name":"XDK", "pack_quantity":"1", "price":"216", "serial_number":"A121121", "sku":"Xdk101", "support_type":"Gold" } ] |
Note: The above response can be used to import the model into the Dell Boomi Master Data Hub to create the data model.
Request to turn device on/off manually
1 2 3 4 |
{ "DeviceID":"XDX1", "Status":"true" } |