DSS API question from client

Naveen.Stella

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;

}

}

Gurpreet

Hi @Naveen.Stella,

Please ask the client to download the C# sample application from the DSS website and try out working samples. The samples contain working code snippets which they can then integrate within their application. Here is a screenshot of the IntradayPricingExtractionRequest from the sample:

Naveen.Stella

Thanks sure.. but the question is there any issue in client script... Client is using it for long time suddenly its not fetching anything

Gurpreet

If the app was working earlier and suddenly stopped working, then we wouldn't be able to tell why. It is best to reach out to the DSS product team who can look at the server logs and provide guidance on what might be going wrong.