In a certain function, invokeURL is called to return all scheduled meetings in the current month. However it only returns meetings up to zoho.currenttime.
I've verified "start" and "monthend' variables return the expected values using our January data. However, the API call does not return meetings scheduled for future dates, and that is part of its designed function. Any idea?
Snippet below (this is the very start of the function). API call does return all past meetings accurately, but no future ones.
start = zoho.currentdate.toStartOfMonth().toDateTime().toString("yyyy-MM-dd'T'HH:mm:ss'-05:00'");
monthend = start.addMonth(1).toDateTime().toString("yyyy-MM-dd'T'HH:mm:ss'-05:00'");
info start;
info monthend;
EventsQuery = Map();
//query all events in this month for scheduled events
EventsQuery.put("select_query","SELECT Event_Title, Start_DateTime, End_DateTime, Google_ID, id FROM Events WHERE (Start_DateTime between '" + start + "' and '" + monthend + "') ORDER BY Start_DateTime ASC");
EventResp = invokeurl
[
type :POST
parameters:EventsQuery.toString()
connection:"xxxxxxxxxx"
];
info EventResp;
Many thanks in advance, everything looks right to my eyes.