Challenge Overview
In a Google App Engine application load the included JSON file. ����Parse this JSON into a Google a Google Spreadsheet.
Ability to choose the JSON file that you want to upload and the Google Spreadsheet ����that you would like to save it to. ����
This report is a simple contacts report generated from a Salesforce developer��������s account created at developer.force.com. ����All information within this file is created as default dev data within the dev environment. ����Instructions for this are listed below in the extra credit section.
The Assets section Includes:
- JSON export of contacts report
- Image of report inside Salesforce����
- An Excel version of the export file����
- A Google Spreadsheet that is the result of a manual upload of the exported data����
- JSON export of products report����
- A Google Spreadsheet that is the result of a manual upload of the exported data����
Technologies and Reference:
The exported reports above were quite simplistic please experiment with other reports within Salesforce and ensure the spreadsheet created with your solution matches as closely as possible to the reports generated in Salesforce.
If you do not have a Salesforce development account please see reference document. ����
Steps for creating a report and exporting it as JSON
- Inside your Salesforce developer��������s account go to reports. ����
- Create a new report you can select from a number of existing reports, you can also modify these reports. ����
- Save and Run
- Your report should have a report id after the last / in the url, you will need this later.
- Go to http://apigee.com/console/salesforce
- Choose to Authenticate via OAuth2 and follow prompts.����
- For the request URL choose GET and use the following URL: https://na14.salesforce.com/services/data/v29.0/analytics/reports/[report_id]?includeDetails=true
This should give you the JSON you need to process within your solution.����
See Salesforce��������s documentation on their Analytics REST API to see how this works and in the Understanding Analytics REST API Resources\Decode the fact map section you can see more information on how to parse complex matrix reports.