Download the List of All IOT Devices via AWS CLI AS CSV File Via Node JS

April 17, 2022

Below is the script for downloading the list of all IOT Devices from the AWS via AWS CLI.

You shoule have aws cli properly setup.
Node Should be installed.
Packages required for running the script are
- child_process
- fs

Below script will download all things with Thing type name ABC1, assuming file name is export.js

"use strict";
const { exec } = require("child_process");
const fs = require("fs");
const byDevice = "ABC1";
const arr = [["Thing Name", "Thing Type", "Arn", "Version"]];
const command = "aws iot list-things --max-items 200 ";
const exportThings = (NextToken) => {
    let command1 = command;
    if (byDevice.length > 0) {
        command1 += " --thing-type-name  " + byDevice + " ";
    }
    if (NextToken) {
        command1 += " --starting-token " + NextToken;
    }
    console.log("Executing command :- " + command1);
    exec(command1, (error, stdout, stderr) => {
        if (error) {
            console.log(`error: ${error.message}`);
            return;
        }
        if (stderr) {
            console.log(`stderr: ${stderr}`);
            return;
        }
        const data = JSON.parse(stdout);
        for (const k of data["things"]) {
            const { thingName, thingTypeName , thingArn, version} = k;
            arr.push([thingName, thingTypeName, thingArn, version]);
        }
        if (data["NextToken"]) {
            exportThings(data["NextToken"]);
        } else {
            console.log("Exporting to things.csv")
            fs.writeFileSync("things.csv", arr.join("\n"));
            process.exit();
        }
    });
}
exportThings();

To run the above file use below command