Query List results using the API

[gaudentic]

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.

[RBecker]

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.

[gaudentic]

What about via MySQL?

[RBecker]

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

[gaudentic]

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!