<xml xmlns="https://developers.google.com/blockly/xml">
<variables>
<variable id=":)VLwK/`@H+J(LM#$WD7">flux</variable>
<variable id="Hap*,T)oNQNM[M8bZeb7">result</variable>
<variable id=".5z}V1WTXA6xD^rmM@W4">preis</variable>
<variable id="19e+]})FfXk}~`Wj.4bM">htmlString</variable>
</variables>
<block type="schedule" id="n=UEN2;yjIT1`l#FdcV_" x="-1787" y="-987">
<field name="SCHEDULE">* * * * *</field>
<statement name="STATEMENT">
<block type="variables_set" id="x45T#QqEweP.8DbaXVqx">
<field name="VAR" id=":)VLwK/`@H+J(LM#$WD7">flux</field>
<value name="VALUE">
<block type="text_join" id="o9Vd,Q~U,{!3is[fPCf.">
<mutation items="7"></mutation>
<value name="ADD0">
<block type="text" id="?I]TaO6_Vbp6gDEIQkdm">
<field name="TEXT">SELECT last("value") FROM "e3dc-rscp.0.EMS.POWER_HOME" WHERE time >= now() - 2d and time <= now()</field>
</block>
</value>
</block>
</value>
<next>
<block type="sendto_custom" id="5y7]CToD:3Ygw}FhT%(D">
<mutation xmlns="http://www.w3.org/1999/xhtml" items="" with_statement="true"></mutation>
<field name="INSTANCE">influxdb.0</field>
<field name="COMMAND">query</field>
<field name="LOG"></field>
<field name="WITH_STATEMENT">TRUE</field>
<value name="ARG0">
<shadow type="text" id="NNx0rHt6*yq21~HguTF2">
<field name="TEXT">from(bucket: "ioBroker") |> range(start: -14d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "DP_Guenstigste") |> filter(fn: (r) => r["_field"] == "value") |> filter(fn: (r) => r._value > 0) |> group() |> min()</field>
</shadow>
<block type="variables_get" id="B}$z9o?iyz%Y*wBKcvDF">
<field name="VAR" id=":)VLwK/`@H+J(LM#$WD7">flux</field>
</block>
</value>
<statement name="STATEMENT">
<block type="controls_if" id="@q#iNuUr!:m7zob|9%)u">
<mutation else="1"></mutation>
<value name="IF0">
<block type="logic_compare" id="|vlsW/V*`9wqY9BOp$Cx">
<field name="OP">NEQ</field>
<value name="A">
<block type="get_attr" id="^9J$l,fj?KhQ@qUB:Nas">
<value name="PATH">
<shadow type="text" id="~z[BTi$mMMYZ+GcomoOq">
<field name="TEXT">error</field>
</shadow>
</value>
<value name="OBJECT">
<block type="variables_get" id="N@T;SzLIsoETGcO$H+ri">
<field name="VAR" id="Hap*,T)oNQNM[M8bZeb7">result</field>
</block>
</value>
</block>
</value>
<value name="B">
<block type="logic_null" id="+U3-sX~0PE)=BKfCuo7O"></block>
</value>
</block>
</value>
<statement name="DO0">
<block type="debug" id="LCT~%[BmemUbm?b4]W6U" inline="true">
<field name="Severity">error</field>
<value name="TEXT">
<shadow type="text" id="mDRzWYEa1NzHsf1:2u16">
<field name="TEXT">test</field>
</shadow>
<block type="get_attr" id="8G61*~d~XGk2qY$ng{D4">
<value name="PATH">
<shadow type="text" id="45h$8w}|$sRP,uLQ(70%">
<field name="TEXT">error</field>
</shadow>
</value>
<value name="OBJECT">
<block type="variables_get" id="LIT!%WT~ykvRmkF=1Gc9">
<field name="VAR" id="Hap*,T)oNQNM[M8bZeb7">result</field>
</block>
</value>
</block>
</value>
</block>
</statement>
<statement name="ELSE">
<block type="debug" id="*{3T#Du4w~:TroJZ6?7o">
<field name="Severity">log</field>
<value name="TEXT">
<shadow type="text" id="rKJ^P{TxN(jKoW}ETA*l">
<field name="TEXT">test</field>
</shadow>
<block type="variables_get" id="k{fzf,[:pu[Qah[M:FAf">
<field name="VAR" id="Hap*,T)oNQNM[M8bZeb7">result</field>
</block>
</value>
<next>
<block type="variables_set" id="DD6;G(Wo]rIFaI+6.8:?">
<field name="VAR" id=".5z}V1WTXA6xD^rmM@W4">preis</field>
<value name="VALUE">
<block type="convert_tostring" id="MQ|=t3[21rC.~l3cFZea">
<value name="VALUE">
<block type="get_attr" id="n36f=MeXwJ3Yc1kOE1/$">
<value name="PATH">
<shadow type="text" id="(b0I9y0aoY#dd84CK7KS">
<field name="TEXT">result.0.0.last</field>
</shadow>
</value>
<value name="OBJECT">
<block type="convert_object2json" id="ERm+qpC!vRo1]{;r$+$(">
<field name="PRETTIFY">TRUE</field>
<value name="VALUE">
<block type="variables_get" id="+6+4;B%#/G*bG`j}yEgo">
<field name="VAR" id="Hap*,T)oNQNM[M8bZeb7">result</field>
</block>
</value>
</block>
</value>
</block>
</value>
</block>
</value>
<next>
<block type="debug" id="Dk~te}`/A.7SOl~GxbHb">
<field name="Severity">log</field>
<value name="TEXT">
<shadow type="text">
<field name="TEXT">test</field>
</shadow>
<block type="variables_get" id="qVv+RA+qJOw4*h)Yt_m5">
<field name="VAR" id=".5z}V1WTXA6xD^rmM@W4">preis</field>
</block>
</value>
<next>
<block type="comment" id="KoZ]ZSByDTlWb4^s_)xQ">
<field name="COMMENT">Kommentar</field>
<next>
<block type="debug" id="-M)_Dgrsw.+.x@5y1*()" inline="true" disabled="true">
<field name="Severity">log</field>
<value name="TEXT">
<shadow type="text">
<field name="TEXT">test</field>
</shadow>
<block type="variables_get" id="e--Fk%lR(K!5Z96CC{uu">
<field name="VAR" id=".5z}V1WTXA6xD^rmM@W4">preis</field>
</block>
</value>
<next>
<block type="controls_if" id="iuLo^lOy^Qg)/#[A*q(L">
<mutation else="1"></mutation>
<value name="IF0">
<block type="logic_compare" id="U.wOefdDK@:;kt3`^MmY">
<field name="OP">NEQ</field>
<value name="A">
<block type="text_length" id="-~ACns1F5u7EF=f(qfVs">
<value name="VALUE">
<shadow type="text" id=":xhtsG,UW?hdA9r~/IJ+">
<field name="TEXT">abc</field>
</shadow>
<block type="variables_get" id="[wde$^9G?veK#O[!#aK3">
<field name="VAR" id=".5z}V1WTXA6xD^rmM@W4">preis</field>
</block>
</value>
</block>
</value>
<value name="B">
<block type="math_number" id="O};wwWf9LLIWspXZ_ZG.">
<field name="NUM">0</field>
</block>
</value>
</block>
</value>
<statement name="DO0">
<block type="variables_set" id="vd3MOaB/E.B.%`GT+Fw%">
<field name="VAR" id="19e+]})FfXk}~`Wj.4bM">htmlString</field>
<value name="VALUE">
<block type="text_join" id="BNP,)B,LyiB6@@zuP`MQ">
<mutation items="5"></mutation>
<value name="ADD0">
<block type="math_rndfixed" id="`7)CQyf3rs|:wgv(?zkQ">
<field name="n">2</field>
<value name="x">
<shadow type="math_number" id="aD68X9^3_V]EXP2,k~um">
<field name="NUM">3.1234</field>
</shadow>
<block type="variables_get" id="pdHSe%(ol_jZx6frXiWv">
<field name="VAR" id=".5z}V1WTXA6xD^rmM@W4">preis</field>
</block>
</value>
</block>
</value>
</block>
</value>
<next>
<block type="update" id="}!6!8(47NX^9;U6C_G#a">
<mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation>
<field name="OID">0_userdata.0.Test.V1</field>
<field name="WITH_DELAY">FALSE</field>
<value name="VALUE">
<block type="variables_get" id="%ge_Q6+64-Xvb0u@}{Mb">
<field name="VAR" id="19e+]})FfXk}~`Wj.4bM">htmlString</field>
</block>
</value>
<next>
<block type="debug" id="+Po4LYz|l3-bP_*!uMLD" inline="true" disabled="true">
<field name="Severity">log</field>
<value name="TEXT">
<shadow type="text" id="upBA@|x/?+tqJ;{2_X^+">
<field name="TEXT">test</field>
</shadow>
<block type="variables_get" id="@Nvf(injXf$Yw_H/!rZO">
<field name="VAR" id="19e+]})FfXk}~`Wj.4bM">htmlString</field>
</block>
</value>
<next>
<block type="debug" id="PA/=R6e@4[]/tuW5m,I3" inline="true">
<field name="Severity">log</field>
<value name="TEXT">
<shadow type="text" id="[54tEV#3P+y$ZwK{^|g~">
<field name="TEXT">V1 aktualisiert</field>
</shadow>
</value>
</block>
</next>
</block>
</next>
</block>
</next>
</block>
</statement>
<statement name="ELSE">
<block type="debug" id="eG[!NGV)c1@lXqO0RRaA" inline="true">
<field name="Severity">warn</field>
<value name="TEXT">
<shadow type="text" id="e;9g?#xrOkVdJvU?OQWj">
<field name="TEXT">length of the price string does not fit</field>
</shadow>
</value>
</block>
</statement>
</block>
</next>
</block>
</next>
</block>
</next>
</block>
</next>
</block>
</next>
</block>
</statement>
</block>
</statement>
</block>
</next>
</block>
</statement>
</block>
</xml>
