It appears that the Reporting API is returning invalid data for the last_login_date column in the Accounts Report.
Here's a line from the report generated n example account dumped last night (customer information redacted): 20090126,account_id,account_name,ACTIVE, 0,153617685,,,20080604,YYYYMMDD,20090124,given_name,surname,,,, 19691231 Note the last_login_date (10th column in the report) shows YYYYMMDD instead of a true date. This occurs on nearly every account in these reports. What's going on here? My company has 2 domains (over 60k accounts) using this API and we make determinations whether to remove accounts based in part on the last_login_date. This was nearly catastrophic. We remove accounts that haven't been logged into after x amount of days and since YYYYMMDD turns into 0000-00-00 when inserted into a MySQL database, this meant that we would have potentially removed all the accounts we control. That part isn't Google's problem and we will update our algorithm to address. But the larger question is why the report is generating bad information in the first place. This is clearly a problem with Google. I know this is primary a user to user message board, but I know that the folks at Google read this. We're starting the process to contact Google support, but I ask others out there whether they've had similar problems. And I would ask that Google make public any information they may have if there is a larger problem. Had I not noticed it this morning, all our accounts would be gone. Michael De Soto --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Apps APIs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-apps-apis?hl=en -~----------~----~----~----~------~----~------~--~---
