question

Upvotes
Accepted
1 3 4 5

DSS Curl for 2 RICs - The value for one is in responseHeader whereas the other value for other is in responseLoad.

But when I try with 2 symbols it gives malformed results. The value ABRA.TA is in responseHeader whereas the other value for symbol VOD.L is in responseLoad. Do we know the reason:

{ "ExtractionRequest":{ "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest","ContentFieldNames":["Instrument ID","Open","High","Low","Last","Volume","Bid","Ask","Trade Date"],"IdentifierList":{ "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers":[{ "Identifier":"ABRA.TA","IdentifierType":"Ric"},{ "Identifier":"VOD.L","IdentifierType":"Ric"}]},"Condition":{ "ReportDateRangeType":"Range","QueryStartDate":"2021-06-16","QueryEndDate":"2021-06-16"}}}

Output JobId à "JobId":"0x0798ba575c8cc4e8"

Output – as you can see for first symbol the value is in responseHeader. Do you know why is that? Am I missing something in the request?

(`responseHeader`responseLoad)!(("HTTP/1.1 200 Connection established";"";"HTTP/1.1 200 OK";"Cache-Control: no-cache";"Pragma: no-cache";"Content-Length: 190";"Content-Type: text/plain";"Expires: -1";"Accept-Ranges: bytes";"Server: Microsoft-IIS/10.0";"X-Request-Execution-Correlation-Id: CiD/9015517/AAAAAA.0798f8af17ecc631/RA";"X-App-Id: Custom.RestApi";"X-App-Version: 14.5.72.64";"Date: Thu, 17 Jun 2021 19:53:59 GMT";"";"Instrument ID,Open,High,Low,Last,Volume,Bid,Ask,Trade Date";"ABRA.TA,402.8,405,397.2,403.4,348532,404.1,404.2,2021/06/16");"VOD.L,131.84,132.34,130.16,130.16,48953005,130.16,130.18,2021/06/16")



Here is the curl call

time:2021.06.18D21:55:36.340475000 tz:gmt logLevel:INFO messageType:Sending command: curl -s -i -v -X GET -x "http://35.56.104.42:8080" -H "Prefer: respond-async" -H "Content-Type: Accept-Encoding: gzip, deflate" -H "X-Dire

ct-Download: true" -H "Authorization: Token _NS2jybP3FylhQRPzmnpnTc_KHubnlGpQEr1Qibq7c_r67qivze6fs5b2PNb4Hezf3YSigLDtYLD8jyjj1IROkioj_HK1yf8-zrEW2eWq7n0GEf3

Tuihug6gli-Z7dGBHJ1WDFm_be44rpsqAtCwipVB-JgYa_rBp6nDcMN0mjH-UC4DcXnsJUivXkTqJjoRvBIk3y8xhp4cfX--8ziR-7KEH7a6B65_1zEhfZbs" "https://selectapi.datascope.refin

c81f')/%24value"

Here is the verbose output

* Trying 35.56.104.42:8080...

* Connected to 35.56.104.42 (35.56.104.42) port 8080 (#0)

* allocate connect buffer!

* Establish HTTP proxy tunnel to selectapi.datascope.refinitiv.com:443

> CONNECT selectapi.datascope.refinitiv.com:443 HTTP/1.1

> Host: selectapi.datascope.refinitiv.com:443

> User-Agent: curl/7.69.1

> Proxy-Connection: Keep-Alive

>

< HTTP/1.1 200 Connection established

<

* Proxy replied 200 to CONNECT request

* CONNECT phase completed!

* ALPN, offering http/1.1

* successfully set certificate verify locations:

* CAfile: /local/int/live/0/miniconda3/ssl/cacert.pem

CApath: none

} [5 bytes data]

* TLSv1.3 (OUT), TLS handshake, Client hello (1):

} [512 bytes data]

* CONNECT phase completed!

* CONNECT phase completed!

{ [5 bytes data]

* TLSv1.3 (IN), TLS handshake, Server hello (2):

{ [91 bytes data]

* TLSv1.2 (IN), TLS handshake, Certificate (11):

{ [4738 bytes data]

* TLSv1.2 (IN), TLS handshake, Server key exchange (12):

{ [333 bytes data]

* TLSv1.2 (IN), TLS handshake, Server finished (14):

{ [4 bytes data]

* TLSv1.2 (OUT), TLS handshake, Client key exchange (16):

} [70 bytes data]

* TLSv1.2 (OUT), TLS change cipher, Change cipher spec (1):

} [1 bytes data]

* TLSv1.2 (OUT), TLS handshake, Finished (20):

} [16 bytes data]

* TLSv1.2 (IN), TLS handshake, Finished (20):

{ [16 bytes data]

* SSL connection using TLSv1.2 / ECDHE-RSA-AES128-GCM-SHA256

* ALPN, server did not agree to a protocol

* Server certificate:

* subject: C=US; postalCode=10036; ST=New York; L=New York; street=3 Times Square; O=REFINITIV US LLC; CN=selectapi1.datascope.refinitiv.com

* start date: Feb 25 00:00:00 2021 GMT

* expire date: Feb 25 23:59:59 2022 GMT

* subjectAltName: host "selectapi.datascope.refinitiv.com" matched cert's "selectapi.datascope.refinitiv.com"

* issuer: C=GB; ST=Greater Manchester; L=Salford; O=COMODO CA Limited; CN=COMODO RSA Organization Validation Secure Server CA

* SSL certificate verify ok.

} [5 bytes data]

> GET /RestApi/v1/Extractions/RawExtractionResults('0x079950eba1acc81f')/%24value HTTP/1.1

> GET /RestApi/v1/Extractions/RawExtractionResults('0x079950eba1acc81f')/%24value HTTP/1.1

> Host: selectapi.datascope.refinitiv.com

> User-Agent: curl/7.69.1

> Accept: */*

> Prefer: respond-async

> Content-Type: Accept-Encoding: gzip, deflate

> X-Direct-Download: true

> Authorization: Token _NS2jybP3FylhQRPzmnpnTc_KHubnlGpQEr1Qibq7c_r67qivze6fs5b2PNb4Hezf3YSigLDtYLD8jyjj1IROkioj_HK1yf8-zrEW2eWq7n0GEf3ImrqQgEQ1S3zAemlhPwLnA-WuyHeRZLe0R8v8J1DXw_UOH1_BhGHpvQ9w7rhFaqxY2mvTuihug6gli-Z7dGBHJ1WDFm_be44rpsqAtCwipVB-JgYa_rBp6nDcMN0mjH-UC4DcXnsJUivXkTqJjoRvBIk3y8xhp4cfX--8ziR-7KEH7a6B65_1zEhfZbs

>

{ [5 bytes data]

* Mark bundle as not supporting multiuse

< HTTP/1.1 200 OK

< Cache-Control: no-cache

< Pragma: no-cache

< Content-Length: 180

< Content-Type: text/plain

< Expires: -1

< Accept-Ranges: bytes

< Server: Microsoft-IIS/10.0

< X-Request-Execution-Correlation-Id: CiD/9015517/AAAAAA.079950ec16acc81f/RA

< X-App-Id: Custom.RestApi

< X-App-Version: 14.5.72.64

< Date: Fri, 18 Jun 2021 21:55:46 GMT

<

{ [180 bytes data]

* Connection #0 to host 35.56.104.42 left intact

@vinod.amarnath

tick-history-rest-api
icon clock
10 |1500

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

Upvotes
Accepted
50k 125 44 62

@Vinod A

I couldn't see the following output when using the curl command. How does the client see this output?

(`responseHeader`responseLoad)!(("HTTP/1.1 200 Connection established";"";"HTTP/1.1 200 OK";"Cache-Control: no-cache";"Pragma: no-cache";"Content-Length: 190";"Content-Type: text/plain";"Expires: -1";"Accept-Ranges: bytes";"Server: Microsoft-IIS/10.0";"X-Request-Execution-Correlation-Id: CiD/9015517/AAAAAA.0798f8af17ecc631/RA";"X-App-Id: Custom.RestApi";"X-App-Version: 14.5.72.64";"Date: Thu, 17 Jun 2021 19:53:59 GMT";"";"Instrument ID,Open,High,Low,Last,Volume,Bid,Ask,Trade Date";"ABRA.TA,402.8,405,397.2,403.4,348532,404.1,404.2,2021/06/16");"VOD.L,131.84,132.34,130.16,130.16,48953005,130.16,130.18,2021/06/16") 

The following is an output from curl without -v option.

HTTP/1.1 200 OK
Cache-Control: no-cache
Pragma: no-cache
Content-Length: 190
Content-Type: text/plain
Expires: -1
Accept-Ranges: bytes
Server: Microsoft-IIS/10.0
BeginRequestTime: 04:25:02.5875592
BeginRequestDate: 2021-06-22
X-Request-Execution-Correlation-Id: CiD/9008895/AAAAAA.079a5ebcbc4ccff7/RA
X-App-Id: Custom.RestApi
X-App-Version: 15.0.155.64
CPUUtilization: 0.3260864
RequestsPerSec: 2.5014
W3WP-PrivateBytes: 1653804
Date: Tue, 22 Jun 2021 04:25:02 GMT


Instrument ID,Open,High,Low,Last,Volume,Bid,Ask,Trade Date
ABRA.TA,402.8,405,397.2,403.4,348532,404.1,404.2,2021/06/16
VOD.L,131.84,132.34,130.16,130.16,48953005,130.16,130.18,2021/06/16
icon clock
10 |1500

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

Upvotes
30.3k 34 11 17

Hello @Vinod A ,

I have just tested:

{ {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes

{ "ExtractionRequest":{ "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest","ContentFieldNames":["Instrument ID","Open","High","Low","Last","Volume","Bid","Ask","Trade Date"],"IdentifierList":{ "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers":[{ "Identifier":"ABRA.TA","IdentifierType":"Ric"},{ "Identifier":"VOD.L","IdentifierType":"Ric"}]},"Condition":{ "ReportDateRangeType":"Range","QueryStartDate":"2021-06-16","QueryEndDate":"2021-06-16"}}}

The result looks as expected, I do not seem to reproduce the issue? :

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "ABRA.TA",
            "Instrument ID": "ABRA.TA",
            "Open": 402.8,
            "High": 405,
            "Low": 397.2,
            "Last": 403.4,
            "Volume": 348532,
            "Bid": 404.1,
            "Ask": 404.2,
            "Trade Date": "2021-06-16"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "VOD.L",
            "Instrument ID": "VOD.L",
            "Open": 131.84,
            "High": 132.34,
            "Low": 130.16,
            "Last": 130.16,
            "Volume": 48953005,
            "Bid": 130.16,
            "Ask": 130.18,
            "Trade Date": "2021-06-16"
        }
    ],
    "Notes": [
        "Extraction Services Version 15.0.42358 (01a7f7ea050d), Built May 20 2021 18:23:40\r\nProcessing started at 06/21/2021 17:36:38.\r\nUser ID: 19945\r\nExtraction ID: 2000000273113469\r\nSchedule: 0x079a3b6881accf10 (ID = 0x0000000000000000)\r\nInput List (2 items):  (ID = 0x079a3b6881accf10) Created: 06/21/2021 17:36:38 Last Modified: 06/21/2021 17:36:38\r\nReport Template (15 fields): _OnD_0x079a3b6881accf10 (ID = 0x079a3b6881cccf10) Created: 06/21/2021 17:36:37 Last Modified: 06/21/2021 17:36:37\r\nSchedule dispatched via message queue (0x079a3b6881accf10)\r\nSchedule Time: 06/21/2021 17:36:37\r\nTimeseries Date Range: 06/16/2021 to 06/16/2021\r\nProcessing completed successfully at 06/21/2021 17:36:38, taking 0.325 Secs.\r\nExtraction finished at 06/21/2021 17:36:38 UTC, with servers: x06q20, ETS (0.2 secs), QSHC13 (0.0 secs), QSSHA1 (0.0 secs)\r\nQuota Message: INFO: Tick History Cash Quota Count Before Extraction: 632; Instruments Approved for Extraction: 2; Tick History Cash Quota Count After Extraction: 633, 63.3% of Limit; Tick History Cash Quota Limit: 1000\r\nWriting RIC maintenance report.\r\n",
        "Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\nABRA.TA,RIC,TLV,ABRA.TA,06/14/2021,SPLT,,,.985417,\r\n"
    ]
}
icon clock
10 |1500

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