vicidial.org

Hello,

I'm an analyst in a debt collection company, and I have a couple of questions.

Here is a little of context: A partner does a report from Agent Time Detail and Export Calls Reports, he extracts this info manually from the Vicidial UI. I'm trying to automate this report, but i need to query this information using programming lenguage (I'm using Python). I think that I might only need to query the List results to do this aggregated info.

Is it possible to query the List of a campaign with API or SQL?

If so, what do I need to do it? what kind of user account should I ask for to the admin to do it?

I often think that the person in charge of Vicidial in my company does not know all this things, because he can´t query this info with SQL, so I can´t rely in him (all the info must be somewhere in the server right?). Thats why I'm asking in this forum.

You cannot query the entire list directly via the API, only single lead records. The API isn't meant for mass data export like this.

What about via MySQL?

Yes, if you have MySQL access, look at the 'vicidial_list' table. That should have what you need in it.

What do I need to have acces to the MySQL DB? I want to ask the manager so I can query the table with python. user, password, database, server name?

And also: can I query the "Agent Time Detail" and "Export Calls Reports" via MySQL?

Thanks!