@zohan.sim1

I have tested with the simple function with DSS API and it works fine.

I use the ElektronTimeseriesExtractionRequest.

            var extractionRequest = new ElektronTimeseriesExtractionRequest()
            {
                IdentifierList = new InstrumentIdentifierList()
                {
                    InstrumentIdentifiers = new[] { new InstrumentIdentifier { Identifier = "IBM.N", IdentifierType = IdentifierType.Ric } }
                },
                Condition = new ElektronTimeseriesCondition
                {
                    ReportDateRangeType = ReportDateRangeType.Range,
                    QueryStartDate = new DateTimeOffset(new DateTime(1990, 1, 1)),
                    QueryEndDate = new DateTimeOffset(new DateTime(2020, 9, 20)),
                    LastEntityOnly = false
                },
                ContentFieldNames = new[]{
            "Ask", "Bid", "High", "Last", "Low", "Trade Date"
                },
            };
            var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);
            var extractedRows = extractionResult.Contents;

Please share the code that you are using including the date range, content field names, and identifier list.

The Azure func app is set to run in interval says every 30 mins. Within 30 mins, we make price request in batches, so in average, we could be making 20-40 api calls in 30 mins window, to extract prices for our predefined set of tickers. The app calls the validate function first before calling eod extraction function.

The error appears intermittent, however it can be pretty bad during the day time, e.g happen in the whole 1 or 2 hours. Comparing errors at night, there are less of these errors comparing with the day time.

I was informed that Refinitiv have security in place to block TCP ports that are being reused too quickly.

So few questions:

1. In your code example, any way to set some kind of settings to ExtractionsContext, ExtractionsContext.ExtractWithNotes, in such away preventing the block? or any code advice in general?

2. can ExtractionsContext class (deriving from Refinitiv client dlls) work in cloud environment such as Azure function compatible? or we may need to use HttpClient for api calls ?

3. do you have Azure function in production environment? Any advice on what to set for the Premium plan environment to prevent this error?

-----------------------------------------

Here are the codes:

public List<string> ValidateTickers(List<string> tickers)

{

InstrumentIdentifier[] instrumentIdentifiers = PopulateInstrumentIdentifiers(tickers);

var validatedIdentifiers = _extractionsContext.InstrumentListOperations.ValidateIdentifiers(instrumentIdentifiers, true);

var validTickers = validatedIdentifiers.ValidatedInstruments.Select(x =>x.Identifier).ToList();

return validTickers;

}

public ExtractionResult CreateAndRunEodPricingExtraction( List<string> tickers, List<string> tickerFields)

{

_extractionType = ExtractionType.EndOfDay;

InstrumentIdentifier[] instrumentIdentifiers = PopulateInstrumentIdentifiers(tickers);

//Create an on demand extraction, of type EndOfDayPricingExtractionRequest:

EndOfDayPricingExtractionRequest extractionEod = new EndOfDayPricingExtractionRequest

{

IdentifierList = InstrumentIdentifierList.Create(instrumentIdentifiers),

ContentFieldNames = tickerFields.ToArray()

};

//Run the extraction.

return _extractionsContext.ExtractWithNotes(extractionEod);

}

NOTE:

_extractionsContext is a type of ExtractionsContext.