---

BEGIN;

SELECT jsonb_pretty(
    ws.getdata(
        '{
            "RequestParams_Method":
                "integration.submit_unv_application_api",
            "request_id":
                "c541f781-8d43-4a67-9180-58b9633210e4",
            "id": 8264237,
            "contracts": [
                {
                    "contract_id": 13676962,
                    "periods": [2025],
                    "annual_deduction_flag": 0
                }
            ]
        }'
    )::jsonb
);



SELECT jsonb_pretty(
    integration.process_unv_notification_queue(
        1,
        'c541f781-8d43-4a67-9180-58b9633210e4'::uuid
    )
);





SELECT
    request_id,
    status,
    attempts,
    sent_at,
    last_error,
    body ->> 'uuid' AS notification_uuid
FROM report.unv_notification_queue
WHERE request_id =
    'c541f781-8d43-4a67-9180-58b9633210e4'::uuid;