{"action":"created","issue":{"url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/issues/177","repository_url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst","labels_url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/issues/177/labels{/name}","comments_url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/issues/177/comments","events_url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/issues/177/events","html_url":"https://github.com/randyzwitch/RSiteCatalyst/pull/177","id":174783529,"number":177,"title":"Get data from Data Warehouse","user":{"login":"dieguico","id":11636439,"avatar_url":"https://avatars.githubusercontent.com/u/11636439?v=3","gravatar_id":"","url":"https://api.github.com/users/dieguico","html_url":"https://github.com/dieguico","followers_url":"https://api.github.com/users/dieguico/followers","following_url":"https://api.github.com/users/dieguico/following{/other_user}","gists_url":"https://api.github.com/users/dieguico/gists{/gist_id}","starred_url":"https://api.github.com/users/dieguico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dieguico/subscriptions","organizations_url":"https://api.github.com/users/dieguico/orgs","repos_url":"https://api.github.com/users/dieguico/repos","events_url":"https://api.github.com/users/dieguico/events{/privacy}","received_events_url":"https://api.github.com/users/dieguico/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-09-02T15:15:33Z","updated_at":"2016-09-08T19:13:30Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/pulls/177","html_url":"https://github.com/randyzwitch/RSiteCatalyst/pull/177","diff_url":"https://github.com/randyzwitch/RSiteCatalyst/pull/177.diff","patch_url":"https://github.com/randyzwitch/RSiteCatalyst/pull/177.patch"},"body":"I've found in Adobe Analyics API documentation a way to get reports from the Data Warehouse [(here)](https://marketing.adobe.com/developer/documentation/data-warehouse/r-report-2).\r\n\r\nThis pull request propose the inclusion of a new ~~function~~ method `QueueDataWarehouse`, and the slight adaptation of `GetElements` and `GetMetrics` to obtain the elements and metrics available on Data Warehouse.\r\n\r\nThe data from Data Warehouse can be retrieved with `GetReport` (it'd be interesting to modify the function to paginate the report if it's bigger than 20MB), or sent to a FTP server."},"comment":{"url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/issues/comments/245707958","html_url":"https://github.com/randyzwitch/RSiteCatalyst/pull/177#issuecomment-245707958","issue_url":"https://api.github.com/repos/randyzwitch/RSiteCatalyst/issues/177","id":245707958,"user":{"login":"dieguico","id":11636439,"avatar_url":"https://avatars.githubusercontent.com/u/11636439?v=3","gravatar_id":"","url":"https://api.github.com/users/dieguico","html_url":"https://github.com/dieguico","followers_url":"https://api.github.com/users/dieguico/followers","following_url":"https://api.github.com/users/dieguico/following{/other_user}","gists_url":"https://api.github.com/users/dieguico/gists{/gist_id}","starred_url":"https://api.github.com/users/dieguico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dieguico/subscriptions","organizations_url":"https://api.github.com/users/dieguico/orgs","repos_url":"https://api.github.com/users/dieguico/repos","events_url":"https://api.github.com/users/dieguico/events{/privacy}","received_events_url":"https://api.github.com/users/dieguico/received_events","type":"User","site_admin":false},"created_at":"2016-09-08T19:13:30Z","updated_at":"2016-09-08T19:13:30Z","body":"Randy, I've fixed several \"minor\" things, and I've created test for GetElements and GetMetrics (using the new \"DataWarehouse\" option). However, it did not pass the test since needs your credentials.\r\n\r\n```\r\n0.48schecking tests ... ERROR\r\nRunning the tests in ‘tests/testthat-build.R’ failed.\r\nLast 13 lines of output:\r\n  \r\n  2. Error: Validate BuildRealTimeReportStructure using legacy credentials (@test-buildrealtimereportstructure.R#6) \r\n  Authentication failed due to errors\r\n  1: SCAuth(Sys.getenv(\"USER\", \"\"), Sys.getenv(\"SECRET\", \"\")) at testthat/test-buildrealtimereportstructure.R:6\r\n  2: stop(\"Authentication failed due to errors\")\r\n  \r\n  testthat results ================================================================\r\n  OK: 4 SKIPPED: 0 FAILED: 2\r\n  1. Error: Validate BuildClassificationValueSegment using legacy credentials (@test-buildclassificationvaluesegment.R#6) \r\n  2. Error: Validate BuildRealTimeReportStructure using legacy credentials (@test-buildrealtimereportstructure.R#6) \r\n  \r\n  Error: testthat unit tests failed\r\n  Execution halted\r\n```\r\n\r\nThere are easy requests that can be obtained from the DataWarehouse in minutes (usually). You can get them directly using the ReportGet function if they are smaller than 20MB (if they are bigger you'll need to modify the GetReport method to 'paginate' de report). However it'd be nice to test the FTP option as well. It worked to me but who knows :D\r\n\r\nPlease let me know if there's anything else I can do. :)"}}
{"actor":{"display_login":"dieguico"}}