PLATFORMS SOLUTIONS BLOGS CONTACT

Insteon Adapter



Access Insteon devices from SQL Server and REST commands


This adapter requires Insteon devices and COM Port setup



Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String commPort The default COMM port for Insteon communication COM1

Handlers



ControllerInfo Get attached controller details details 

Arguments


SQL Call

exec bsc.Insteon.ControllerInfo


Http Call

/bsc/insteon/controllerinfo

Output Columns

String DeviceCatDevice Category
String SubcategoryDevice Subcategory
String FirmwareFirmware version
Light Turn a light on/off details 

Arguments

Name Description Default
DevId R Device ID
OnOff True/false to turn the light on/off True

SQL Call

exec bsc.Insteon.Light 123, 1    -- turn the light on at address 123
exec bsc.Insteon.Light 123, 0 -- turn the light off at address 123
update bsc.Insteon.Light set OnOff = 1 where DevId = 123 -- turn the light on at address 123
update bsc.Insteon.Light set OnOff = 0 where DevId = 123 -- turn the light off at address 123


Http Call

/bsc/insteon/light

Output Columns

This call does not return data.

LightLevel Dim a light up/down to the specified level details 

Arguments

Name Description Default
DevId R Device ID
level True/false to turn the light on/off. Must be between 0 and 255. 255

SQL Call

exec bsc.Insteon.LightLevel 123, 128    -- turn the light halfway on at address 123
exec bsc.Insteon.LightLevel 123, 64 -- turn the light to a quarter brightness at address 123
update bsc.Insteon.LightLevel set Level = 128 where DevId = 123 -- turn the light halfway on at address 123
update bsc.Insteon.LightLevel set Level = 64 where DevId = 123 -- turn the light to a quarter brightness at address 123


Http Call

/bsc/insteon/lightlevel

Output Columns

This call does not return data.

ListDevices List the devices available to the attached Insteon controller. details 

Arguments


SQL Call

exec Insteon.ListDevices
select * from Insteon.ListDevices


Http Call

/bsc/insteon/listdevices

Output Columns

String CommPortSerial device used
Int32 DevIdDevice ID
Int32 DevIdHiDevice ID high byte
Int32 DevIdMidDevice ID middle byte
Int32 DevIdLoDevice ID low byte
String TypeType of device
RampLevel Gracefully dim a light up/down to the specified level details 

Arguments

Name Description Default
DevId R Device ID
level True/false to turn the light on/off. Must be between 0 and 255. 255

SQL Call

exec bsc.Insteon.RampLevel 123, 128    -- turn the light halfway on at address 123
exec bsc.Insteon.RampLevel 123, 64 -- turn the light to a quarter brightness at address 123
update bsc.Insteon.RampLevel set Level = 128 where DevId = 123 -- turn the light halfway on at address 123
update bsc.Insteon.RampLevel set Level = 64 where DevId = 123 -- turn the light to a quarter brightness at address 123


Http Call

/bsc/insteon/ramplevel

Output Columns

This call does not return data.

RefreshDevices Update the internal list of available devices details 

Arguments


SQL Call

exec bsc.Insteon.RefreshDevices


Http Call

/bsc/insteon/refreshdevices

Output Columns

This call does not return data.

SetCommPort Changes the COM port used for communication details 

Arguments

Name Description Default
commPort R The COM port to use for Insteon commands

SQL Call

exec bsc.Insteon.SetCommPort 'COM3'


Http Call

/bsc/insteon/setcommport

Output Columns

This call does not return data.








601 21st St Suite 300
Vero Beach, FL 32960
United States

(561) 921-8669
info@enzounified.com
terms of service
privacy policy

PLATFORM

ENZO SERVER
ENZO DATAZEN

SOLUTIONS

SOLUTIONS OVERVIEW
INTEGRATION
SaaS
CLOUD ANALYTICS

RESOURCES

DOWNLOAD
BLOGS & VIDEOS
IN THE NEWS
ENZO ADAPTERS
ONLINE DOCUMENTATION
TCO CALCULATOR

COMPANY

LEADERSHIP TEAM
PARTNERS


© 2023 - Enzo Unified