C# RestAPI Create multiple securities request in one go

sandeep.kola

My RICS are available in a dynamic Array => string[] ArrRICS = RICs.Split('|');

==> usual code: manually if I create hardcoded each line as follows giving me output

InstrumentIdentifiers = new[]

{

InstrumentIdentifier.Create(IdentifierType.Ric, "IDFR0044="),

InstrumentIdentifier.Create(IdentifierType.Ric, "05968LAH5="),

InstrumentIdentifier.Create(IdentifierType.Ric, "IDFR0076="),

InstrumentIdentifier.Create(IdentifierType.Ric, "IDFR0077="),

InstrumentIdentifier.Create(IdentifierType.Ric, "IDFR0078="),

}

But this snippet to be replaced with a dynamic array ArrRICS[] to IdenterfierIntruments create highlighted in Bold <ArrayOfRics>

//***************************************************

var extractionRequest = new ElektronTimeseriesExtractionRequest()

{

IdentifierList = new InstrumentIdentifierList

{

InstrumentIdentifiers = new[]

{

InstrumentIdentifier.Create(IdentifierType.Ric, <ArrayOfRics>),

}

},

Condition = new ElektronTimeseriesCondition

{

ReportDateRangeType = ReportDateRangeType.Range,

QueryStartDate = new DateTimeOffset(new DateTime(sdate.Year, sdate.Month, sdate.Day)),

QueryEndDate = new DateTimeOffset(new DateTime(edate.Year, edate.Month, edate.Day)),

},

ContentFieldNames = new[]

{

"Ask", "Bid", "High", "Last", "Low", "Trade Date","Volume"}

};

var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);

var extractedRows = extractionResult.Contents;

veerapath.rungruengrayubkul

Hi @sandeep.kola,

There is no interface provided which can add array of RICs directly to Instrument List. You can use the following code which creates IdentifierList outside of the ExtractionRequest scope.

    var IdentifierListtemp = new InstrumentIdentifierList();
    String[] RICsArray = { "IDFR0044=", "05968LAH5=" , "IDFR0076=", "IDFR0077="};

    foreach (var ric in RICsArray)
    {
        IdentifierListtemp.InstrumentIdentifiers.Add(InstrumentIdentifier.Create(IdentifierType.Ric, ric));
    }

    var extractionRequest = new ElektronTimeseriesExtractionRequest
    {
        IdentifierList = IdentifierListtemp,
        Condition = new ElektronTimeseriesCondition
        {
            ReportDateRangeType = ReportDateRangeType.Range,
            QueryStartDate = new DateTimeOffset(new DateTime(sdate.Year, sdate.Month, sdate.Day)),
            QueryEndDate = new DateTimeOffset(new DateTime(sdate.Year, sdate.Month, sdate.Day)),
        },
        ContentFieldNames = new[]
        {
"Ask", "Bid", "High", "Last", "Low", "Trade Date","Volume"}
    };
    var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);
    var extractedRows = extractionResult.Contents;

Gurpreet

Hello @sandeep.kola It is not clear what you are asking here. If you want to create a list of RIC's from an array, then, can you not use the following:

string[] allRICS = RICs.Split('|')

foreach (var ric in allRICS)	{
  InstrumentIdentifier.Create(IdentifierType.Ric, ric),
}

sandeep.kola

https://community.developers.refinitiv.com/discussion/comment/51352#Comment_51352

Thanks Mate, unfortunately provided snippet won't work:( which I already tried

//************Code(Pls refer commented section under <HELP> )******************//

var extractionRequest = new ElektronTimeseriesExtractionRequest()

{IdentifierList = new InstrumentIdentifierList

{

//Required HELP to replace with appropriate code to pass multiple RICs from array, E.g. compiler wont allow foreach loop in the below section

InstrumentIdentifiers = new[]{InstrumentIdentifier.Create(IdentifierType.Ric, <ArrayOfRics>),

//End of HELP required

}},

Condition = new ElektronTimeseriesCondition

{ReportDateRangeType = ReportDateRangeType.Range,

QueryStartDate = new DateTimeOffset(new DateTime(sdate.Year, sdate.Month, sdate.Day)),

QueryEndDate = new DateTimeOffset(new DateTime(edate.Year, edate.Month, edate.Day)),},

ContentFieldNames = new[]

{"Ask", "Bid", "High", "Last", "Low", "Trade Date","Volume"}};

var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);

var extractedRows = extractionResult.Contents;

sandeep.kola

https://community.developers.refinitiv.com/discussion/comment/51352#Comment_51352

var extractionRequest = new ElektronTimeseriesExtractionRequest()
{IdentifierList = new InstrumentIdentifierList
{
//Required help to replace with appropriate code, E.g. compiler wont allow foreach loop in the below section
InstrumentIdentifiers = new[]{InstrumentIdentifier.Create(IdentifierType.Ric, ),
//End of help required
}},
Condition = new ElektronTimeseriesCondition
{ReportDateRangeType = ReportDateRangeType.Range,
QueryStartDate = new DateTimeOffset(new DateTime(sdate.Year, sdate.Month, sdate.Day)),
QueryEndDate = new DateTimeOffset(new DateTime(edate.Year, edate.Month, edate.Day)),},
ContentFieldNames = new[]
{"Ask", "Bid", "High", "Last", "Low", "Trade Date","Volume"}};
var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);
var extractedRows = extractionResult.Contents;