My Oracle Support Banner

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

Last updated on APRIL 09, 2019

Applies to:

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


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

2)Pasted the below URL in the browser to get the response code<CLIENT_ID>&scope=engage&redirect_uri=

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= -d code=<RESPONSE_CODE>

4) Used Chrome plugin "Postman" to check the connectivity.Note, we tried using activityCreatedAtStart to fetch data from respective dates
Authorization:Bearer <ACCESS_TOKEN>

Note, the access_code expire after every 2 hours and hence the above generated code will not work.
SRM Doc followed:


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

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

In this Document

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