2 Replies Latest reply on Dec 2, 2015 7:45 PM by lleboeuf

Using the Jive API Explorer Data Export tool

lleboeuf Nov 30, 2015 5:23 PM

I am new to the API explorer and I have some questions. I am trying to export data from our cloud jive instance that pertains to any jive documents with a specific tag that have been viewed and/or downloaded. Is there a way to do this? I tried the activity_tag_document with the Action filter selected and activity_tag_document as my filter argument and the tag I was looking for, but it returned data that did not fit the filter, so I assume I am missing something. Is there any way to get this data out? I am not a JSON or REST expert, but I know a little. Any help would be appreciated.

Re: Using the Jive API Explorer Data Export tool

ashleywolf Dec 1, 2015 6:57 PM (in response to lleboeuf)
Luke LeBoeuf,

This is a messy work-around to avoid using command line:

Navigate to your browser.
Replace example.jiveon.com in https://example.jiveon.com/api/core/v3/contents?count=1&fields=content,tags,activity with your instance URL.
Enter the updated URL https://example.jiveon.com/api/core/v3/contents?count=1&fields=content,tags,activity in your browser. A page with JSON will be returned.
Copy the JSON content below the line throw 'allowIllegalResourceCall is false.';
Paste the result in a JSON to CSV converter like JSON to CSV
Export the CSV file.

Note: Jive's API will only return 100 items at a time. If you have over 100 pieces of content then you will have to copy+paste the JSON on each page. This will give you multiple CSV files to consolidate.
To get to the next page of content either change the count in the URL or look for the next page link in the JSON: next" : "https://example.jiveon.com/api/core/v3/places?

This should help you get you started but you will want to experiment with the the URL and pull different resources. You can refine the URL to only look for specific tags too.

Documentation:
Jive REST API v3.13 → Tag service
Jive REST API v3.13 → Document entity
Like (1)

Actions
- Re: Using the Jive API Explorer Data Export tool
  
  lleboeuf Dec 2, 2015 7:45 PM (in response to ashleywolf)
  
  Ashley Wolf,
  I cant thank you enough for your help. It returns a ton of valuable data. Is there any way to filter in or out? All I care about are GETs for any document with the tag "my_ip". Right now the query returns all content, tags, and activities. I want it to return all content containing one specific tag and the only activity I want are GETs or Views. Is there any way to do that?
  
  Luke
  
  Like (0)
  
  Actions

Go to original post