3CX SQL API Documentation

Get WebAPI SQL from 3CX PostgreSQL table
https://{{3CXFQDN}}/webapi/{{AccessKey}}/query

{"query":"SELECT id_recording, cl_participants_id, recording_url, start_time, end_time, 
transcription, archived, archived_url, call_type FROM public.recordings;",
"count":"100"
}
Answer

{
    "result": [
        [
            "210",
            "3510",
            "102/[Tom Smith]_102-381629759788_20230327090407(4).wav",
            "3/27/2023 11:04:07 AM",
            "3/27/2023 11:04:10 AM",
            "",
            "False",
            "",
            "2"
        ]
    ]
}
Get WebAPI SQL from custom PostgreSQL table
https://{{3CXFQDN}}/webapi/{{AccessKey}}/query

{"query":"SELECT date, old_values, new_values, ext FROM public.operator_state_history;",
"count":"100",
"db_name":"user_state",
"login":"phonesystem",
"password":"TQtRD8i8yu"
}
Answer

{
    "result": [
        [
            "5/10/2023 6:25:23 PM",
            "start",
            "Available",
            "102"
        ]
    ]
}