Register
Submit a solution
The challenge is finished.

Challenge Overview

The application will extract one of four types of log files from Google (email log, audit log, activity & email clients) and download the files as a CSV. There is no UI��for the application; simply enter the URL��and it downloads the file.��
��
For example, an admin can request an export of audit activity from last 45 minutes or 2 days. A sample URL may look like to following to extract audit logs for the last 30 minutes (all intervals are in minutes):

�� �� http://myapp.herokuapp.com?report_type=auditlog&interval=30

To extract the email logs for the last 30 minutes for danv:

�� �� http://myapp.herokuapp.com?report_type=emaillog&interval=30&from=danv@gmail.com

Screenshots below include the mandatory required output fields in the CSV. Any additional fields exposed by the API should be included in the output as well.


User-added image

View full size image


User-added image

View full size image


User-added image

View full size image

Click show sample to view sample reports above in control panel. Some sample data also below for reference:
��
Activity Report sample:
date,num_accounts,count_1_day_actives,count_7_day_actives,count_14_day_actives,��
�� �� �� ��count_30_day_actives,count_30_day_idle,count_60_day_idle,count_90_day_idle��
��
20060801,46,34,38,41,44,2,1,0��
20060802,75,61,64,69,73,2,1,0��
20060803,78,65,68,73,76,2,1,1��
20060804,82,68,72,77,80,2,1,1��
��
Email Clients Report sample:
date,num_accounts,web_mail_count,num_accounts_accessed,pop_count��
20060801,46,8,12,4��
20060802,75,39,41,2��
20060803,78,13,18,9��
20060804,82,15,15,0��
��
Design your interface in such a way, the app can be invoked by making a HTTP url request that can include following parameters: report_type, interval, {report_params} where report_params can be params required to filter the report data for a specific report type. eg. sender or recipient or date for email log report.��
��
Must have 90%+ test coverage if a Force.com app.

Review style

Final Review

Community Review Board

Approval

User Sign-Off

ID: 30037118