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

Question

question

Vinod A

36 ●4 ●6 ●10

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!

{ [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

> 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

Jun 21, 2021 at 04:54 PM

10 |1500

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

wasin.w Jul 06, 2021 at 03:36 AM

Hello @Vinod A

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,

AH

Jirapongse Jul 13, 2021 at 04:56 AM

@Vinod A

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Answer 1 · 2021-06-22T04:26:36Z

Jirapongse

79.1k ●250 ●52 ●74

@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

Jun 22, 2021 at 04:26 AM

10 |1500

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

Answer 2 · 2021-06-21T17:39:41Z

zoya faberov

32.2k ●40 ●11 ●20

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"
    ]
}

Jun 21, 2021 at 05:39 PM

10 |1500

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

Q&A Forum

question

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

2 Answers

Write an Answer

question

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

2 Answers

Write an Answer

Related Questions