question

Upvotes
Accepted
41 3 4 9

Providing Fids in TickHistoryRawExtractionRequest Rest Api resulting null

I am facing situation where when i provide certain combination of Fids it returning result as null without any data at all. I am using TickHistoryRawExtractionRequest Rest Api. I always want to extract previous day data.

Below is the combination of Fids i am providing:

requestBody = {
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{
                "Identifier": "STXEc1",
                "IdentifierType": "Ric"
            }]
        },
        "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2021-09-02T12:00:00.000Z",
            "QueryEndDate": "2021-09-02T12:10:00.000Z",
            "Fids": "6,22,25,30,31,77,178,183,184,1021,4465,11872,12770,14265,14266",
            "ExtractBy": "Ric",
            "SortBy": "SingleByRic",
            "DomainCode": "MarketPrice",
            "DisplaySourceRIC": "true"
        }
    }
}


Now for example when i try to use below combination of Fids in the same request, i am getting data:

requestBody = {
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{
                "Identifier": "STXEc1",
                "IdentifierType": "Ric"
            }]
        },
        "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2021-09-02T12:00:00.000Z",
            "QueryEndDate": "2021-09-02T12:10:00.000Z",
            "Fids": "22,30,25,31,14265,1021",
            "ExtractBy": "Ric",
            "SortBy": "SingleByRic",
            "DomainCode": "MarketPrice",
            "DisplaySourceRIC": "true"
        }
    }
}


I dont understand this issue. What is the problem with the combinatioin of Fids and why it has something to do output data ? I need to get data based on the combination of Fids which i need.


tick-history-rest-api
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
41 3 4 9

@Gurpreet Below is the condition i changed in the request and only added "FidListOperator": "OR"


requestBody = {
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{
                "Identifier": "STXEc1",
                "IdentifierType": "Ric"
            }]
        },
        "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ReportDateRangeType": "Range",
            "QueryStartDate":  yesterday_start_dt.strftime(format2),
            "QueryEndDate": yesterday_end_dt.strftime(format2),
            "Fids": "6,22,25,30,31,77,178,183,184,1021,4465,11872,12770,14265,14266",
            "ExtractBy": "Ric",
            "SortBy": "SingleByRic",
            "DomainCode": "MarketPrice",
            "DisplaySourceRIC": "true",
            "FidListOperator": "OR"
        }
    }
}
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
13k 32 12 18

Hi @rahul.deshmukh ,

You are not using the fids parameter correctly. It can only contain one FID which can be one of the following values as shown in the REST API help.


1630676662950.png


Either provide the enumerated string or a single FID number. It is not a comma separated list. I would recommend that you raise a content support ticket at my.refinitiv.com to understand how to use this field.


1630676662950.png (10.9 KiB)
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.

@Gurpreet i already raised ticket and got reply that in the condition i should use

"FidListOperator": "OR" that would list the data for any of the Fid updated from given Fids and its working for me..

Good to hear that. Can you post your working query for my reference. Thanks.
Click below to post an Idea Post Idea