For a deeper look into our DataScope Select REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
Hi Team,
I am trying to do scheduled extraction for every month as part of it, I have created the instrument list and using ListID called 'InstrumentListAppendIdentifiers' and then called 'EndOfDayPricingReportTemplates' to get 'ReportTemplateId' and with 'ListId' and 'ReportTemplateId' called 'Schedules' to get scheduled extraction but didnt get desired results. Could you please provide us solution to get Scheduled extracts from DataScope.
Thanks,
Prathyusha.P
EMail: <Email>
Thank you for reaching out to us.
You can create it by using the DSS Web GUI.
With the DSS REST API, you need to send the HTTP POST message to the https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/Schedules. The body contains the following JSON message.
{
"Name": "<Schedule Name>",
"OutputFileName": "<Output File Name>",
"Recurrence": {
"@odata.type": "#DataScope.Select.Api.Extractions.Schedules.MonthlyRecurrence",
"MonthlyDay": 32
},
"Trigger": {
"@odata.type": "#DataScope.Select.Api.Extractions.Schedules.TimeTrigger",
"LimitReportToTodaysData": false,
"At": [
{
"Hour": 23,
"Minute": 59
}
]
},
"ListId": "<List Id>",
"ReportTemplateId": "<Report Teamplate Id>"
}
For more information, please refer to the DSS REST API Tutorials.
Hi Team,
I tried the above teamplate but did not get any extract file or data i just received the same payload back. WHat is the next step to receive the data?
POST https://selectapi.datascope.refinitiv.com/restapi/v1/Extractions/Schedules
{
"Name": "ORORA-EOMEXTRACTTest",
"TimeZone": "Central Standard Time",
"OutputFileName": "EOMExtrac.csv",
"Recurrence": {
"@odata.type": "#DataScope.Select.Api.Extractions.Schedules.MonthlyRecurrence",
"MonthlyDay": 32
},
"Trigger": {
"@odata.type": "#DataScope.Select.Api.Extractions.Schedules.TimeTrigger",
"LimitReportToTodaysData": false,
"At": [
{
"Hour": 16,
"Minute": 0
}
]
},
"ListId": "0x088dbaafd9a8f21b",
"ReportTemplateId": "0x088d95121e58f1e1"
}
That request schedules extractions that run at the end of each month. The next extraction will be executed at the end of this month (31 Jul 2023).
The scheduled extractions are used to schedule extractions that run on specific dates and times.
However, if you would like to get the data of the end of each month, such as 30 Jun 2023, I don't think the EndOfDayPricingReportTemplates support this because you can't specify a date in the report template. You can contact the Datascope Select support team via MyRefinitiv to confirm this.
