Name of affected component: Core Reporting API
Issue summary:
I've been pulling the same report via the spreadsheet API for a couple of
months, for several different views. All of them have their own spreadsheet
(but they are all based on the same template). Since last month a couple of
them stopped behaving as they should, while others still work fine.
The following error shows up for each query: "Invalid value '#ERROR!'. Values
must match the following regular expression:
'[0-9]{4}-[0-9]{2}-[0-9]{2}|today|yesterday|[0-9]+(daysAgo)'"
This is obviously for the date parameter, however, the value there isn't
#ERROR!, but 1-1-2012 and 30-6-2015. This value is read from a configuration
tab within the spreadsheet. The same thing happens in other spreadsheets which
still work fine.
Steps to reproduce issue:
1. Create configuration tab with start date and end date
2. Update report configuration tab to read from this tab
3. Run the reports
Expected output:
To fetch the results
Actual results:
Errors
Notes:
Please note that this works fine for certain spreadsheets while it doesn't for
others, which really confuses me.
Screenshots in attachment.
Original issue reported on code.google.com by koen.spe...@gmail.com on 27 Jul 2015 at 9:04
Original issue reported on code.google.com by
koen.spe...@gmail.com
on 27 Jul 2015 at 9:04Attachments: