Mqtt trigger with vera lock code

Configuration
1

I’m trying to trigger off a Vera published topic.

MQTTLens subscribe is: Vera/Events/Front Door Lock/#

Result:
{
“DeviceId”: 57,
“DeviceName”: “Front Door Lock”,
“DeviceType”: “urn:schemas-micasaverde-com:device:DoorLock:1”,
“Oldsl_UserCode”: "UserID=“2” UserName=“Code 2"”,
“RoomId”: 1,
“RoomName”: “House”,
“ServiceId”: “urn:micasaverde-com:serviceId:DoorLock1”,
“Time”: 1512091369,
“Variable”: “sl_UserCode”,
“sl_UserCode”: "UserID=“2” UserName=“Code 2"”
}

Automation code recently tested:
- action:
- data_template:
message: Welcome home
entity_id: media_player.chromecastaudio
service: tts.google_say
alias: Welcome Home
condition: []
id: ‘1510966088658’
trigger:
- payload: ‘Code 2’
platform: mqtt
topic: “Vera/Events/Front Door Lock/”

I’ve tried adding a # to the end of the topic and I’ve tried changing payload to "UserID=“2” UserName=“Code 2"”

What am I missing?

2

I think you need to create a mqtt sensor with a value_template to parse the json, since the payload is not a single value. Then you trigger off the sensor.