Hi Kassandra Rodriguez,
I had tried all sorts of things but in the end it was the firewall on our corporate network! We finally got it sorted though and I am working through the script to generate reports. I am having a bit of trouble with a couple lines of code - one is specifying the "where" filter variable and applying this in the 'generate reports module'
where_filter = '{"where":"CreationDate >= CURRENT_TIMESTAMP - INTERVAL \'1\' DAY"}'
survey.generate_report(template, where_filter, utc_offset, report_title)
The script runs but doesn't return any surveys. I have only succeeded when use 1=1 which returns all reports!
I tested the sql query:
which returned results but only when the sql format was set to standard from none.
Any thoughts?
Thanks,
Simon