top of page

Using API to Link Ellenex IoT Platform with Other Visualisation Platforms.

Writer's picture: Amar MAmar M

A simple visualisation created using PowerBI with Ellenex API as a source
We believe integratability is the key success point for IoT solutions. That is why we developed the most integratable LPWAN IoT framework to address current and future demands of our industrial clients.

The Ellenex IoT Platform is designed to excel in data collection and near real-time analytics, featuring a highly capable visualisation engine tailored for device-specific data. While we've equipped the platform with a rich set of functionalities, we understand that enterprises often require more customised solutions for amalgamating IoT device metrics with other operational KPIs, such as service costs or broader reporting needs.


EllenexQL: Your Gateway to Custom Data Integration


To address this, we've introduced a specialised EllenexQL endpoint within our API. This endpoint allows industrial clients to query device-specific data within specified date ranges and perform arithmetic operations and aggregations.


The flexibility afforded by this API endpoint makes it easy to integrate Ellenex's data into any third-party platforms your organisation may already be using.


Sample Query for Data Retrieval from Ellenex IoT Platform via API

Below is a sample query structure designed to fetch data through our REST Data Store APIs:

{
	"@context": "https://schema.ellenex.com/v1/context.jsonld",
	"@type": "QueryObject",
	"kind": "Raw",
	"granularity": "all",
	"dimensions": [ "resultTime", "device", "pressure", "unit"],
	"filter": {
		"@type": "Filter",
		"kind": "and",
		"fields": [{
			"@type": "Field",
			"kind": "eq",
			"dimension": "device",
			"value": "/v1/edi/devices/0ccd677a-d01e-49d9-98a6-5f3d4bcccc46"
		}]
	},
	"intervals": "2023-05-14T00:00:00.000/2023-05-17T00:00:00.000"
}

This robust query format not only allows for data retrieval but also supports advanced features like aggregations.


Analytics with PowerBI

EllenexQL can be directly connected to reporting tools such as PowerBI, facilitating instant juxtaposition of your device metrics with other data sources within your organisational framework.


Sample PowerBI Query for Ellenex Data Import

Here's a sample code snippet for importing data from the Ellenex Platform into PowerBI, utilising the same request body schema as above but adapted for variable extraction:

let 
Payload = Json.FromValue([
        #"@context" = "https://schema.ellenex.com/v1/context.jsonld",
        #"@type" = "QueryObject",
        #"kind" = "Raw",
        #"granularity" = "all",
        #"dimensions" = {"resultTime", "device", "pressure", "unit"},
        #"filter" = [#"@type" = "Filter", #"kind" = "and", #"fields" = {[#"@type" = "Field", #"kind" = "eq", #"dimension" = "device", #"value" = DeviceId]}],
        #"intervals" = DateTime.ToText(StartTime, "yyyy-MM-ddThh:mm:ss.000") &"/"&DateTime.ToText(EndTime, "yyyy-MM-ddThh:mm:ss.000")
    ]),

source = Json.Document(Web.Contents("https://api.ellenex.net/v1/edsa/observations/eql", 
[Headers=[#"Content-Type"="application/json",#"x-api-key"=ApiKey,#"x-lnx-token"=ApiToken],
    Content=Payload
])),
deviceDatapoints = Table.FromRows(source[values],source[columns]),
    #"Changed Type" = Table.TransformColumnTypes(deviceDatapoints,{{"time", type datetimezone}, {"pressure", type number}})
in 
#"Changed Type"

This is just a basic version of the query; a seasoned expert can do much more.


Visualisation Capabilities

Once the API data is ingested into PowerBI, you can visualise it directly within the query editor.

A simple table view of the data received from API on PowerBI

By leveraging PowerBI's extensive features, you can build comprehensive dashboards to track maximum pressure, among other metrics, through gauges and bar graphs.

A simple visualisation created using PowerBI with Ellenex API as a source
A simple visualisation created using PowerBI with Ellenex API as a source

Extending Your Analytics

The flexibility of our API means you can achieve complex multi-device and multi-datapoint visualisations by employing a variety of filters and aggregations.


Get Started with Ellenex

For more comprehensive documentation or specialised assistance in integrating Ellenex's API with other reporting tools, please don't hesitate to contact our support team.


By utilising EllenexQL and our API, you can fully exploit the Ellenex IoT Platform’s data retrieval and analysis capabilities, ensuring that your organisation can adapt to the ever-evolving landscape of industrial analytics.



ellenex logo - Industrial Iot Solution
order iot product
ellenex linkedin
ellenex x contact
ellenex youtube
ellenex contact
ellenex facebook
INSTAGRAM ELLENEX

© 2025 Ellenex Corporation 

Don't Settle for Less ...

Supported Networks:

 

Products:

Industries:

ellenex NB IoT
ellenex lorawan
ellenex satellite
ellenex LTE Cat M1
ellenex wirepas
hvac monitoring
water monitoring
diesel tank monitoring
differential pressure sensor
well monitoring
wireless sensor
ellenex-github
wireless pressure sensor
wireless level
wireless remperature
smart meter
ellenex water quality sensors ph conductivity turbidity dissolved oxygenedited
ellenex IoT moisture rain and humidity sensors
iot product
iot solution
ellenex%20other%20products_edited_edited
  • Air Compressor Operation Monitoring

  • Asset Cathodic Protection Monitoring

  • Asset Temperature Monitoring

  • Boilers Pressure and Temperature Monitoring

  • Building Structural Health Monitoring

  • Chemical Tanks Level Monitoring

  • Data Centre and Clean Room Pressure Monitoring

  • Diesel Delivery Management

  • Differential Pressure Monitoring

  • Dump Truck Overload and Operation Monitoring

  • Dust Collection System Monitoring

  • Farm Fish Operation Monitoring

  • Flood Monitoring

  • Frozen Food Delivery Management

  • Grain Silo Level Monitoring

  • HVAC Air Filter Performance Monitoring

  • HVAC Airflow Monitoring

  • Hydraulic Systems Overload Monitoring

  • Industrial Gas Cylinders Level Monitoring

  • Industrial Water Meters Digitalisation

  • Land Movement Monitoring

  • Liquid Storage Tank Level Monitoring

  • Manhole Blockage Monitoring

  • Milk Tank Level Monitoring

  • Negative Pressure Monitoring

  • Operational System Digitalisation

  • Pipe Temperature and Pressure Monitoring

  • Pump Pressure Monitoring

  • Rain Level Monitoring

  • Remote Diesel Tank Level Monitoring

  • Soil Moisture Monitoring

  • Trucks Overload Monitoring

  • Underground Water Pipeline Pressure Monitoring

  • Waste Liquid Delivery Management

  • Wastewater Pipe Pressure Monitoring

  • Water Filter Performance Monitoring

  • Water Quality Monitoring

  • Water Supply Monitoring

  • Water Tank Level Monitoring

  • Water Wells Level Monitoring

Key pre-configured Industrial IoT solutions

Main Industrial IoT Sensors: 

  • PTS2: Industrial Pressure (0.2bar to 1,000bar)

  • PTC2: Corrosive Resistant Pressure

  • PTD2: Pressure Sensor with Built-in Temperature Sensor

  • PTDH2: High Temperature Pressure and Temperature Sensor

  • PTG2: Pressure with Built-in GPS

  • PTS3: IP68 Pressure Sensor

  • PTF2: Flush Type Pressure Sensor

  • PTF2: Thich film Flush type Pressure

  • PTE2: Earth Pressure Sensor

  • PDS2: Industrial Differential Pressure Sensor

  • PDG2: DP with Built-in GPS

  • PDT2: Ultra Low Range Air Pressure and Temperature

  • PLS2: Submersible Level (1m to 200m range)

  • PLC2: Corrosive Resistant Level (Titanium)

  • PLD2: Level Sensor with Built-in Temperature

  • PLG2: Level Sensor with Built-in GPS

  • PLS3: Submersible Level Sensor with IP68 Housing

  • PLM2: Well Level Sensor (15.8mm Sensor Head, 2in Housing)

  • PLMD2: Well Level and Temperature Sensor

  • TTS2: Industrial Temperature Sensor

  • TTG2: Temperature Sensor with Built-in GPS

  • TTS3: Temperature Sensor with IP68 housing

  • TTS2: Pipe Temperature Sensor

  • DUS3: IP68 Ultrasonic Level Sensor

  • DRC3: IP68 Corrosive Radar Sensor (8m and 30m range)

  • FMS2: Industrial Water Meter Interface

  • CSD2: Conductivity Salinity and Temperature sensor

  • CTR2: Turbidity and Temperature Sensor

  • CPH2: pH, ORP and Temperature Sensor

  • CDO2: Dissolved Oxygen and Temperature Sensor

  • MSS2: Soil Moisture Sensor

  • MAS2: Outdoor Humidity Sensor

  • MRS2: Rain Sensor (Tipping bucket)

  • ECP2: Cathodic Protection Sensor

  • RS1-4/20: Single channel 4-20mA Interface

  • RS1-P: Single channel Pulse Interface

  • RS1-SDI: Single channel SDI-12 Interface

  • RS1-M: Single channel Modbus Interface

  • RS1-Pt: Single channel Pt100 Interface

  • RM1: Multi-channel Interface

  • RM4-4/20: Multi-channel Interface (4 x 4-20mA Sensor)

  • RM4-Pt: Multi-channel Interface (4 x Pt Sensor)

  • RM4-M: Multi-channel Interface (4 x Modbus)

  • RM4-mV: Multi-channel Interface (4 x mV Sensors)

  • RM4-Pulse: Multi-channel Interface (4 x Pulse Counter)

  • RM4-0/10: Multi-channel Interface (4 x 0-10V Sensor)

bottom of page