@anonymous954782

Thank you for sharing. I can replicate the issue by changing the decimal symbol to ','.

A solution could be enclosing a string that has comma characters in double quotation marks.

Therefore, CSV content looks like this:

Instrument,CF_LAST
IBM.N,"138,32"

With this method, the data type of the CF_LAST is still a number.

InstrumentCF_LAST
IBM.N     138,32


System.Single

I have published EikonDataAPI 0.4.9 to fix this issue.

@anonymous954782

I can retrieve the data properly, as shown below. I am using EikonDataAPI -Version 0.4.8.

The last data was available on 2022-03-23.

You can use the GetTimeSeriesRaw or GetDataRow methods instead to verify retrieved data. Otherwise, you can also enable logging in the API. Please refer to the Logging section in the .NET Libraries for Eikon Data APIs Quick Start article.

Hi,

I am linking : ..../.nuget/packages/eikondataapi/0.4.8/lib/net5.0/EikonDataAPI.dll

I set the debugging level and called GetData and GetdataRaw. In both cases, it seems the data is fetched (s we can se ethe last price in the data that is received), but GetData seems to raise an unexpected exception.

GetDataRaw seems to be ok :

vs. the exception with GetData (despite the info being there) :

Any idea what could be wrong ?

Thanks

I am compiling to net 6.0 (and have an "open Micorsoft.Data.Analysis" statement at the top), if that info is of any use...

Here is the notebook view

@anonymous954782

That is strange. I can run it properly.

I am using VS 2022 with NET 6.0.

The raw response is:

"{"responses":[{"columnHeadersCount":1,"data":[["EUR=",1.0816]],"headerOrientation":"horizontal","headers":[[{"displayName":"Instrument"},{"displayName":"CF_LAST","field":"CF_LAST"}]],"rowHeadersCount":1,"totalColumnsCount":2,"totalRowsCount":2}]}"

Are you using these versions?

Hi,

I am using VS 2019 (but it shouldn't change anything since I tried the code both in Jupyter and in F# script interactive, which are both independent) and .net 6

There is a discrepancy for NewtonsoftJson

I have tried downgrading to 12.0.3, but to no effect.

Any chance I could send you the minimal F# project that doesn't work to see if it works on your end ?

There's little doubt the issue comes form the parsing of the request.

The data itself is indeed fetched, see for instance with python (same app key)

Hi,

I have found where the issue comes form.

In the EikonDataAPI, It comes from :
stringBuilder.AppendLine(string.Join(",", datum.Select((JValue value) => value.Value)));

in CreateCSVFromDataResponse(DataResponse response)

In particular, it comes form the call to String.Join, which apparently does not use the InvariantCulture, resulting in a change of format of numbers. See below for a concrete example :

The conversion results in having multiple commas in the string before Microsoft.Data.Analysis tries to load the csv string, see here :

As a result, it raises an exception.

Any chance to raise a ticket to update the code and ensure the code is added with something like :

open System.Globalization

String.Format(CultureInfo.InvariantCulture,"{0}", value.Value)

Meanwhile, using :

CultureInfo.CurrentCulture <- CultureInfo.InvariantCulture

works as a workaround... but it has to be added in all projects, which is less than ideal.

@Jirapongse, thanks for the API update !