The api docs direct us to either the Data Item Browser (DIB) or the Excel add in to discover the fields and parameters available for use in the api (specifically the get_data method).
However take for example the field "TR.IndexConstituentRIC" which frequently appears on this forum, I cannot find this field in either the DIB or the Excel Formula Builder. I can even use it in Excel! But only if I somehow know it exists!
1. Am I doing something wrong which is hiding some fields from me in the DIB?
2. Is there a complete list of available fields somewhere(and if not why not)?
3. Are there any other undocumented data fields people have found or commonly use?