@martinp ne, der Token ist im Adapter 🙂
Blockly
Spoiler
<xml xmlns="https://developers.google.com/blockly/xml">
<variables>
<variable id="0grn+ZZ^A{TEgVTYs)x4">Influxdb</variable>
<variable id="7h*q~fZDx{Qg;bxZv02f">Datenpunkt</variable>
<variable id="bU67QEX4Pg0|ofer{R)T">Startdatum</variable>
<variable id="{fo.)eP%`achV^,#lu7p">Enddatum</variable>
<variable id="FY32ON^[.^(}pN3d25;j">Ergebnis</variable>
</variables>
<block type="procedures_defcustomreturn" id="^3P(QTQ]b)r44*Ap2[$s" x="138" y="-862">
<mutation statements="false">
<arg name="Influxdb" varid="0grn+ZZ^A{TEgVTYs)x4"></arg>
<arg name="Datenpunkt" varid="7h*q~fZDx{Qg;bxZv02f"></arg>
<arg name="Startdatum" varid="bU67QEX4Pg0|ofer{R)T"></arg>
<arg name="Enddatum" varid="{fo.)eP%`achV^,#lu7p"></arg>
</mutation>
<field name="NAME">Query</field>
<field name="SCRIPT">DQp2YXIgZXJnZWJuaXM7DQpzZW5kVG8oJ2luZmx1eGRiLicrSW5mbHV4ZGIrJycsICdkZWxldGVSYW5nZScsIFsNCiAgICB7aWQ6ICcnK0RhdGVucHVua3QrJycsIHN0YXJ0OiAnK1N0YXJ0ZGF0dW0rJywgZW5kOiAnK0VuZGRhdHVtKyd9DQpdLCANCg0KZnVuY3Rpb24gKHJlc3VsdCkgew0KICAgIGlmIChyZXN1bHQuZXJyb3IpIHsNCiAgICAgICAgY29uc29sZS5lcnJvcihyZXN1bHQuZXJyb3IpOw0KICAgIH0gZWxzZSB7DQogICAgICAgIC8vIHNob3cgcmVzdWx0DQogICAgICAgIC8vIGNvbnNvbGUubG9nKCdSb3dzOiAnICsgSlNPTi5zdHJpbmdpZnkocmVzdWx0KSk7DQogICAgICAgIGVyZ2VibmlzID0gSlNPTi5zdHJpbmdpZnkocmVzdWx0KTsNCiAgICB9DQp9KTsNCmF3YWl0IHdhaXQoMTAwMCk7DQpyZXR1cm4gZXJnZWJuaXM7DQo=</field>
<comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment>
</block>
<block type="variables_set" id="Qpo#umj?Zy%]d6sR7az+" x="138" y="-792">
<field name="VAR" id="FY32ON^[.^(}pN3d25;j">Ergebnis</field>
<value name="VALUE">
<block type="procedures_callcustomreturn" id="~HE?3SQL+/75:(Ix}#^V">
<mutation name="Query">
<arg name="Influxdb"></arg>
<arg name="Datenpunkt"></arg>
<arg name="Startdatum"></arg>
<arg name="Enddatum"></arg>
</mutation>
<value name="ARG0">
<block type="text" id="=4LUZp0ul,`Gc[P6~=Si">
<field name="TEXT">0</field>
</block>
</value>
<value name="ARG1">
<block type="text" id="SZ[VuOHvHspXe~`(~DKe">
<field name="TEXT">xxx</field>
</block>
</value>
<value name="ARG2">
<block type="text" id="5iMW`#nn-(+}AY5A%5+f">
<field name="TEXT">2024-08-17T13:00:00.000Z</field>
</block>
</value>
<value name="ARG3">
<block type="text" id="hra#F(}ld5]Ul1Nw!n%3">
<field name="TEXT">2024-08-17T13:00:00.000Z</field>
</block>
</value>
</block>
</value>
<next>
<block type="debug" id="dBD/LU,q,`5r:-U]Y/Cy">
<field name="Severity">warn</field>
<value name="TEXT">
<shadow type="text" id="/4edf?_}em?hla,K)f!a">
<field name="TEXT">test</field>
</shadow>
<block type="variables_get" id="Rovd}jR]w[OI3]21#V]c">
<field name="VAR" id="FY32ON^[.^(}pN3d25;j">Ergebnis</field>
</block>
</value>
</block>
</next>
</block>
</xml>
Funktion
Spoiler
var ergebnis;
sendTo('influxdb.'+Influxdb+'', 'deleteRange', [
{id: ''+Datenpunkt+'', start: '+Startdatum+', end: '+Enddatum+'}
],
function (result) {
if (result.error) {
console.error(result.error);
} else {
// show result
// console.log('Rows: ' + JSON.stringify(result));
ergebnis = JSON.stringify(result);
}
});
await wait(1000);
return ergebnis;
