Case statements - Amazon IoT Core
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

Case statements

Case statements can be used for branching execution, like a switch statement.

Syntax:

CASE v WHEN t[1] THEN r[1] WHEN t[2] THEN r[2] ... WHEN t[n] THEN r[n] ELSE r[e] END

The expression v is evaluated and matched for equality against the t[i] value of each WHEN clause. If a match is found, the corresponding r[i] expression becomes the result of the CASE statement. The WHEN clauses are evaluated in order so that if there is more than one matching clause, the result of the first matching clause becomes the result of the CASE statement. If there are no matches, r[e] of the ELSE clause is the result. If there is no match and no ELSE clause, the result is Undefined.

CASE statements require at least one WHEN clause. An ELSE clause is optional.

For example:

Incoming payload published on topic topic/subtopic:

{ "color":"yellow" }

SQL statement:

SELECT CASE color WHEN 'green' THEN 'go' WHEN 'yellow' THEN 'caution' WHEN 'red' THEN 'stop' ELSE 'you are not at a stop light' END as instructions FROM 'topic/subtopic'

The resulting output payload would be:

{ "instructions":"caution" }
Note

If v is Undefined, the result of the case statement is Undefined.