request.json

{
    "auth": "hash",
    "id": 1,
    "jsonrpc": "2.0",
    "method": "action.create",
    "params": {
        "def_longdata": "Trigger: {TRIGGER.NAME}\nTrigger status: {TRIGGER.STATUS}\nTrigger severity: {TRIGGER.SEVERITY}\nTrigger URL: {TRIGGER.URL}\n\nItem values:\n\n1. {ITEM.NAME1} ({HOST.NAME1}:{ITEM.KEY1}): {ITEM.VALUE1}\n2. {ITEM.NAME2} ({HOST.NAME2}:{ITEM.KEY2}): {ITEM.VALUE2}\n3. {ITEM.NAME3} ({HOST.NAME3}:{ITEM.KEY3}): {ITEM.VALUE3}\n\nOriginal event ID: {EVENT.ID}",
        "def_shortdata": "{TRIGGER.STATUS}: {TRIGGER.NAME}",
        "esc_period": 300,
        "eventsource": 0,
        "filter": {
            "conditions": [
                {
                    "conditiontype": 16,
                    "formulaid": "A",
                    "operator": 7,
                    "value": ""
                },
                {
                    "conditiontype": 5,
                    "formulaid": "B",
                    "operator": 0,
                    "value": "1"
                }
            ],
            "evaltype": 3,
            "formula": "A and B"
        },
        "name": "_UserSubscriptions_user",
        "operations": [
            {
                "esc_period": 0,
                "esc_step_from": 2,
                "esc_step_to": 2,
                "operationtype": 0,
                "opmessage": {
                    "default_msg": 1,
                    "mediatypeid": 0
                },
                "opmessage_usr": {
                    "userid": "100100000000059"
                }
            }
        ],
        "r_longdata": "Trigger: {TRIGGER.NAME}\nTrigger status: {TRIGGER.STATUS}\nTrigger severity: {TRIGGER.SEVERITY}\nTrigger URL: {TRIGGER.URL}\n\nItem values:\n\n1. {ITEM.NAME1} ({HOST.NAME1}:{ITEM.KEY1}): {ITEM.VALUE1}\n2. {ITEM.NAME2} ({HOST.NAME2}:{ITEM.KEY2}): {ITEM.VALUE2}\n3. {ITEM.NAME3} ({HOST.NAME3}:{ITEM.KEY3}): {ITEM.VALUE3}\n\nOriginal event ID: {EVENT.ID}",
        "r_shortdata": "Solved: {TRIGGER.STATUS}: {TRIGGER.NAME}",
        "recovery_msg": 1
    }
}

response.json

{
    "error": {
        "code": -32500,
        "data": "SQL statement execution has failed \"INSERT INTO opmessage_usr (operationid,userid,opmessage_usrid) VALUES ('200200000000022','1','100100000000169')\".",
        "message": "Application error."
    },
    "id": 1,
    "jsonrpc": "2.0"
}