HOW TO:  Obtain a List of Device Cloud Connected or Disconnected Devices 

The following examples may be used in a web browser in order to obtain a list of devices which are currently in a connected state on your Device Cloud account.
 

Devices Currently Connected:

https://devicecloud.digi.com/ws/DeviceCore/?condition=dpConnectionStatus=1
 

Connected devices in order by the device ID:

https://devicecloud.digi.com/ws/DeviceCore/?condition=dpConnectionStatus=1&orderby=devId
 

For disconnected devices:

https://devicecloud.digi.com/ws/DeviceCore/?condition=dpConnectionStatus=0
 

For json formatted results:

https://devicecloud.digi.com/ws/DeviceCore/.json?condition=dpConnectionStatus=1

To export to .xls file:

Additional pages (over 1000):

The maximum number of records returned in a query is 1000, for more than 1000 records additional queries can be done using the start argument:

https://devicecloud.digi.com/ws/DeviceCore/?condition=dpConnectionStatus=1&start=1000

For the next 1000 devices:

https://devicecloud.digi.com/ws/DeviceCore/?condition=dpConnectionStatus=1&start=2000

And so on...