Hello Team,
Client is running below extraction via API. Client is not getting any result .Extraction is blank and even there is not notes file generated. Client s not made change to script. The only thing they did is change the RIC. RIC which you in this script is active. Not sure why client is not able to pull the data. appreciate your view and reply on the same.
Client DSS ID is 9008557
private static void ExtractMoneyMarket2Data(DataTable MMkt2exceldata)
{
try
{
#region Declare inputs
List<InstrumentIdentifier> identifiers2 = new List<InstrumentIdentifier>();
var identifiers = new[] {
new InstrumentIdentifier
{
IdentifierType = IdentifierType.Ric,
Identifier = "A+NBF10YF=FIMD"
}
};
foreach (DataRow row in MMkt2exceldata.Rows)
{
identifiers2.Add(
new InstrumentIdentifier
{
IdentifierType = IdentifierType.Ric,
Identifier = row[0].ToString()
}
);
identifiers = identifiers2.ToArray();
}
// Identify the desired output fields for Money MKT 2 Extraction.
var outputFields = new[] { "RIC", "Instrument ID", "Security Description", "Quote Date", "Benchmark Spread" };
var extractionsContext = ContextHelper.CreateExtractionsContext();
try
{
var extractionRequest = new IntradayPricingExtractionRequest
{
IdentifierList = SubjectIdentifierList.CreateInstrumentIdentifierList(identifiers, null, false),
ContentFieldNames = outputFields
};
#endregion
//try
//{
sessionId = extractionsContext.ClientSessionId;
var extraction = extractionsContext.ExtractWithNotes(extractionRequest);
var rcid = extractionsContext.Diagnostics.LastCall == null ? null : extractionsContext.Diagnostics.LastCall.RequestCorrelationId;
//udf1 = extractedRows.First();
var notes = extraction.Notes;
string strnotes = notes[0].ToString();
var extractedRows = extraction.Contents;
LogStatus("MoneyMarket2 count - " + extractedRows.Count);
LogStatus("MoneyMarket2 Session ID - " + sessionId.ToString());
LogStatus("MoneyMarket2 Correlation ID - " + rcid.ToString());
LogStatus("MoneyMarket2 Notes - " + strnotes);
#region Save File
string MMktcsvfilepath = strDirName + "\\" + WebApplication1.ApiSettings.Default.MoneyMKT2CSVFilePath;
if (File.Exists(MMktcsvfilepath))
{
using (TextWriter tw = new StreamWriter(MMktcsvfilepath))
{
tw.WriteLine(ApiUtility.ToCsvLine(extractedRows.First().DynamicProperties.Keys));
foreach (var row in extractedRows)
tw.WriteLine(ApiUtility.ToCsvLine(row.DynamicProperties.Values));
tw.Close();
}
}
else
{
File.Create(MMktcsvfilepath).Dispose();
using (TextWriter tw = new StreamWriter(MMktcsvfilepath))
{
tw.WriteLine(ApiUtility.ToCsvLine(extractedRows.First().DynamicProperties.Keys));
foreach (var row in extractedRows)
tw.WriteLine(ApiUtility.ToCsvLine(row.DynamicProperties.Values));
tw.Close();
}
}
}
catch (Exception ex)
{
var rcid = extractionsContext.Diagnostics.LastCall == null ? null : extractionsContext.Diagnostics.LastCall.RequestCorrelationId;
LogErrorID(ex, "ExtractMoneyMarket2Data", sessionId, rcid);
}
#endregion
}
catch (Exception ex)
{
LogError(ex, "ExtractMoneyMarket2Data", sessionId);
return;
}
}
