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.
View full size image
View full size image
View full size image
Must have 90%+ test coverage if a Force.com app.�� �� 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.
View full size image
View full size 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.��
��