For a deeper look into our DataScope Select SOAP API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
21 0 0 2

Major USD conversions not found using RIC

Whenever i try to query USD to one of the major rates, I get an error message indicating identifier not found.

Heres a sample request:

POST /RestApi/v1/Extractions/ExtractRaw HTTP/1.1
Host: hosted.datascopeapi.reuters.com
Content-Type: application/json
odata: metadata
Authorization: Basic XXX==
User-Agent: PostmanRuntime/7.11.0
Accept: */*
Cache-Control: no-cache
Postman-Token: 11370f0a-4a59-4de9-a37e-e1ce89a6f7a9,26ee6e9b-f9a5-414b-ba05-4ae3fadaf602
Host: hosted.datascopeapi.reuters.com
cookie: BIGipServer~FIFTEEN~US2P-DSSAPI_80=rd15o00000000000000000000ffff0af37bcco80
accept-encoding: gzip, deflate
content-length: 532
Connection: keep-alive
cache-control: no-cache


{"ExtractionRequest":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest","ContentFieldNames":["Currency Code","Base Currency Code","Mid Price","Ask Price","Trade Date","Cross Scaling Factor"],"IdentifierList":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers":[
  {
    "Identifier": "USDJPY=E",
    "IdentifierType": "Ric",
    "UserDefinedIdentifier" : "USD To JPY Conversion"
  }
				]  
			}
    	}
    }

And the response:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
    "JobId": "0x06a7693a50909b31",
    "Notes": [
        "All identifiers were invalid.  No extraction performed."
    ],
    "IdentifierValidationErrors": [
        {
            "Identifier": {
                "@odata.type": "#ThomsonReuters.Dss.Api.Content.InstrumentIdentifier",
                "Identifier": "USDJPY=E",
                "IdentifierType": "Ric",
                "UserDefinedIdentifier": "USD To JPY Conversion",
                "Source": ""
            },
            "Message": "Not found"
        }
    ]
}

Any Idea why this happens? I use the same method for another 189 currency snaps without any issues.

dss-rest-apidatascope-selectdssrics
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
21 0 0 2

Thanks @veerapath.rungruengrayubkul. I got it to work by simply specifying the currency, ie: JPY= , MYR=

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
11.3k 25 8 13

Hi @kevineugeneong,

Can you try the <JPY=E> RIC for USD / JPY Spot Rate? The RIC format of FX spot can be different for USD.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea