How to choose which API "DEX2 CreateRData" or "EikonDesktopDataAPI CreateAdxRtList"
To get Data from Eikon
I'm using "EikonDesktopDataAPI CreateAdxRtList()" for
=RData("JP03420067=","MATUR_DATE","RTFEED:IDN")
I'm using "DEX2 CreateRData()" for
=RData("JP03420067=","EJV.C.MaturityDate",)
And I select which API to use with "Fileds Name " has contains ".".
Is there any one know better way How to select API for fiels?
AdfinX Real-time "EikonDesktopDataAPI CreateAdxRtList()" is used to access real-time data. You can verify fields of real-time data by using Eikon Quote. For example, MATUR_DATE is a field displayed when subscribing to JP03420067= via Eikon Quote.
Therefore, you can use CreateAdxRtList() to access the value of MATUR_DATE.
On the other hand, DEX2 is used to access fundamental data. Normally, Eikon Quote can't access fundamental data.
In conclusion, for all fields displayed in Eikon Quote, you can use CreateAdxRtList() to retrieve the data. For other fields (fundamental data), you need to use DEX2.
Is this the data you are looking for ?
I use "Data Item Browser" on Eikon to search for the field name. (see bottom right of the window)
I attach the sample code in this post. dex2adcsamplecsharp.zip
Please note that you cannot use Eikon Desktop Data API in App Studio .NET SDK project. However, you can use App Studio WEB SDK to retrieve the same data as mentioned by Zhenya Kovalyov at https://community.developers.refinitiv.com/questions/8206/how-to-get-data-like-ejv-fileds.html#answer-8207
I tested the App Studio WEB SDK with this request:
var request = {
"instruments":"JP03420067=",
"fields":"TR.FIMaturityDate"
};
JET.Data("datagrid").then(function (service) {
service.request(request).then(function (result) {
console.log(result);
}, function (err) { console.log(err); });
});
And this is the result I received:
{"columnHeadersCount":0,"data":[["2026-03-20"]],"rowHeadersCount":0,"totalColumnsCount":1,"totalRowsCount":1}