Using the V2 Jive Data Export Service (Analytics)

Version 68

    NOTE: This is version 2 of the Analytics service. Anyone currently using Cloud Analytics can use this version. This version is also available for on-prem customers who have opted in to Cloud Analytics. For the previous version, refer to V1 Jive Data Export Service (Analytics).

     

     

    Have a question?

    Please ask it here: Developer

     

    What Is the Jive Data Export Service (DES)?

     

    Beginning with the Jive Cloud Fall (2013) release and Jive 7, you can provide access to the new analytics service: the Jive Data Export API. This service allows you to export analytics data from your Jive community.

     

    How Do I Get Access to the DES?

     

    If you have a third-party tool, or some other consumer for your analytics data, you can use the Jive UI to generate a client-specific ID and secret. The consumer would then use that client ID and secret to access your data in the Jive Data Export UI. We follow the OAuth 2 spec. http://tools.ietf.org/html/rfc6749#section-2.3.1.

     

    To create a new client ID and secret that enable access to your instance:

    1. When logged in to Jive as a full access administrator, click your avatar in the top right, and select Add-ons.
    2. From the Add-ons tab, select Analytics Services > New Client.
    3. Enter the Client name. Make sure you use a descriptive name that will help you remember the system it's being used for.
    4. Click Generate Client ID & Secret.
    5. Copy and paste the information to where you can find it when you need it.
    6. Use the Authorization key (which is valid for only 30 minutes) by making the following auth WS POST call. (Be sure this is a POST request; if you do a GET request, you will receive a 405 error. You can do a POST via the curl command as shown in the examples.)
      • https://<cloudanalytics_server_host>/analytics/v1/auth/login?clientId=<Client ID>&clientSecret=<Client Secret> and substituting:
        • cloudalytics_server_host with the host or port for the Jive Data Export server. Note: The cloud analytics server is api.jivesoftware.com for customers in our US datacenter and api-eu.jivesoftware.com for customers in our European datacenter.
        • Client ID and Client Secret from the previous steps.

    Note: Access can be revoked at any time using the Add-ons interface in your Jive instance.

     

    Simplest Way to Access the DES - Use the Script

    For those who are not familiar with REST clients, the easiest way to get data from the Jive DES is to use Dirk McNealy's nifty "simple query" which can be found here: Simple Script for Jive Data Export Service.

     

    Common Use Cases

     

    How many documents were created in the last week?

     

    In order to find out how many document were created in the last week, you need to make the GET /analytics/v2/export/activity/{period} request as shown in the "How Can I Use this Service?" section. In this case we'll use lastweek as the period. We'll also pass the Authorization Header in the request along with the appropriate filters. To get the Authorization header, you need to get the authorization key as shown in Step 1 of the "Show Me an Example!" section.

     

    To access the analytics data, you'll use something like the following request.

     

    /analytics/v2/export/activity/lastweek?filter=action(Create)&filter=match(activity.actionObject.objectType,document)
                           

     

     

     

    In order to find out the content related activities by certain users (E.g 3 users with email ids of rohit@xyzcompany.com,david@xyzcompany.com,mitul@xyzcompany.com) and get them in a CSV format, we need to make the following GET call:

     

    /analytics/v2/export/activity/csv/lastday?filter=match(activity.actor.email, rohit@xyzcompany.com,david@xyzcompany.com,mitul@xyzcompany.com)
                           

     

    Note that in this case we'll use lastday as the period and content as the category for the csv format.

     

    How many users logged in during the last hour?

     

    In order to find out how many users logged in, we need to query for the 'Login' action and need to make the following GET call:

     

    /analytics/v2/export/activity/lasthour?filter=action(Login)
                           

     

    Note that in this case we'll use lasthour as the period. Also the above query will return multiple results if the same user logged in multiple times in that period.

     

    How Can I Use this Service?

     

    Data Export Service UI

     

    Available at https://api.jivesoftware.com/analytics/explorer for our PHX data center and https://api-eu.jivesoftware.com/analytics/explorer for our AMS data center.

    This UI allows logging in with client Id and secret and helps you to see what filters are available and quickly get a CSV.

     

    REST Endpoints

     

    You can create queries using the methods specified below, along with the parameters outlined in the Query Parameters table. You can filter the data using the filters outlined in the Filters table. The main service base URL is api.jivesoftware.com, which you need when you're querying. Refer to the examples of queries at the bottom of this document in "Show Me an Example!" sections to see how it's used.

     

    Export Endpoints

     

    The following are methods used for interacting with the Jive Data Export API. The API produces either JSON or CSV. CSV includes headers as the first line.

     

    GET /analytics/v2/export/activity

    • Produces: JSON
    • Query parameters:
      • standard filter parameters (listed below)

     

    GET /analytics/v2/export/activity/{period}

    • Produces: JSON
    • period: lasthour, lastday, lastweek
    • Query parameters:
      • standard filter parameters (listed below)

     

    GET /analytics/v2/export/activity/csv

    • Produces: CSV
    • Query parameters:
      • standard filter parameters (listed below)

     

    GET /analytics/v2/export/activity/csv/{period}

    • Produces: CSV
    • period: lasthour, lastday, lastweek
    • Query parameters:
      • standard filter parameters (listed below)

     

     

    Query Parameters

     

    The API parameters are modeled after Jive's V3 API.

    Name

    Type

    Required

    Description

    filter

    Object[]

    false

    The filter criteria used to limit results. Zero or more filters may be specified.

    count

    Integer

    false

    The maximum number of items to be returned. The default is 50,000 when requesting CSV data and 100 when requesting JSON data. The value "all" can be used to get all items; when using "all", we recommend using the "before" and "after" parameters to narrow results.

    fields

    String

    false

    Comma-separated list of fields to be returned.

    after

    ISO-8601 Date

    false

    Earliest event to return. This parameter has millisecond precision. For example. 2015-03-24T23:59:59.999 is a valid input.

    before

    ISO-8601 Date

    false

    Latest event to return. This parameter has millisecond precision. For example. 2015-03-24T23:59:59.999 is a valid input.

    show-allBooleanfalseWhether to return all fields. Defaults to false. (New for V2!)
    additionalFieldsStringfalse

    CSV ONLY (New for V2!)

    Same as fields, except additional fields are added to the default header list instead of replacing it. Use fully-qualified JSON path.

    Refer to V2 Data Export Service CSV Output Fields for a list of default CSV output fields.


    Example: activity.actionObject.author.profile.region

     

    Complete cURL example:

      curl -XGET "https://api.jivesoftware.com/analytics/v2/export/activity?

           filter=match(activity.actionObject.isQuestion,true)&

           additionalFields=activity.actionObject.assumedResolved,activity.actionObject.questionStatus"

    timeZoneStringfalse

    CSV ONLY (New for V2!)

    For time fields, adjusts the (field).time and (field).date to be in the specified timezone. Time zones are full name according to the tz database (see http://en.wikipedia.org/wiki/List_of_tz_database_time_zones).

     

    NOTE: Don't forget to URL Encode special characters in those timezone names.
    Example: US%2FMountain

    friendlyn/an/aTHIS FIELD IS NO LONGER SUPPORTED.

     

     

    Filters

     

    The API supports the following filters for limiting results:

    Filter

    Params

    Example

    action

    One or more actions, separated by commas. (See sample JSON response below for action field.)

    filter=action(View,Create,Update)

    nameOne or more names, separated by commas. (See sample JSON response below for name field.)filter=name(ACTIVITY_CREATE_DOCUMENT)

    user

    One or more user search terms.  Compared against username (activity.actor.username in the JSON).

    filter=user(admin,Administrator)

    type

    One or more content search terms.  Compared against object's type (activity.actionObject.objectType in the JSON).

    filter=type(blogpost,document)

    place

    One or more destination search terms.  Compared against place name (activity.destination.name in the JSON).

    filter=place(Cloudalytics)

    match

    Field followed by one or more search terms.

    filter=match(activity.actionObject.objectType,Document,Blogpost)

    ltField followed by numeric value — returns events where field's value is less than requested value. (not to be used with timestamp. for less than a time, use before param)filter=lt(activity.actor.objectId,1002)
    gtField followed by numeric value — returns events where field's value is greater than requested value. (not to be used with timestamp, for greater than a time, use after param)filter=gt(timestamp,1403210186028)
    notNested filter — returns the inverse data set. (New for V2!)

    filter=not(type(document))

    filter=not(user(admin,Administrator))

    orNested filter -- returns a filter that is the logical or of the nested filtersfilter=or(type(document),user(admin))

     

    Extracted Data

     

    The Data Export API produces either JSON or CSV. The API produces analytics information in the form of a paged response. Information about the next and previous pages are returned as part of the response. When requesting JSON content, paging information is part of the JSON response (as shown below); when requesting CSV content, paging information is part of the "paging" response header. In the output, each event is contained within a list. Most events take some form of "<Actor> performed <activity type> on <direct object> (less commonly to/with indirect object) in <place>".

     

    The below example shows a JSON response that would be returned for the following request:

     

    SAMPLE REQUEST

    curl -i "api.jivesoftware.com/analytics/v2/export/activity?count=2&startIndex=2"
                                                      

     

    SAMPLE RESPONSE

    {
      "paging": {
          "next": "http://api.jivesoftware.com/analytics/v2/export/activity?startIndex=4&count=2",
          "previous": "http://api.jivesoftware.com/analytics/v2/export/activity?startIndex=0&count=2",
          "itemsPerPage": 2,
          "totalCount": 1968999,
          "currentPage": 2,
          "totalPages": 984500
      },
      "list": [
          {
              "name": "ACTIVITY_UNLIKE_MESSAGE",
              "timestamp": 1403210186028,
              "seqId": 64,
              "uuid": "3146c6c0-f7f1-11e3-afe1-7831c1d4a9b2",
              "context": {
                  "service": {
                      "jiveUrl": "http://my.website.com:8080",
                      "instanceType": "dev",
                      "serviceVersion": "8.0.0.0_8c3-Custom",
                      "serviceName": "Jive SBS"
                  },
                  "jvm": {
                      "jvmHome": "/Users/jane/workspace/jive/application/quickstart/.",
                      "jvmIpAddr": "nic=en0,mac=09:01:f1:f4:f9:0a,ip=fe80:0:0:0:5b31:c1ff:cdd4:a91a%4,ip=10.46.28.41;nic=lo0,ip=fe80:0:0:0:0:0:0:1%1",
                      "jvmHost": "lt-a10-122121",
                      "jvmUid": "c41e9280-f7eb-11e3-afe1-7831c1d4a91a"
                  },
                  "web": {
                      "visible": "true",
                      "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36",
                      "requestId": "3146e090-f7f1-11e3-afe1-7831c1d4a9b2",
                      "external": "false",
                      "userEmail": "joe@website.com",
                      "userType": "REGULAR",
                      "username": "joe",
                      "anon": "false",
                      "sessionId": "127603463049901c7cb65b183b54180e",
                      "userId": "2024",
                      "partner": "false",
                      "federated": "false",
                      "flowId": "3146ce091-f7f1-11e3-afe1-7831c1d4a9b2"
                  }
              },
              "payload": {},
              "actorID": 2024,
              "actorType": 3,
              "activityType": "Unlike",
              "actionObjectId": 1137,
              "actionObjectType": 2,
              "containerId": 1,
              "containerType": 2020,
              "activity": {
                  "actor": {
                      "@class": ".Actor",
                      "objectType": "user",
                      "objectId": 2024,
                      "objectHash": "67235110974b960d87c5aedd684d67ef6b62210f",
                      "isDataAvailable": true,
                      "extras": {},
                      "tags": [],
                      "username": "jane@website.com",
                      "name": "A A",
                      "firstName": "A",
                      "lastName": "A",
                      "email": "jane@website.com",
                      "creationDate": 1403105940151,
                      "modificationDate": 1403206390644,
                      "profile": {
                          "hasAvatar": "true"
                      },
                      "enabled": true,
                      "lastLoggedIn": 1403206390641,
                      "lastProfileUpdate": 1403105940151,
                      "type": "REGULAR",
                      "federated": false,
                      "visible": true,
                      "status": "registered",
                      "url": "http://my.website.com:8080/people/a%40a.com"
                  },
                  "action": "Unlike",
                  "actionObject": {
                      "@class": ".ActivityContent",
                      "objectType": "message",
                      "objectId": 1137,
                      "objectHash": "724e7d7f4f2c4196a3f493106d3b4e2740795130",
                      "isDataAvailable": true,
                      "extras": {},
                      "tags": [],
                      "subject": "Re: discussion 17",
                      "creationDate": 1403105823083,
                      "modifiedDate": 1403105823083,
                      "authorId": 1,
                      "containerId": 1,
                      "containerType": "usercontainer",
                      "isVisibleToPartner": false,
                      "status": "PUBLISHED",
                      "url": "http://my.website.com:8080/message/1137#1137",
                      "fullPath": "/community_1/usercontainer_1",
                      "normalizedPath": "/usercontainer_1",
                      "combinedObjectTypeId": "2_1137"
                  },
                  "activityTime": 1403210186028,
                  "destination": {
                      "@class": ".ActivityDestination",
                      "objectType": "usercontainer",
                      "objectId": 1,
                      "objectHash": "1246139873b8caa25ebd585c956cbe5126a3cdca",
                      "isDataAvailable": true,
                      "extras": {},
                      "tags": [],
                      "name": "Administrator",
                      "displayName": "admin",
                      "description": "Administrator",
                      "creationDate": 0,
                      "modificationDate": 0,
                      "url": "http://my.website.com:8080/people/admin",
                      "status": "ACTIVE",
                      "isVisibleToPartner": false,
                      "parentId": 1,
                      "parentType": "community",
                      "fullPath": "/community_1/usercontainer_1",
                      "normalizedPath": "/usercontainer_1",
                      "combinedObjectTypeId": "2020_1"
                  }
              },
              "isHistoricalReplay": false
          },
          {
              "name": "ACTIVITY_STATUSPOINTSMODIFIED_COMMUNITY",
              "timestamp": 1403208266865,
              "seqId": 63,
              "uuid": "ea331e10-fc4c-11e3-afe1-7831c1d4a91a",
              "context": {
                  "service": {
                      "jiveUrl": "http://my.website.com:8080",
                      "instanceType": "dev",
                      "serviceVersion": "8.0.0.0_8c3-Custom",
                      "serviceName": "Jive SBS"
                  },
                  "jvm": {
                      "jvmHome": "/Users/jane/workspace/jive/application/quickstart/.",
                      "jvmIpAddr": "nic=en0,mac=08:01:f1:f4:f9:0a,ip=fe80:0:0:0:7a31:c1ff:fed4:a91a%4,ip=10.46.28.41;nic=lo0,ip=fe80:0:0:0:0:0:0:1%1",
                      "jvmHost": "lt-a10-122121",
                      "jvmUid": "c21e1d80-f7eb-11e3-afe1-7831c1d4a91a"
                  }
              },
              "payload": {},
              "actorID": 1,
              "actorType": 3,
              "activityType": "StatusPointsModified",
              "actionObjectId": 1,
              "actionObjectType": 14,
              "activity": {
                  "actor": {
                      "@class": ".Actor",
                      "objectType": "user",
                      "objectId": 1,
                      "objectHash": "2c0a57f773e6c131879987209b4cc8538f239db3",
                      "isDataAvailable": true,
                      "extras": {
                          "pointTotal": 219
                      },
                      "tags": [],
                      "username": "admin",
                      "name": "Administrator",
                      "email": "ted@website.com",
                      "creationDate": 1397673380967,
                      "modificationDate": 1403194993660,
                      "profile": {
                          "hasAvatar": "true"
                      },
                      "enabled": true,
                      "lastLoggedIn": 1403194993657,
                      "lastProfileUpdate": 1397673380967,
                      "type": "REGULAR",
                      "federated": false,
                      "visible": true,
                      "status": "registered",
                      "url": "http://my.website.com:8080/people/admin"
                  },
                  "action": "StatusPointsModified",
                  "actionObject": {
                      "@class": ".ActivityDestination",
                      "objectType": "community",
                      "objectId": 1,
                      "objectHash": "136ad42047706a7e563197c4004668f1117bc7fa",
                      "isDataAvailable": true,
                      "extras": {
                          "pointTotal": 219
                      },
                      "tags": [],
                      "name": "Jive",
                      "displayName": "jive",
                      "description": " ",
                      "creationDate": 0,
                      "modificationDate": 1401289838558,
                      "url": "http://my.website.com:8080/",
                      "status": "ACTIVE",
                      "isVisibleToPartner": false,
                      "combinedObjectTypeId": "14_1"
                  },
                  "activityTime": 1403208266865
              },
              "isHistoricalReplay": false
          }
      ]
    }
                                                          

     

    Examples

     

    Basic Examples

     

    The following commands show examples of how you can get authorization and then query activity from the Data Export Service in the Jive Cloud.

     

    1. Get the authorization key:

    curl -XPOST -i  "https://api.jivesoftware.com/analytics/v1/auth/login?clientId=<clientId provided by admin>&clientSecret=<clientSecret provided by admin>"
                                                                              

     

    (NOTE that the authorization endpoint still uses the v1 endpoint.)

     

    2. Get all the activity in lastday and bring back all the fields:

    curl -XGET -H "Authorization: <Authorization>" "https://api.jivesoftware.com/analytics/v2/export/activity/lastday"
                                                                              

     

    3. Get all the activity in lastday with specific fields:

    curl -XGET -H "Authorization: <authorization>"
      "https://api.jivesoftware.com/analytics/v2/export/activity/lastday?fields=activity.action,activity.actor.url,activity.actor.email"
                                                                             

     

    4. Get the specific number of records back. The below example will return one record back:

    curl -XGET -H "Authorization: <authorization>" "https://api.jivesoftware.com/analytics/v2/export/activity/lastday?count=1" 
                                                                             

     

    5. Get a CSV containing one record of activity for that user.

    curl -i -XGET 'http://api.jivesoftware.com/analytics/v2/export/activity/csv?filter=user(bob)&count=1' 
                                                     

     

    It is particularly useful to use the "-i" parameter (to include protocol headers) when requesting CSV content because paging information is located within the "paging" header field.

     

    Examples Using Filters

     

    You can use the following examples to help you understand how you can filter your data.

     

    Get a specific content type:

    curl -XGET -H "Authorization: <authorization>" "https://api.jivesoftware.com/analytics/v2/export/activity/lastday?filter=action(Create)"
                                                                             

     

    Get a specific content type in a specific place for specific user:

    curl -XGET -H "Authorization: <authorization>"
      "https://api.jivesoftware.com/analytics/v2/export/activity/lastday?filter=action(Create)&filter=place(testgroup)&filter=user(testuser)" 
                        

     

    Example in the Jive Node SDK

     

    There is also an example in the Jive Node SDK. Once you follow the jive-sdk installation instructions, you can create the example using the "jive-sdk create example-analytics" command. Refer to Jive Developer Series - Exploring the Data Export API for a video tutorial.

     

    List of All Data Export Events

     

    The following is a list of all events that are serviced by the Data Export API. Note that the specific event names have the "ACTIVITY_" prefix.

     

    CategoryVariantsUnsupported EventsExampleNotes
    LOGINACTIVITY_LOGIN_USER
    LOGOUTACTIVITY_LOGOUT_USER
    CREATEANNOUNCEMENT, ATTACHMENT, BLOG, BLOGPOST,  COLLABORATION, COMMUNITY, DIRECTMESSAGE, DOCUMENT, EVENT, IDEA, MESSAGE, POLL, PROJECT, QUESTION, SOCIALGROUP, TAG, TASK, THREAD, USER, USERRELATIONSHIP, USERRELATIONSHIPLIST, VIDEO, WALLENTRY

    CAROUSELCONTAINER,GENERICCONTENT,

    NITROACTIVITY, REMOTEDOCUMENT, SLIDE,TILESTREAMENTRY,

    ACTIVITY_CREATE_DOCUMENT
    DELETEANNOUNCEMENT, ATTACHMENT, BLOG, BLOGPOST, COMMUNITY, DIRECTMESSAGE, DOCUMENT, EVENT, IDEA, MESSAGE, POLL, PROJECT, QUESTION, SOCIALGROUP, TAG, TASK, THREAD, USER, USERRELATIONSHIP, USERRELATIONSHIPLIST, VIDEO, WALLENTRY

    CAROUSELCONTAINER, GENERICCONTENT,

    REMOTEDOCUMENT, SLIDE, TILESTREAMENTRY,

    ACTIVITY_DELETE_DOCUMENT
    UNDELETEDOCUMENT

     

    ACTIVITY_UNDELETE_DOCUMENT

    VIEWBLOGPOST, COLLABORATION, COMMUNITY, DIRECTMESSAGE, DOCUMENT, EVENT, IDEA, POLL, PROJECT, SOCIALGROUP, THREAD, USER, VIDEO, WALLENTRY, TASK, ANNOUNCEMENTGENERICCONTENT, TILESTREAMENTRY, EXTERNALURLACTIVITY_VIEW_DOCUMENT

     

    UPDATEANNOUNCEMENT, BLOG, BLOGPOST, COLLABORATION, COMMUNITY, DIRECTMESSAGE, DOCUMENT, EVENT, IDEA, MESSAGE, POLL, PROJECT, SOCIALGROUP, TASK, USER, VIDEO, WALLENTRY, THREADTILESTREAMENTRY, PROFILEIMAGEACTIVITY_UPDATE_DOCUMENT

     

    COMMENTBLOGPOST, COMMENT, DIRECTMESSAGE, DOCUMENT, DOCUMENTBACKCHANNEL, DOCUMENTVERSION, EVENT, IDEA, POLL, SHARE, VIDEO, WALLENTRYEXTERNALURL, STREAMENTRY, TILESTREAMENTRY, REMOTEDOCUMENTACTIVITY_COMMENT_DOCUMENT
    COMMENTUPDATEBLOGPOST, COMMENT, DIRECTMESSAGE, DOCUMENT, DOCUMENTBACKCHANNEL, DOCUMENTVERSION, EVENT,  IDEA, POLL, SHARE,  VIDEO, WALLENTRYEXTERNALURL, STREAMENTRY, TILESTREAMENTRY, REMOTEDOCUMENTACTIVITY_COMMENTUPDATE_DOCUMENT
    UNCOMMENTBLOGPOST, COMMENT, DIRECTMESSAGE, DOCUMENT, DOCUMENTBACKCHANNEL, DOCUMENTVERSION, EVENT,  IDEA, POLL, SHARE,  VIDEO, WALLENTRYEXTERNALURL,STREAMENTRY, TILESTREAMENTRY,ACTIVITY_UNCOMMENT_DOCUMENT

    ADDATTACHMENT

    BLOGPOST,, DOCUMENT, EVENT, IDEA, MESSAGE, PROJECT, SOCIALGROUP, USER, VIDEO

    BRIDGEDCONTENTMESSAGE, EXTENSION,

    AVATAR,  PROFILEIMAGE, TILESTREAMENTRY,

    ATTACHMENT, COMMUNITY, SOCIALGROUP

    ACTIVITY_ADDATTACHMENT_DOCUMENT
    UPDATEATTACHMENTBLOGPOST, DOCUMENT, MESSAGEACTIVITY_UPDATEATTACHMENT_DOCUMENT
    DELETEATTACHMENTBLOGPOST, COMMUNITY, DOCUMENT, EVENT, IDEA, MESSAGE, PROJECT, SOCIALGROUP, USER

    ATTACHMENT, EXTENSION, PROFILEIMAGE,

    AVATAR, TILESTREAMENTRY,

    ACTIVITY_DELETEATTACHMENT_DOCUMENT
    DOWNLOADBINARYBODY, DOCUMENTACTIVITY_DOWNLOAD_DOCUMENT
    DOWNLOADATTACHMENTATTACHMENT, BLOGPOST, DOCUMENT, EVENT, IDEA, MESSAGE, PROJECT, SOCIALGROUP, TILESTREAMENTRY, VIDEOCOMMUNITYACTIVITY_DOWNLOADATTACHMENT_DOCUMENT
    FOLLOWBLOG, BLOGPOST, COLLABORATION, COMMUNITY, DIRECTMESSAGE, DOCUMENT, EVENT, EXTERNALURL, IDEA, MESSAGE, POLL, PROJECT,  SHARE, SOCIALGROUP,  TASK, THREAD,  USER, VIDEO, WALLENTRY

    DOCUMENTVERSION, ANNOUNCEMENT,

    EAEWELCOME,REMOTEDOCUMENT, REMOTEDOCUMENTSHELL, SOCIALNEWS,

    TILESTREAMENTRY,

    ACTIVITY_FOLLOW_DOCUMENT
    UNFOLLOWBLOG, BLOGPOST, COMMUNITY, DIRECTMESSAGE, DOCUMENT, EVENT, EXTERNALURL, IDEA, MESSAGE, POLL, PROJECT, SHARE, SOCIALGROUP, TASK,, USER, VIDEO, WALLENTRY, THREAD

    REMOTEDOCUMENTSHELL, TILESTREAMENTRY,

    ANNOUNCEMENT, COLLABORATION,

    DOCUMENTVERSION, REMOTEDOCUMENT,

    ACTIVITY_UNFOLLOW_DOCUMENT

     

    LIKEBLOGPOST, COMMENT, DOCUMENT, EVENT, EXTERNALURL, MESSAGE, POLL, STREAMENTRY, THREAD, TILESTREAMENTRY, VIDEO, WALLENTRY, WIKILINKREMOTEDOCUMENT,ACTIVITY_LIKE_DOCUMENT
    UNLIKEBLOGPOST, COMMENT, DOCUMENT, EVENT, EXTERNALURL, MESSAGE, POLL, STREAMENTRY, THREAD, IDEA, TILESTREAMENTRY, VIDEO, WALLENTRYACTIVITY_UNLIKE_DOCUMENT

     

    RATEBLOGPOST, DOCUMENT, EVENT, POLL, REMOTEDOCUMENT, THREAD, VIDEOACTIVITY_RATE_DOCUMENT
    VOTEIDEA, POLLACTIVITY_VOTE_IDEA
    BOOKMARKBLOGPOST, DOCUMENT, EVENT, EXTERNALURL, FAVORITE, IDEA, POLL, REMOTEDOCUMENT, THREAD, TILESTREAMENTRY, VIDEO, WALLENTRYACTIVITY_BOOKMARK_DOCUMENT
    UNBOOKMARKBLOGPOST, DOCUMENT, EVENT, EXTERNALURL, IDEA, POLL, THREAD, VIDEO, WALLENTRYFAVORITE, REMOTEDOCUMENTACTIVITY_UNBOOKMARK_DOCUMENT
    BOOKMARKUPDATEBLOGPOST, DOCUMENT, EVENT, EXTERNALURL, IDEA, POLL, THREAD, VIDEO, WALLENTRY

    REMOTEDOCUMENT

    TILESTREAMENTRY

    ACTIVITY_BOOKMARKUPDATE_DOCUMENT

     

    CREATEOUTCOMEBLOGPOST, COMMENT, DOCUMENT, MESSAGE, THREAD,TILESTREAMENTRYACTIVITY_CREATEOUTCOME_DOCUMENT
    UPDATEOUTCOMEBLOGPOST, COMMENT, DOCUMENT, MESSAGE, THREAD,TILESTREAMENTRYACTIVITY_UPDATEOUTCOME_DOCUMENT
    DELETEOUTCOMEBLOGPOST, COMMENT, DOCUMENT, MESSAGE, THREADTILESTREAMENTRYACTIVITY_DELETEOUTCOME_DOCUMENT
    ENDORSEUSERACTIVITY_ENDORSE
    ENDORSEMENTAPPROVALUSERACTIVITY_ENDORSEMENTAPPROVAL
    UNENDORSEUSERACTIVITY_UNENDORSE_USER
    MAINSEARCHACTIVITY_MAINSEARCH
    PEOPLE_SEARCHACTIVITY_PEOPLE_SEARCH
    CONTENT_OR_PLACES_SEARCHACTIVITY_CONTENT_OR_PLACES_SEARCH
    SPOTLIGHT_SEARCHACTIVITY_SPOTLIGHT_SEARCH
    APPROVEUSERRELATIONSHIPACTIVITY_APPROVE_USERRELATIONSHIP
    REJECTUSERRELATIONSHIPACTIVITY_REJECT_USERRELATIONSHIP
    AIDEDQUESTIONACTIVITY_AIDED_QUESTION
    RESOLVED_MESSAGEACTIVITY_RESOLVED_MESSAGEIn the JSON response, "activity.actor" contains the user who selected the message as correct; "activity.actionObject.author" contains the user who authored the correct message
    UNRESOLVEDQUESTIONACTIVITY_UNRESOLVED_QUESTION
    MENTIONANNOUNCEMENT, ATTACHMENT, BLOG, BLOGPOST, COLLABORATION, COMMUNITY, DOCUMENT, DOCUMENTVERSION, EVENT, EXTERNALURL, FAVORITE, IDEA, IMAGE, MESSAGE, POLL, PROJECT, SOCIALGROUP, TASK, THREAD,  USER, VIDEO, WALLENTRYTILESTREAMENTRY,ACTIVITY_MENTION_DOCUMENT
    MOVEBLOG, BLOGPOST, COMMUNITY, DOCUMENT, EVENT, IDEA, MESSAGE, POLL, PROJECT, QUESTION, THREAD, VIDEO, WALLENTRYTILESTREAMENTRYACTIVITY_MOVE_DOCUMENT
    TAGBLOGPOST, COMMUNITY, DOCUMENT, EVENT, EXTERNALURL, FAVORITE, IDEA,, POLL, PROJECT, SOCIALGROUP, TAG, TASK, THREAD, USER, VIDEO, WALLENTRYINTEGRATIONTEMPLATEACTIVITY_TAG_DOCUMENT
    UNTAGBLOGPOST, COMMUNITY, DOCUMENT, EVENT, EXTERNALURL, FAVORITE, IDEA, POLL, PROJECT, SOCIALGROUP, TAG, TASK, THREAD, USER, VIDEO, WALLENTRYINTEGRATIONTEMPLATEACTIVITY_UNTAG_DOCUMENT

     

    SHAREBLOGPOST, COMMUNITY, DOCUMENT, EVENT, EXTERNALURL, IDEA, OUTCOME, POLL, PROJECT,, SHARE, SOCIALGROUP, TASK, THREAD, USER, VIDEO, WALLENTRY

    GENERICCONTENT, REMOTEDOCUMENT,

    STREAMENTRY, TILESTREAMENTRY

    ACTIVITY_SHARE_DOCUMENT
    SEND_EMAILACTIVITY_SEND_EMAIL
    STATUSPOINTSMODIFIEDBLOG, COMMUNITY, PROJECT, SOCIALGROUP, USERCONTAINERSYSTEMCONTAINERACTIVITY_STATUSPOINTSMODIFIED_BLOGEvents corresponding to points awarded for participating or contributing in a place.

     

    List of All CSV Output Fields

     

    Refer to V2 Data Export Service CSV Output Fields for a list of default CSV output fields.