Panko Service get_events function returning none

4 Apr 2024

      Hi Openstack Team,

I am using Panko for events retrieval, but I am getting None from the below
query.
My current SqlAlchemy version is 1.4.31. Could you please guide me in
retrieving the correct events from the database?

Output from the panko events api :-
{
    "message_id": "2b4d83b4-3e23-4326-bedb-557a405c16db",
    "event_type": "audit.http.response",
    "traits": [
        {
            "name": "action",
            "value": "None",
            "type": "string"
        },
        {
            "name": "eventTime",
            "value": "2024-03-27T03:59:52.192750",
            "type": "datetime"
        },
        {
            "name": "eventType",
            "value": "None",
            "type": "string"
        },
        {
            "name": "id",
            "value": "None",
            "type": "string"
        },
        {
            "name": "initiator_host_address",
            "value": "None",
            "type": "string"
        },
        {
            "name": "initiator_id",
            "value": "None",
            "type": "string"
        },
        {
            "name": "initiator_name",
            "value": "None",
            "type": "string"
        },
        {
            "name": "initiator_typeURI",
            "value": "None",
            "type": "string"
        },
        {
            "name": "observer_id",
            "value": "None",
            "type": "string"
        },
        {
            "name": "outcome",
            "value": "None",
            "type": "string"
        },
        {
            "name": "project_id",
            "value": "None",
            "type": "string"
        },
        {
            "name": "reason_code",
            "value": "None",
            "type": "string"
        },
        {
            "name": "requestPath",
            "value": "None",
            "type": "string"
        },
        {
            "name": "request_id",
            "value": "None",
            "type": "string"
        },
        {
            "name": "service",
            "value": "None",
            "type": "string"
        },
        {
            "name": "target_id",
            "value": "None",
            "type": "string"
        },
        {
            "name": "target_name",
            "value": "None",
            "type": "string"
        },
        {
            "name": "target_typeURI",
            "value": "None",
            "type": "string"
        },
        {
            "name": "typeURI",
            "value": "None",
            "type": "string"
        },
        {
            "name": "user_id",
            "value": "None",
            "type": "string"
        }
    ],
    "generated": "2024-03-27T03:59:52.693294",
    "raw": {}
}

Query Link :-
https://github.com/openstack/panko/blob/4d0c0d66da6833e5283d71fe5bdee9594e4b...

Thanks and Regards,
Sandesh Kulkarni