Hello, I am trying to use the DataStream API to get sector name (ICSBN) and sedol code (SECD) for a list of mnemonics (example: B:ABI).

Even if these attributes do exists (I can clearly see them using DataStream) the API requests returns NA.

Can you help me to understand why does this happen and how to solve the problem?

Please find below a screenshot of my request and the related response (The SECD for B:ABI is BYYHL23).

In addition, according to the answer to this question https://community.developers.refinitiv.com/questions/72952/datastream-api-datatypes.html

I should be able to obtain the same results using both the API and the Excel Add-in. Unfortunately though, I get different results.

This is what I get if I ask for SECD using the Excel add-in.

TypeSEDOL CODEB:ABIBYYHL23

And here's my excel request.

=@DSGRID("B:ABI","SECD","-0D","","","RowHeader=true;ColHeader=true;DispSeriesDescription=true;DispDatatypeDescription=true","")

Thanks in advance.