Patch io.redash.webhooks/event/jsonschema/1-0-0

[alexanderdean]

Based on changes from @arikfr noted here:

getredash/redash#1563 (comment)

[alexanderdean]

Pushing back...

[jbeemster]

Example events:

{
    "url_base": "",
    "event": "alert_state_change",
    "alert": {
        "state": "triggered",
        "query_id": 1,
        "name": "Manifest Count less than 4000",
        "rearm": 5,
        "updated_at": "2017-12-08T12:57:40.857855+00:00",
        "user_id": 3,
        "created_at": "2017-12-08T12:48:11.926306+00:00",
        "last_triggered_at": "2017-12-08T12:57:40.862476+00:00",
        "id": 1,
        "options": {
            "column": "count",
            "value": 4000,
            "op": "less than"
        }
    }
}

{
    "url_base": "",
    "event": "alert_state_change",
    "alert": {
        "state": "ok",
        "query_id": 1,
        "name": "Manifest Count less than 4000",
        "rearm": 5,
        "updated_at": "2017-12-08T12:58:25.057536+00:00",
        "user_id": 3,
        "created_at": "2017-12-08T12:48:11.926306+00:00",
        "last_triggered_at": "2017-12-08T12:58:25.064913+00:00",
        "id": 1,
        "options": {
            "column": "count",
            "value": 4000,
            "op": "greater than"
        }
    }
}

[jbeemster]

@alexanderdean 126cf57

Have tested this heavily using Redash and Snowplow Mini and this schema now validates all incoming data.

There are two hacks in it:

1. object_id is a string or an integer or a null
2. created_at is a string (cannot be formatted as date-time as input is not correct)

Should we make bug reports for these two or simply patch the schema as is?

[alexanderdean]

Thanks @jbeemster - patch is okay for 1, but for 2 let's talk to Arik and check his appetite to fix...