How to do scheduled extraction for every end of month?

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>

Find more posts tagged with

extraction

task-scheduler

#technology

Accepted answers

Jirapongse

@prathyusha.pothana

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.

All comments

Jirapongse

@prathyusha.pothana

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.

prathyusha.pothana

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"

}

Jirapongse

@prathyusha.pothana

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.

EXPLORE OUR SITES