DSS API

Gayathri

We have 2 requirements

Client is trying to extract their current DSS scheduled extraction via DSS API Below are the details for your reference

DSS User ID – 136343

"ListId": "0x03643947b1eee116"

"ReportTemplateId": "0x036a93420c204208"

"Name": "ExchangeRates_EUP_M",

"OutputFileName": "ExchangeRates_EUP_M"

We tried to fetch the data with the attached API call which is there in the notepad. However, we are getting the below error response ( 400 Bad request) when we make a API Call. We request you to provide a correct API call to get the extraction of their schedule. I am attaching their schedule screenshot for your refence. Please refer to the highlighted schedule in the screenshot

{

"error": {

"message": "Malformed request payload: Syntax error at Line 14, Char 2: expected '}' ]"

}

Requirement No 2.

POST - httpsselectapi.datascope.lse.txt

Client need to know how can they get oauth 2.0 credentials for their Cloud system integration. They need the below details

Client ID — a Service ID (public identifier for your app)
Client Secret — the secret/password for your Client ID

HTTP POST request to LSEG’s OAuth2 token endpoint, passing your client_id, client_secret, and grant_type=client_credentials

Exchange rate.png

Find more posts tagged with

dss

rdp

#technology

Accepted answers

wasin.w V3

Hello @Gayathri

I can help with the second question. I am assuming that the client wants to use the Service Account (client id and client secret) for the Data Platform (RDP) REST APIs. If so, the client should reach out to their LSEG account team or Sales representative to get the Service Account credential.

Note:

The Service Account is also called Version 2 Authentication.
The DSS API has its own credential, not the Service Account.

All comments

wasin.w V3

Hello @Gayathri

Note:

The Service Account is also called Version 2 Authentication.
The DSS API has its own credential, not the Service Account.

Jirapongse

@Gayathri

To create a new scheduled extraction, the endpoint is:

POST https://selectapi.datascope.lseg.com/RestApi/v1/Extractions/Schedules

The request message could look like this:

{

    "Name": "ExchangeRates_EUP_M",

    "OutputFileName": "ExchangeRates_EUP_M",

    "TimeZone": "Central Standard Time",

    "Recurrence": {

        "@odata.type": "#DataScope.Select.Api.Extractions.Schedules.WeeklyRecurrence",

        "Days": [

            "Monday",

            "Tuesday",

            "Wednesday",

            "Thursday",

            "Friday"

        ]

    },

    "Trigger": {

        "@odata.type": "#DataScope.Select.Api.Extractions.Schedules.TimeTrigger",

        "LimitReportToTodaysData": false,

        "At": [

            {

                "Hour": 16,

                "Minute": 0

            }

        ]

    },

    "ListId": "0x03643947b1eee116",

    "ReportTemplateId": "0x036a93420c204208"

}

For more information, please refer to the DSS EST API Reference Tree.

To download the extracted files from the scheduled extractions, please refer to this DSS REST API: Downloading Completed Extraction Files by a Schedule Name article.

Shashidhar

Thank you for your response. Could you please help us in confirming the below

In the API Call Hour time be shown as 16. Should not this be shown as 18 as the time trigger is shown as 18 in their schedule ?
IN the API call , we see Timezone : Central Standard Time. should this Time zone reflect as CET. Is that correct ?
Could you please help with the correct API call to fetch the Intraday data of the schedule created by client ?
Note : Client is trying to get DSS Intraday data for nearly 51 Instruments.

I am attaching an example file API call for your reference.

POST - Intraday.txt

Jirapongse

Yes, you can change the time in the request message.
I think CET is Central European Time. Please check this page.
There are two types of extractions in DSS REST API which are scheduled extractions and on-demand extractions. The POST - Intrady.txt is an on-demand extraction. The request message is correct. For more information, please refer to this tutorial.

Which extraction types (scheduled or on-demand) would the client like to use through the DSS REST API?

EXPLORE OUR SITES