/*

Retrieve JSON data from a Smart Energy Meter using a REST API and store it in an Azure SQL database

*/

RestApi.sendRequest('Shelly');
if (RestApi.isSucceeded()) {
          const energyData = RestApi.getData('Shelly');
          // add processing code if needed
          let ts = InDriver.hookTs().toISOString();
          InDriver.sqlExecute("azureserver", "insert into public.energy   (source, ts, data)         values ( 'Shelly','"+ts+"',$$"+energyData+"$$);"
}