How to do scheduled extraction for every end of month?

prathyusha.pothana
prathyusha.pothana
in DSS

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>

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @prathyusha.pothana

    Thank you for reaching out to us.

    You can create it by using the DSS Web GUI.

    1689592095193.png

    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.

Answers

  • prathyusha.pothana
    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
    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.


Categories