-
Re: Using the Jive API Explorer Data Export tool
ashleywolf Dec 1, 2015 6:57 PM (in response to lleboeuf)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:
-
Re: Using the Jive API Explorer Data Export tool
lleboeuf Dec 2, 2015 7:45 PM (in response to ashleywolf)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