My Oracle Support Banner

How To Fetch Current And Historical Data (Doc ID 2428270.1)

Last updated on AUGUST 01, 2018

Applies to:

Oracle Social Engagement and Monitoring Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

On : NA version, Service Exception Report

How to fetch current and historical data

We are trying to extract all engage module messages (historical and current) using SRM exposed REST API.
But getting only 30 messages.
"How to fetch as many current and historical data based on time parameter?
In other words,how to fetch say all messages (FB and twitter) from 01-JAN-18 to 01-JUL-18"

Following were the steps followed:
1)Created an application name under https://accounts.vitrue.com/#api_apps

2)Pasted the below URL in the browser to get the response code
https://gatekeeper.vitrue.com/oauth/authorize?client_id=<CLIENT_ID>&scope=engage&redirect_uri=https://accounts.vitrue.com&response_type=code

3) Used cURL to get the "access_token"
curl -X POST -d grant_type=authorization_code -d client_id=<CLIENT_ID> -d client_secret=<CLIENT_SECRET_ID> -d redirect_uri=https://accounts.vitrue.com -d code=<RESPONSE_CODE> https://gatekeeper.vitrue.com/oauth/token

4) Used Chrome plugin "Postman" to check the connectivity.Note, we tried using activityCreatedAtStart to fetch data from respective dates
GET https://public-api.vitrue.com/engage/v1/messages?bundleId=0000&activityCreatedAtStart=2018-06-01&activityCreatedAtEnd=2018-07-13
Authorization:Bearer <ACCESS_TOKEN>
Accept:application/json

Note, the access_code expire after every 2 hours and hence the above generated code will not work.
SRM Doc followed: https://docs.oracle.com/en/cloud/saas/social/cxsrr/op-engage-v1-messages-get.html
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.