Retrieving data with a REST API call always results in a standard JSON output, but sometimes a fast-and-easy export to a human-readable format is required. While any operations to the devices via API are explicitly described in the Devices API documentation, in this article, we'll highlight some particular cases for retrieving the device data and exporting it to CSV format.
Export devices list
If you need to export a list of all devices in your account navigate to Gateway API > Devices > Manage section:
Here you need to apply 'all' for the 'dev-selector' path and click on the 'eye' icon at the bottom to perform the REST API call.
Alternatively, you can get the same results by performing the following API call:
GET /gw/devices/all
A window will pop up, and then you can switch to the 'Table' view where you have the option to sort or filter out custom parameters. Clicking the 'Export to CSV' icon on the upper-right will provide you with a .csv file.
Export devices list with selected parameters
By default, you receive the list of all default device parameters, but you may only require some of them. In this case, you can narrow down the search by specifying the desired parameters in the 'fields' section. For example, to export only the 'device id' and 'name', select them by clicking the '+' sign:
Or you can use the following request:
GET /gw/devices/all?fields=id,name
You may notice that some parameters are not listed here, but you can still manually add a required one by clicking the '{...}' icon and modifying JSON. For example, if we need to include the 'configuration.ident' parameter in our list of devices:
Or perform the following request:
GET /gw/devices/all?fields=id,name,configuration.ident
Keep in mind that you can always switch to the table view in the output window to download a .csv file with the results.
Done!