Disable login page - I know I am stupid lol

[Scubadave112]

So I know how dangerous and dumb this request is but as of right now I don't have much of a choice.

I utilize the call center heavily and I need hourly reports for each day of the month so I can put that data into PowerBi. Mark has a member app called call center summary and it has all the raw data I need but the only way you can get hourly data is by generating a report for a single queue in a single 24 hour window.

URL Sample:

https://phones.google.com/app/call_center_summary/queue_summary.php?quick_select=3&interval=hour&call_center_queue_uuid=3384575d-e5ce-4607-b78a-d2e3795e700e&start_stamp_begin=2023-06-03+00%3A59&start_stamp_end=2023-06-03+23%3A59&type=csv

I have a script that takes a csv with about 50 URLs in column a and the respected file names in column b and will download and rename.

the problem I am facing is authentication...... I have the API module but I can't figure out how to use the key and it seems like it won't work because the API doesn't support these reports.....

I can't find anyway to do this using my browser so I am thinking if I can just bypass portal login for my public IP for just 30 minutes, I can run the script and get my files easily....

Any recommendations is greatly appreciated?

 

[Scubadave112]

I think I got a sloppy way of doing it. I just used curl and am using the session id from my browser, i just created an excel macro to write all the urls and tested a few random ones with success... now just need to make a simple script to run all the requests save them into a folder and then make a macro add a column to all the csv files with the date in it, almost there but sheesh this is annoyingly difficult

 

[Scubadave112]

So it turn out I was not asking chat gpt the right question. Once I asked it the right question…. Chatgpt wrote a bash to download all the summary files for all the given queues for each day in the given date range and then add a column to each csv with the related date, then I asked it to write a python script with the CSV module to merge all the CSVs into a single master csv and it worked

I then had it do the exact same thing for each agent for the agent summaries about 600 csv files over 30 day range for queue and agent summaries took less than an hour to run

chatgpt is freaking crazy awesome

 

[whut]

That is great that you got it to work for you! I do not know all the tables involved in fusion for this, but if you can write a sql query to accomplish this task it would be much more efficient than this amalgamation. If you have the correct sql you can run that with bash/shell script to output to csv ready for PowerBI to consume. Or a sql view to connect Power BI more directly and more efficiently.