Required valid request body for F&O search to filter by Strike(from value, to value) Maturity(fro...

jay416505

...m date,to date)

{
"SearchRequest": {
"FileCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"StrikePrice": {
"@odata.type": "#ThomsonReuters.Dss.Api.Search.NumericRangeComparison",
"From":2000,
"To": 2200
},
"ExpirationDate": {
"@odata.type": "#ThomsonReuters.Dss.Api.Search.DateValueComparison",
"ComparisonOperator": "GreaterThanEquals",
"Value": "2019-12-31"
},
"IdentifierType": "Ric",
"Identifier": "SPX*",
"PreferredIdentifierType": "Ric",
"UnderlyingRic": ".SPX"
}
}

veerapath.rungruengrayubkul

Hi @jay416505,

Below is the sample of specifying range of expiration date.

{
"SearchRequest": {
"FileCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"StrikePrice": {
"@odata.type": "#ThomsonReuters.Dss.Api.Search.NumericRangeComparison",
"From":2000,
"To": 2200
},
"ExpirationDate": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Search.DateRangeComparison",
        "From": "2019-12-31T00:00:00.000Z",
        "To": "2020-02-21T00:00:00.000Z"
    },
"IdentifierType": "Ric",
"Identifier": "SPX*",
"PreferredIdentifierType": "Ric",
"UnderlyingRic": ".SPX"
}
}

You can also use the REST API Reference Tree to help you create sample of request body. In the document, you configure the required parameters and then click "JSON Model" to generate JSON request body.

jay416505

https://community.developers.refinitiv.com/discussion/comment/55826#Comment_55826

In addition want filter by Put/Call and

AssetStatus=="Active"

How will request Body

veerapath.rungruengrayubkul

https://community.developers.refinitiv.com/discussion/comment/55828#Comment_55828

The parameters are "AssetStatus" and "PutCall" accordingly.

Below is the sample.

{
"SearchRequest": {
"FileCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"StrikePrice": {
"@odata.type": "#ThomsonReuters.Dss.Api.Search.NumericRangeComparison",
"From":2000,
"To": 2200
},
"ExpirationDate": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Search.DateRangeComparison",
        "From": "2019-12-31T00:00:00.000Z",
        "To": "2020-02-21T00:00:00.000Z"
    },
"IdentifierType": "Ric",
"Identifier": "SPX*",
"PreferredIdentifierType": "Ric",
"UnderlyingRic": ".SPX",
"AssetStatus": "Active",
"PutCall": "Call"
}
}