20 Replies Latest reply on Oct 28, 2014 1:27 PM by pradeepgm

    What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?

    mathi

      Hi

       

      Jive version used: 7

       

      1. Jive cloud analytics data update

              - How often the data is getting updated into cloud analytics DB. Is it a configuration that can be defined custom based?

       

      2. I would like to understand the option or filter available for the REST API  defined in Using the V2 Jive Data Export Service (Analytics) to get the aggregated value.

              - Example,

              I would like to get the User login report https://api.jivesoftware.com/analytics/v1/export/activity/csv/user based on department from user profile information.

           

              I would like to get the report details as below:

       

       

      s.No
      Department
      User count
      1
      IT
      35
      2
      Sales
      60
      3
      Marketing
      45

       

       

              Is there any option or filter that i can use to get the aggregated value as described. when i use the API https://api.jivesoftware.com/analytics/v1/export/activity/csv/user, i could get the details about each login user as one record in the csv file.

       

      3. would like to understand if there is any updated API list available for JIve 7.Pradeep Kumar Josh Richau

       

      Thanks

      Mathi

        • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?

          1) Data is sent to the cloud analytics service continuously and is available for query via the API a few seconds after the event happens

           

          2)

          The Data Export API is currently only allowing you to pull the data and then aggregate it yourself. You didn't mention the time frame you desire for the above report (it will of course impact the results).

           

          So you basically use the endpoint you mention, provide a time frame (look at the before and after arguments) then use something like excel or a desktop BI tool to aggregate the results to count logins per user, or unique users as you have above.

           

          3) The doc you mention Using the V2 Jive Data Export Service (Analytics) has the latest API docs - we will keep that updated if we add to the API's available

            • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?
              pradeepgm

              Hi Josh Richau

               

              Does that means we can not generate (other than parse and make your count) below aggregate reports from Jive API?

               

              • Total content in an instance/space/group
              • Total users in a system
              • Top most content w.r.t views/follow/like etc
              • Top participant w.r.t content creation/contribution
              • Top spaces/group w.r.t followers/content/contribution etc
                • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?

                  You can figure out all of those based on the raw data, but if your question is whether there is a specific API that returns single aggregated numbers - correct. You have to get the raw data and do the proper calculations yourself. The Data Export API is designed as a self service tool to get the raw data - not as an all purpose BI tool that would offer a complete query language akin to SQL...

                  1 person found this helpful
                    • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?
                      pradeepgm

                      Thanks for your confirmation.

                       

                      Is there any plan to add these reports in future road map? Also what is the best practice to read this raw data, perform some calculation and have the aggregation reports available? Assume that the data volume is huge. Is there any best way to do it like offline batch process etc?

                       

                      We are also thinking of reading it directly from CMR DB since it is already available to some extend. Here comes an important question, what is Jive's stand on feeding data into CMR DB in case of cloud analytic enablement. Would you continue feed data into CMR database in future versions as well (on-premise instance)?

                        • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?

                          Couple answers:

                          First with respect to these reports:

                          • Total content in an instance/space/group - available at the group/space level, the places activity report CSV export from CMR also has some high level per group info
                          • Total users in a system - User Adoption in CMR does report on this
                          • Top most content w.r.t views/follow/like etc - there is a content leaderboard available that does much of this
                          • Top participant w.r.t content creation/contribution - there is a user leaderboard, we also recently added Top Users By {likes given, likes received, answers given, content created, content viewed} in our cloud version
                          • Top spaces/group w.r.t followers/content/contribution etc - Places Activity does this by views

                           

                          So we do have versions of what you are asking for out of the box - not sure if there are specific nuances that you are looking for

                           

                          As to your second question about best practices for grabbing the data, as you say it highly depends on data volume. For small amounts you can get a CSV export and use excel, for larger amounts a BI tool would make sense. The API is very easy to script so it is more a matter of deciding what your report building tool would be

                           

                          Finally as to the analytics DB - we intend to support it for on prem indefinitely. In hosted and cloud situations we may consider removing it in some future version but that is still years away and will come with notice (and likely even more maturity in what the cloud API can do)

                          1 person found this helpful
                            • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?
                              pradeepgm

                              Hi Josh Richau

                               

                              Thanks for your response.

                               

                              We export the list of users who viewed, liked, followed the particular content from local analytics CMR DB. (Even before the IM was introduced). We just need to export the user data with username, email, activity date and some other profile fields like departments, Job Title etc

                               

                              Example reports are here

                              • List of users who viewed a content
                              • List of users who liked the content
                              • List of users who following the content/places
                              • List of users shared, downloaded the attachment etc

                               

                              Post cloud analytics enablement we are planning to read it from cloud API. Here comes an interesting question from our technical team.

                               

                              • What is the advantage of reading it from cloud API over local CMR DB?
                              • Is there any performance impact if we read it from local CMR DB (through a DAO layer)?
                              • The cloud API response template has 60+ attributes and we feel that parsing and reading those data might be a time consuming process (indeed that's the reason we are thinking of DAO layer Vs API). Is there any way we can reduce the no of attributes for different content types? The parsing will be time consuming if the result size is more (though the no of result set can be controlled).
                      • Re: Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?
                        mathi

                        Hi Josh Richau,

                         

                        I have question related to the output fields for JSON output and CSV format output.  I am trying to get the following information,

                        Activity, User, User email, User department.  when I use the following end point I am getting the value as expected as a csv format.

                         

                        https://api.jivesoftware.com/analytics/v1/export/activity/csv/content?friendly=true&filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)&after=2014-03-21&fields=Action,Actor.Name,Actor.Email,Actor.Profile.Department   https://api.jivesoftware.com/analytics/v1/export/activity/csv/content?friendly=true&filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)&after=2014-03-21&fields=Action,Actor.Name,Actor.Email,Actor.Profile.Department&count=2

                         

                        example output :

                        Action,Actor.Name,Actor.Email,Actor.Profile.Department

                        ACTIVITY_VIEW_DOCUMENT,Pradeep Kumar G M,pradeep_gm@infosys.com,

                        ACTIVITY_VIEW_DOCUMENT,Pradeep Kumar G M,pradeep_gm@infosys.com,

                         

                         

                         

                         

                        I am trying to get the same output in the form of JSON  using the API  as below:

                         

                        https://api.jivesoftware.com/analytics/v1/export/activity?friendly=true&filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)&after=2014-03-21&fields=Action,Actor.Name,Actor.Email,Actor.Profile.Department&count=2

                         

                        the profile data is being null, the sample output as below:

                              

                        1. {
                        2.     "paging":
                        3.     {
                        4.         "next": "http://cloudalytics-api-phx.prod.jivehosted.com/analytics/export/activity?after=2014-03-21&startIndex=2&count=2&friendly=true&filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)&fields=Action,Actor.Name,Actor.Email,Actor.Profile.Department",
                        5.         "itemsPerPage": 2,
                        6.         "totalCount": 132,
                        7.         "currentPage": 1,
                        8.         "totalPages": 66
                        9.     },
                        10.     "list":
                        11.     [
                        12.         {
                        13.             "Action": "ACTIVITY_VIEW_DOCUMENT",
                        14.             "Actor":
                        15.             {
                        16.                "Profile":
                        17.                 {
                        18.                 },
                        19.                 "Name": "Pradeep Kumar G M",
                        20.                 "Email": "pradeep_gm@infosys.com"
                        21.             }
                        22.         },
                        23.         {
                        24.             "Action": "ACTIVITY_VIEW_DOCUMENT",
                        25.             "Actor":
                        26.             {
                        27.                 "Profile":
                        28.                 {
                        29.                 },
                        30.                 "Name": "Pradeep Kumar G M",
                        31.                 "Email": "pradeep_gm@infosys.com"
                        32.             }
                        33.         }
                        34.     ]
                        35. }

                             

                         

                        When I try to get all the fields without friendly=true option I could see the profile fields are getting as below:     

                         

                             

                        1. {
                        2.     "paging":
                        3.     {
                        4.         "next": "http://cloudalytics-api-phx.prod.jivehosted.com/analytics/export/activity?after=2014-03-21&startIndex=1&count=1&filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)",
                        5.         "itemsPerPage": 1,
                        6.         "totalCount": 132,
                        7.         "currentPage": 1,
                        8.         "totalPages": 132
                        9.     },
                        10.     "list":
                        11.     [
                        12.         {
                        13.             "name": "ACTIVITY_VIEW_DOCUMENT",
                        14.             "timestamp": 1410808229594,
                        15.             "seqId": 2473,
                        16.             "uuid": "f5373c91-3d0b-11e4-8cfd-0050568b33c7",
                        17.             "context":
                        18.             {
                        19.                 "service":
                        20.                 {
                        21.                     "jiveUrl": "https://jivedemo-infosystesting.jiveon.com",
                        22.                     "instanceType": "",
                        23.                     "serviceVersion": "8.0.0.0_8c3.1-20140911132753.fcfdf12.release_8c3",
                        24.                     "serviceName": "Jive SBS"
                        25.                 },
                        26.                 "jvm":
                        27.                 {
                        28.                     "jvmHome": "/usr/local/jive/applications/sbs/.",
                        29.                     "jvmIpAddr": "nic=eth1,mac=00:00:06:fb:03:f7,ip=10.165.85.32;nic=eth0,mac=00:00:06:fb:03:f6,ip=10.163.213.32",
                        30.                     "jvmHost": "thunder33745.m1phx1.jivehosted.com",
                        31.                     "jvmUid": "5e8ee250-3a29-11e4-8cfd-0050568b33c7"
                        32.                 },
                        33.                 "web":
                        34.                 {
                        35.                     "visible": "true",
                        36.                     "userAgent": "Mozilla/5.0 (Windows NT 6.1; rv:32.0) Gecko/20100101 Firefox/32.0",
                        37.                     "requestId": "f5018690-3d0b-11e4-8cfd-0050568b33c7",
                        38.                     "external": "false",
                        39.                     "userEmail": "pradeep_gm@infosys.com",
                        40.                     "userType": "REGULAR",
                        41.                     "valueCase": "ob",
                        42.                     "username": "pradeep_gm@infosys.com",
                        43.                     "anon": "false",
                        44.                     "sessionId": "db2df74f646381c0dbd26d66ebd93bde",
                        45.                     "userId": "2006",
                        46.                     "partner": "false",
                        47.                     "federated": "false",
                        48.                     "flowId": "f5018691-3d0b-11e4-8cfd-0050568b33c7"
                        49.                 }
                        50.             },
                        51.             "payload":
                        52.             {
                        53.             },
                        54.             "actorID": 2006,
                        55.             "actorType": 3,
                        56.             "activityType": "View",
                        57.             "actionObjectId": 1036,
                        58.             "actionObjectType": 102,
                        59.             "containerId": 1036,
                        60.             "containerType": 700,
                        61.             "activity":
                        62.             {
                        63.                 "actor":
                        64.                 {
                        65.                     "@class": ".Actor",
                        66.                     "objectType": "user",
                        67.                     "objectId": 2006,
                        68.                     "objectHash": "5b2cf265e10d898069d0f8fe13490f25004ecd02",
                        69.                     "isDataAvailable": true,
                        70.                     "extras":
                        71.                     {
                        72.                     },
                        73.                     "tags":
                        74.                     [
                        75.                     ],
                        76.                     "username": "pradeep_gm@infosys.com",
                        77.                     "name": "Pradeep Kumar G M",
                        78.                     "firstName": "Pradeep",
                        79.                     "lastName": "Kumar G M",
                        80.                     "email": "pradeep_gm@infosys.com",
                        81.                     "creationDate": 1383843939716,
                        82.                     "modificationDate": 1410806727581,
                        83.                     "profile":
                        84.                     {
                        85.                         "hasAvatar": "true"
                        86.                     },
                        87.                     "enabled": true,
                        88.                     "lastLoggedIn": 1410806727580,
                        89.                     "lastProfileUpdate": 1396500159096,
                        90.                     "type": "REGULAR",
                        91.                     "federated": false,
                        92.                     "visible": true,
                        93.                     "status": "registered",
                        94.                     "url": "https://jivedemo-infosystesting.jiveon.com/people/pradeep_gm%40infosys.com"
                        95.                 },
                        96.                 "action": "View",
                        97.                 "actionObject":
                        98.                 {
                        99.                     "@class": ".ActivityContent",
                        100.                     "objectType": "document",
                        101.                     "objectId": 1036,
                        102.                     "objectHash": "b12d431a30dafb39a688507656876a7dbd26db21",
                        103.                     "isDataAvailable": true,
                        104.                     "extras":
                        105.                     {
                        106.                     },
                        107.                     "tags":
                        108.                     [
                        109.                     ],
                        110.                     "subject": "Several additional Images to consider for Website inclusion (test)",
                        111.                     "creationDate": 1398433263859,
                        112.                     "modifiedDate": 1398433606526,
                        113.                     "author":
                        114.                     {
                        115.                         "@class": ".Actor",
                        116.                         "objectType": "user",
                        117.                         "objectId": 2023,
                        118.                         "isDataAvailable": false,
                        119.                         "extras":
                        120.                         {
                        121.                         },
                        122.                         "tags":
                        123.                         [
                        124.                         ],
                        125.                         "username": "richard_rashty@infosys.com",
                        126.                         "name": "Richard Rashty",
                        127.                         "firstName": "Richard",
                        128.                         "lastName": "Rashty",
                        129.                         "email": "richard_rashty@infosys.com",
                        130.                         "creationDate": 1392219234834,
                        131.                         "modificationDate": 1410788880868,
                        132.                         "profile":
                        133.                         {
                        134.                             "region": "USA",
                        135.                             "functionalDepartment": "Function",
                        136.                             "biography": "Just a human in a digital petri dish",
                        137.                             "country": "USA",
                        138.                             "hasProfileImage": "true",
                        139.                             "title": "Helper of Disengaged",
                        140.                             "organization": "Infosys",
                        141.                             "qualification": "alive",
                        142.                             "company": "Infosys",
                        143.                             "hasAvatar": "true",
                        144.                             "language": "english",
                        145.                             "marketplace": "Marketplace",
                        146.                             "oracleBudgetCode": "12345",
                        147.                             "jobFunction": "consultant"
                        148.                         },
                        149.                         "enabled": true,
                        150.                         "lastLoggedIn": 1410788880868,
                        151.                         "lastProfileUpdate": 1392219872990,
                        152.                         "type": "REGULAR",
                        153.                         "federated": false,
                        154.                         "visible": true,
                        155.                         "status": "registered",
                        156.                         "url": "https://jivedemo-infosystesting.jiveon.com/people/richard_rashty%40infosys.com"
                        157.                     },
                        158.                     "containerId": 1036,
                        159.                     "containerType": "socialgroup",
                        160.                     "isVisibleToPartner": false,
                        161.                     "status": "PUBLISHED",
                        162.                     "versionId": 2,
                        163.                     "latestVersionAuthorId": 2023,
                        164.                     "url": "https://jivedemo-infosystesting.jiveon.com/docs/DOC-1036",
                        165.                     "fullPath": "/systemcontainer_17/socialgroup_1036",
                        166.                     "normalizedPath": "/socialgroup_1036",
                        167.                     "combinedObjectTypeId": "102_1036"
                        168.                 },
                        169.                 "activityTime": 1410808229594,
                        170.                 "destination":
                        171.                 {
                        172.                     "@class": ".ActivityDestination",
                        173.                     "objectType": "socialgroup",
                        174.                     "objectId": 1036,
                        175.                     "objectHash": "10473206b9811d4630e95e39126851b0b59d838c",
                        176.                     "isDataAvailable": true,
                        177.                     "extras":
                        178.                     {
                        179.                     },
                        180.                     "tags":
                        181.                     [
                        182.                     ],
                        183.                     "name": "Rashty Team Community",
                        184.                     "displayName": "rashty-team-community",
                        185.                     "description": " ",
                        186.                     "creationDate": 1398432305088,
                        187.                     "modificationDate": 1409330816928,
                        188.                     "url": "https://jivedemo-infosystesting.jiveon.com/groups/rashty-team-community",
                        189.                     "status": "ACTIVE",
                        190.                     "isVisibleToPartner": false,
                        191.                     "parentId": 17,
                        192.                     "parentType": "systemcontainer",
                        193.                     "fullPath": "/systemcontainer_17/socialgroup_1036",
                        194.                     "normalizedPath": "/socialgroup_1036",
                        195.                     "combinedObjectTypeId": "700_1036"
                        196.                 }
                        197.             },
                        198.             "isHistoricalReplay": false
                        199.         }
                        200.     ]
                        201. }

                         

                           

                         

                        How can I get the profile field by filtering it with the friendly option as true and only the selected fields/attributes to the activity object. Can you help me to understand the filter available for the JSON output end points.

                         

                        Thanks

                        Mathi

                         

                        CC Pradeep Kumar Deepa GS

                          • Re: Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?

                            There are some limitations but have you tried Actor.Profile.FunctionalDepartment for example or even Actor.Profile.*

                             

                            We have some enhancements in the pipe to make this work for CSV outside of the friendly=true fields but for JSON I think it works...

                              • Re: Re: Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?
                                mathi

                                Hi Josh Richau,

                                 

                                I have tested the API as you have suggested. I could see the details are coming up only for the Author of the content. for example: If I am checking the view activity for a document  ACTIVITY_VIEW_DOCUMENT, I could get the details for the author of the document. but not the user who viewed the document.

                                 

                                in the JSON output,

                                 

                                Activity.actor.profile does not have the department details.

                                Activity.ActionObject.author.profile has the department and other details displayed. I could filter based on the activity.actionObject.author.profile.* but not Activity.actor.profile.*

                                 

                                 

                                Can you please let me know how can I get the Actor profile for any activity.

                                 

                                https://api.jivesoftware.com/analytics/v1/export/activity?filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)&after=2014-03-21&count=2

                                 

                                 

                                •     "paging":
                                •     {
                                •         "next": "http://cloudalytics-api-phx.prod.jivehosted.com/analytics/export/activity?after=2014-03-21&startIndex=2&count=2&filter=action(ACTIVITY_VIEW_DOCUMENT,ACTIVITY_DOWNLOAD_DOCUMENT,ACTIVITY_FOLLOW_DOCUMENT,ACTIVITY_LIKE_DOCUMENT,ACTIVITY_BOOKMARK_DOCUMENT,ACTIVITY_SHARE_DOCUMENT,ACTIVITY_COMMENT_DOCUMENT)",
                                •         "itemsPerPage": 2,
                                •         "totalCount": 132,
                                •         "currentPage": 1,
                                •         "totalPages": 66
                                •     },
                                •     "list":
                                •     [
                                •         {
                                •             "name": "ACTIVITY_VIEW_DOCUMENT",
                                •             "timestamp": 1410808229594,
                                •             "seqId": 2473,
                                •             "uuid": "f5373c91-3d0b-11e4-8cfd-0050568b33c7",
                                •             "context":
                                •             {
                                •                 "service":
                                •                 {
                                •                     "jiveUrl": "https://jivedemo-infosystesting.jiveon.com",
                                •                     "instanceType": "",
                                •                     "serviceVersion": "8.0.0.0_8c3.1-20140911132753.fcfdf12.release_8c3",
                                •                     "serviceName": "Jive SBS"
                                •                 },
                                •                 "jvm":
                                •                 {
                                •                     "jvmHome": "/usr/local/jive/applications/sbs/.",
                                •                     "jvmIpAddr": "nic=eth1,mac=00:00:06:fb:03:f7,ip=10.165.85.32;nic=eth0,mac=00:00:06:fb:03:f6,ip=10.163.213.32",
                                •                     "jvmHost": "thunder33745.m1phx1.jivehosted.com",
                                •                     "jvmUid": "5e8ee250-3a29-11e4-8cfd-0050568b33c7"
                                •                 },
                                •                 "web":
                                •                 {
                                •                     "visible": "true",
                                •                     "userAgent": "Mozilla/5.0 (Windows NT 6.1; rv:32.0) Gecko/20100101 Firefox/32.0",
                                •                     "requestId": "f5018690-3d0b-11e4-8cfd-0050568b33c7",
                                •                     "external": "false",
                                •                     "userEmail": "pradeep_gm@infosys.com",
                                •                     "userType": "REGULAR",
                                •                     "valueCase": "ob",
                                •                     "username": "pradeep_gm@infosys.com",
                                •                     "anon": "false",
                                •                     "sessionId": "db2df74f646381c0dbd26d66ebd93bde",
                                •                     "userId": "2006",
                                •                     "partner": "false",
                                •                     "federated": "false",
                                •                     "flowId": "f5018691-3d0b-11e4-8cfd-0050568b33c7"
                                •                 }
                                •             },
                                •             "payload":
                                •             {
                                •             },
                                •             "actorID": 2006,
                                •             "actorType": 3,
                                •             "activityType": "View",
                                •             "actionObjectId": 1036,
                                •             "actionObjectType": 102,
                                •             "containerId": 1036,
                                •             "containerType": 700,
                                •            "activity":
                                •             {
                                •                 "actor":
                                •                 {
                                •                     "@class": ".Actor",
                                •                     "objectType": "user",
                                •                     "objectId": 2006,
                                •                     "objectHash": "5b2cf265e10d898069d0f8fe13490f25004ecd02",
                                •                     "isDataAvailable": true,
                                •                     "extras":
                                •                     {
                                •                     },
                                •                     "tags":
                                •                     [
                                •                     ],
                                •                     "username": "pradeep_gm@infosys.com",
                                •                     "name": "Pradeep Kumar G M",
                                •                     "firstName": "Pradeep",
                                •                     "lastName": "Kumar G M",
                                •                     "email": "pradeep_gm@infosys.com",
                                •                     "creationDate": 1383843939716,
                                •                     "modificationDate": 1410806727581,
                                •                     "profile":
                                •                     {
                                •                         "hasAvatar": "true"
                                •                     },
                                •                     "enabled": true,
                                •                     "lastLoggedIn": 1410806727580,
                                •                     "lastProfileUpdate": 1396500159096,
                                •                     "type": "REGULAR",
                                •                     "federated": false,
                                •                     "visible": true,
                                •                     "status": "registered",
                                •                     "url": "https://jivedemo-infosystesting.jiveon.com/people/pradeep_gm%40infosys.com"
                                •                 },
                                •                 "action": "View",
                                •                 "actionObject":
                                •                 {
                                •                     "@class": ".ActivityContent",
                                •                     "objectType": "document",
                                •                     "objectId": 1036,
                                •                     "objectHash": "b12d431a30dafb39a688507656876a7dbd26db21",
                                •                     "isDataAvailable": true,
                                •                     "extras":
                                •                     {
                                •                     },
                                •                     "tags":
                                •                     [
                                •                     ],
                                •                     "subject": "Several additional Images to consider for Website inclusion (test)",
                                •                     "creationDate": 1398433263859,
                                •                     "modifiedDate": 1398433606526,
                                •                     "author":
                                •                     {
                                •                         "@class": ".Actor",
                                •                         "objectType": "user",
                                •                         "objectId": 2023,
                                •                         "isDataAvailable": false,
                                •                         "extras":
                                •                         {
                                •                         },
                                •                         "tags":
                                •                         [
                                •                         ],
                                •                         "username": "richard_rashty@infosys.com",
                                •                         "name": "Richard Rashty",
                                •                         "firstName": "Richard",
                                •                         "lastName": "Rashty",
                                •                         "email": "richard_rashty@infosys.com",
                                •                         "creationDate": 1392219234834,
                                •                         "modificationDate": 1410788880868,
                                •                         "profile":
                                •                         {
                                •                             "region": "USA",
                                •                             "functionalDepartment": "Function",
                                •                             "biography": "Just a human in a digital petri dish",
                                •                             "country": "USA",
                                •                             "hasProfileImage": "true",
                                •                             "title": "Helper of Disengaged",
                                •                             "organization": "Infosys",
                                •                             "qualification": "alive",
                                •                             "company": "Infosys",
                                •                             "hasAvatar": "true",
                                •                             "language": "english",
                                •                             "marketplace": "Marketplace",
                                •                             "oracleBudgetCode": "12345",
                                •                             "jobFunction": "consultant"
                                •                         },
                                •                         "enabled": true,
                                •                         "lastLoggedIn": 1410788880868,
                                •                         "lastProfileUpdate": 1392219872990,
                                •                         "type": "REGULAR",
                                •                         "federated": false,
                                •                         "visible": true,
                                •                         "status": "registered",
                                •                         "url": "https://jivedemo-infosystesting.jiveon.com/people/richard_rashty%40infosys.com"
                                •                     },
                                •                     "containerId": 1036,
                                •                     "containerType": "socialgroup",
                                •                     "isVisibleToPartner": false,
                                •                     "status": "PUBLISHED",
                                •                     "versionId": 2,
                                •                     "latestVersionAuthorId": 2023,
                                •                     "url": "https://jivedemo-infosystesting.jiveon.com/docs/DOC-1036",
                                •                     "fullPath": "/systemcontainer_17/socialgroup_1036",
                                •                     "normalizedPath": "/socialgroup_1036",
                                •                     "combinedObjectTypeId": "102_1036"
                                •                 },
                                •                 "activityTime": 1410808229594,
                                •                 "destination":
                                •                 {
                                •                     "@class": ".ActivityDestination",
                                •                     "objectType": "socialgroup",
                                •                     "objectId": 1036,
                                •                     "objectHash": "10473206b9811d4630e95e39126851b0b59d838c",
                                •                     "isDataAvailable": true,
                                •                     "extras":
                                •                     {
                                •                     },
                                •                     "tags":
                                •                     [
                                •                     ],
                                •                     "name": "Rashty Team Community",
                                •                     "displayName": "rashty-team-community",
                                •                     "description": " ",
                                •                     "creationDate": 1398432305088,
                                •                     "modificationDate": 1409330816928,
                                •                     "url": "https://jivedemo-infosystesting.jiveon.com/groups/rashty-team-community",
                                •                     "status": "ACTIVE",
                                •                     "isVisibleToPartner": false,
                                •                     "parentId": 17,
                                •                     "parentType": "systemcontainer",
                                •                     "fullPath": "/systemcontainer_17/socialgroup_1036",
                                •                     "normalizedPath": "/socialgroup_1036",
                                •                     "combinedObjectTypeId": "700_1036"
                                •                 }
                                •             },
                                •             "isHistoricalReplay": false
                                •         },
                                •         {
                                •             "name": "ACTIVITY_VIEW_DOCUMENT",
                                •             "timestamp": 1410808207982,
                                •             "seqId": 2472,
                                •             "uuid": "e855a8e0-3d0b-11e4-8cfd-0050568b33c7",
                                •             "context":
                                •             {
                                •                 "service":
                                •                 {
                                •                     "jiveUrl": "https://jivedemo-infosystesting.jiveon.com",
                                •                     "instanceType": "",
                                •                     "serviceVersion": "8.0.0.0_8c3.1-20140911132753.fcfdf12.release_8c3",
                                •                     "serviceName": "Jive SBS"
                                •                 },
                                •                 "jvm":
                                •                 {
                                •                     "jvmHome": "/usr/local/jive/applications/sbs/.",
                                •                     "jvmIpAddr": "nic=eth1,mac=00:00:06:fb:03:f7,ip=10.165.85.32;nic=eth0,mac=00:00:06:fb:03:f6,ip=10.163.213.32",
                                •                     "jvmHost": "thunder33745.m1phx1.jivehosted.com",
                                •                     "jvmUid": "5e8ee250-3a29-11e4-8cfd-0050568b33c7"
                                •                 },
                                •                 "web":
                                •                 {
                                •                     "visible": "true",
                                •                     "userAgent": "Mozilla/5.0 (Windows NT 6.1; rv:32.0) Gecko/20100101 Firefox/32.0",
                                •                     "requestId": "e78168f0-3d0b-11e4-8cfd-0050568b33c7",
                                •                     "external": "false",
                                •                     "userEmail": "pradeep_gm@infosys.com",
                                •                     "userType": "REGULAR",
                                •                     "valueCase": "ob",
                                •                     "username": "pradeep_gm@infosys.com",
                                •                     "anon": "false",
                                •                     "sessionId": "db2df74f646381c0dbd26d66ebd93bde",
                                •                     "userId": "2006",
                                •                     "partner": "false",
                                •                     "federated": "false",
                                •                     "flowId": "e78168f1-3d0b-11e4-8cfd-0050568b33c7"
                                •                 }
                                •             },
                                •             "payload":
                                •             {
                                •             },
                                •             "actorID": 2006,
                                •             "actorType": 3,
                                •             "activityType": "View",
                                •             "actionObjectId": 1052,
                                •             "actionObjectType": 102,
                                •             "containerId": 1044,
                                •             "containerType": 700,
                                •             "activity":
                                •             {
                                •                 "actor":
                                •                 {
                                •                     "@class": ".Actor",
                                •                     "objectType": "user",
                                •                     "objectId": 2006,
                                •                     "objectHash": "5b2cf265e10d898069d0f8fe13490f25004ecd02",
                                •                     "isDataAvailable": true,
                                •                     "extras":
                                •                     {
                                •                     },
                                •                     "tags":
                                •                     [
                                •                     ],
                                •                     "username": "pradeep_gm@infosys.com",
                                •                     "name": "Pradeep Kumar G M",
                                •                     "firstName": "Pradeep",
                                •                     "lastName": "Kumar G M",
                                •                     "email": "pradeep_gm@infosys.com",
                                •                     "creationDate": 1383843939716,
                                •                     "modificationDate": 1410806727581,
                                •                     "profile":
                                •                     {
                                •                         "hasAvatar": "true"
                                •                     },
                                •                     "enabled": true,
                                •                     "lastLoggedIn": 1410806727580,
                                •                     "lastProfileUpdate": 1396500159096,
                                •                     "type": "REGULAR",
                                •                     "federated": false,
                                •                     "visible": true,
                                •                     "status": "registered",
                                •                     "url": "https://jivedemo-infosystesting.jiveon.com/people/pradeep_gm%40infosys.com"
                                •                 },
                                •                 "action": "View",
                                •                 "actionObject":
                                •                 {
                                •                     "@class": ".ActivityContent",
                                •                     "objectType": "document",
                                •                     "objectId": 1052,
                                •                     "objectHash": "0f77cdf53fd543b57921743907afbe626a755fcd",
                                •                     "isDataAvailable": true,
                                •                     "extras":
                                •                     {
                                •                     },
                                •                     "tags":
                                •                     [
                                •                     ],
                                •                     "subject": "Document to verify the download data",
                                •                     "creationDate": 1409833182466,
                                •                     "modifiedDate": 1409833518616,
                                •                     "author":
                                •                     {
                                •                         "@class": ".Actor",
                                •                         "objectType": "user",
                                •                         "objectId": 2057,
                                •                         "isDataAvailable": false,
                                •                         "extras":
                                •                         {
                                •                         },
                                •                         "tags":
                                •                         [
                                •                         ],
                                •                         "username": "ganthimathi_p@infosys.com",
                                •                         "name": "Ganthimathi Periasamy",
                                •                         "firstName": "Ganthimathi",
                                •                         "lastName": "Periasamy",
                                •                         "email": "ganthimathi_p@infosys.com",
                                •                         "creationDate": 1403875372223,
                                •                         "modificationDate": 1410509213368,
                                •                         "profile":
                                •                         {
                                •                             "region": "India",
                                •                             "title": "PTL",
                                •                             "functionalDepartment": "Edge",
                                •                             "department": "Sales,Marketing",
                                •                             "company": "Infosys",
                                •                             "hasAvatar": "true",
                                •                             "language": "English",
                                •                             "country": "India"
                                •                         },
                                •                         "enabled": true,
                                •                         "lastLoggedIn": 1410509213368,
                                •                         "lastProfileUpdate": 1409594238587,
                                •                         "type": "REGULAR",
                                •                         "federated": false,
                                •                         "visible": true,
                                •                         "status": "registered",
                                •                         "url": "https://jivedemo-infosystesting.jiveon.com/people/ganthimathi_p%40infosys.com"
                                •                     },
                                •                     "containerId": 1044,
                                •                     "containerType": "socialgroup",
                                •                     "isVisibleToPartner": false,
                                •                     "status": "PUBLISHED",
                                •                     "versionId": 3,
                                •                     "latestVersionAuthorId": 2057,
                                •                     "url": "https://jivedemo-infosystesting.jiveon.com/docs/DOC-1052",
                                •                     "fullPath": "/systemcontainer_17/socialgroup_1044",
                                •                     "normalizedPath": "/socialgroup_1044",
                                •                     "combinedObjectTypeId": "102_1052"
                                •                 },
                                •                 "activityTime": 1410808207982,
                                •                 "destination":
                                •                 {
                                •                     "@class": ".ActivityDestination",
                                •                     "objectType": "socialgroup",
                                •                     "objectId": 1044,
                                •                     "objectHash": "2df8efdc24f5da4b795c410c4a39493730949da9",
                                •                     "isDataAvailable": true,
                                •                     "extras":
                                •                     {
                                •                     },
                                •                     "tags":
                                •                     [
                                •                     ],
                                •                     "name": "Jive Deal Room",
                                •                     "displayName": "jive-deal-room",
                                •                     "description": "Test group to implement Jive Deal Room functionality",
                                •                     "creationDate": 1409080142639,
                                •                     "modificationDate": 1410380297589,
                                •                     "url": "https://jivedemo-infosystesting.jiveon.com/groups/jive-deal-room",
                                •                     "status": "ACTIVE",
                                •                     "isVisibleToPartner": false,
                                •                     "parentId": 17,
                                •                     "parentType": "systemcontainer",
                                •                     "fullPath": "/systemcontainer_17/socialgroup_1044",
                                •                     "normalizedPath": "/socialgroup_1044",
                                •                     "combinedObjectTypeId": "700_1044"
                                •                 }
                                •             },
                                •             "isHistoricalReplay": false
                                •         }
                                •     ]
                                • }

                                 

                                 

                                Is there any filter option to get the actors profile field.

                                 

                                 

                                Thanks

                                Mathi.

                                 

                                 

                                 

                            • Re: What are the option or filter available  in Jive cloud analytics API to get the aggregated report details?
                              mathi

                              Hi Josh Richau,

                               

                              we would like to understand the option to get the data related to photo album plugin. can you please let us know if there is any option to get the details of activities involved on photo album plugin.

                               

                              Thanks

                              Mathi

                               

                              CC: Pradeep Kumar, Deepa GS