smartthings | My SmartThings Projects | Automation library

For this problem, I test it in my side and also reproduce your situation. It seems there is bug of liquid template in APIM. After reproduce your problem, I test in another APIM but it doesn't show same problem, the liquid template works fine in that APIM. Then I test in multiple APIM(with same set-body policy and request body) and summarize the result as below:

According to many test and the test result above, I guess it may be some bug after upgrade APIM. And the bug may be related to location or pricing tier(I'm not sure) because I can't find any differences between these APIM except location and pricing tier. So I suggest you to do same job in another APIM(with different location and pricing tier), it will solve the problem temporarily.

===============================Update=============================

I did some further test and found a workaround for this problem. I found the problem was caused by the line {% assign device_events = body.eventData.events | Where: "eventType", "DEVICE_EVENT" %}. If we don't assign body.eventData.events to device_events, instead use body.eventData.events directly in for loop like {% JSONArrayFor event in body.eventData.events %}. Then the liquid template works fine.

So we can just remove the line of "assign" and do "where" condition in for loop. Please refer to my liquid template below:

If your changes are data changes that should correspond to code changes then you should follow the pattern that good database administrators have use for years.

Make the updates with code as an upgrade script checked into source. You should also make a downgrade script that undoes the changes and check it in.

If making the changes programmatically is a headache, then make the two files simply contain instructions on how to make the data changes. Include an upgrade and downgrade instruction file with each major release.

To build a block of bytes for transmitting, I recommend using the built-in ByteBuffer, which e.g. has helpers for 16-, 32-, and 64-bit integers in big- or little-endian.

You should then store the values as you use them, e.g.

Raspberry Pi support Python, C, C++, Java, Scratch, and Ruby by default.

pushing via Json depends on the DBDriver. node(js),python will push data via json. Java jdbc has its own protocols.

you can write code to push data into mysql.

In java you can use jdbc connection. and each of the language has connection tools which can connect to db.

`for Java - https://www.javatpoint.com/example-to-connect-to-the-mysql-database

In java, In you are looking for ready-made components you can use open-source like spring boot data or any other tools

for python - https://www.datacamp.com/community/tutorials/mysql-python
for ruby - http://zetcode.com/db/mysqlrubytutorial/ `

create db schema (i.e db tables) you use insert statement to push data into mysql table.

You have 2 options here:

1) use Groovy's spread operator to call the method on every element of the list:

Try this :

you should use AudioManager for sound , check the documentation

Not knowing what type previousMeterValue has, this answer is somewhat generic.

Groovy follows common operator precedence, i.e. != is evaluated before &&.
To show it explicitly, the full expression is the same as:

If you need to suppress the warning, effectively making that code statically checked, you can declare the data type of the incoming parameter explicitly.