5 Replies Latest reply on Sep 5, 2014 6:16 AM by Ryan Rutan

Pull information from the Discussion Management page into an external database

asaboowala Aug 28, 2014 4:26 PM

Is it possible to pull data from the Admin Console -> Spaces -> Management -> Discussion Management page into an external database/application? I am trying to display the information as seen on the 'Discussion Management' page onto a Dashboard/Info Tracker and would like to know if I can access that data using an API or any other method? If yes, how do I get started with that? Any documentation?

In case you are wondering what information I am talking about, below you will find the screenshot.

Re: Pull information from the Discussion Management page into an external database

dirkpv Aug 29, 2014 8:36 AM (in response to asaboowala)

Abbas Saboowala
I wonder if this should be in the Jive Developers space. And we could add tags for REST API.
Like (0)

Actions
- Re: Pull information from the Discussion Management page into an external database
  
  asaboowala Aug 29, 2014 8:39 AM (in response to dirkpv)
  
  Moved to the Developer space! Also, added the tags.
  
  Like (1)
  
  Actions
Re: Pull information from the Discussion Management page into an external database

nilsheuer Aug 29, 2014 2:53 PM (in response to asaboowala)

Abbas,

yes this information is available via the Jive REST Api, specifially here: https://developers.jivesoftware.com/api/v3/cloud/rest/PlaceService.html#getContent(String, String, int, int, String, boolean)

Your request to get the discussions within a group or space would look like this:
https://your.jiveinstance.com/api/core/v3/places/{placeID}/contents?filter=type(discussion)

You will get back a paginated json array holding the discussions in your place
1 person found this helpful
Like (0)

Actions
- Re: Pull information from the Discussion Management page into an external database
  
  asaboowala Sep 4, 2014 11:01 AM (in response to nilsheuer)
  
  Nils Heuer: Is it possible to apply a filter to the query, so as to narrow it down to only pulling JSON objects of posts created/updated in the last 6 hours or so?
  
  The current query I run, "https://<Jive Instance Name>/api/core/v3/places/<Place ID>/contents?filter=type(post)" displays all the open posts in my space. However, I was hoping to narrow down this list to show the posts which were Created/Updated in the last 6 hours, thus applying a further filter with the logic, 'updated time >= Current Time - 6hrs'. Is that possible?
  
  Thank you.
  
  Like (0)
  
  Actions
  - Re: Pull information from the Discussion Management page into an external database
    
    Ryan Rutan Sep 5, 2014 6:16 AM (in response to asaboowala)
    
    The best I see with that service is to retrieve the list of contents using the filter for sorting by Create/Last Activity Date.
    
    If you sort using the appropriate filter, you should be able to iterate through the results and stop once the date falls out of your desired range.
    
    Another way to get at this information would be the Using the V2 Jive Data Export Service (Analytics) which has more of a temporal stream component to the data retrieval.
    
    Hope this helps.
    
    Like (0)
    
    Actions

Go to original post