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!

[williamconley]

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!

The vicidial_list table has the lead information, accumulated throughout the lifetime of the lead on the system. but the log tables (there are plenty) have the detail records of each individual call and other types of transactions. Search for tables with _log at the end (or _log_archive for older records).

In many cases you can add &DB=1 (or find it in the existing URL and add the "1") to get the sql queries used in each report. Note that there are a lot of security/access queries that will happen before the actual report queries. But if you're completely unsure you can access the code of the file in question and just dump the SQL to screen specifically in case they (somehow) managed to leave out the final actual queries from the DB output. Sometimes there are multiple queries as the data is taken from one table for a base and other tables for details or summaries. But it's all there in PHP. If you know any programming language (such as python), you should be able to decipher it and add an extra "echo" line for the sql query variable.