Hello,
A request to /search/beta1 of the form:
{
"View": "Organisations",
"Query": "AMZN.O",
"Select": "CommonName, DocumentTitle"
}
returns the following:
{
"Total": 1,
"Hits": [
{
"CommonName": "Amazon.com Inc",
"DocumentTitle": "Amazon.com Inc, Public Company"
}
]
}
Where does the ", Public Company" come from? What field name can I specify in `Select` to get this information?
Thanks!
Hello @Diane.Napolitano,
Reference and Meatadata lookup on API Playground can be of help.
Select controls result set per View based on Properties.
For the available Views try Reference -> scroll to View
To see available properties for Organisations,
run /search/beta1/metadata/views/{view}
https://api.refinitiv.com/search/beta1/metadata/views/Organisations
The result should contain:
{
"Properties": {
"ActiveDebtInstrumentCount": {
"Type": "Double",
"Searchable": true,
"Sortable": true,
"Navigable": true
},
…
CommonAddressLine5": {
"Type": "String",
"Searchable": true
},
"CommonName": {
"Type": "String",
"Searchable": true,
"Sortable": true
},
"CommonNameJaHani": {
"Type": "String",
"Searchable": true
},
…
Thank you @zoya.farberov ! This is exactly what I needed. I found the data I was looking for in `DTSimpleType`. Thanks again.
Can you elaborate on what you mean by "Where does the ', Public Company' come from?" ?
As far as I can tell, the only 'Select' specification is 'DocumentTitle' that will contain the reference to the term 'Public Company'. Are you specifically interested in retrieving this information within a specific, dedicated field? If so, I performed a simple request to retrieve all fields within the 'View' ('SearchAll'). Of the 10000 records returned, no dedicated field contains the term 'Public Company'. I would recommend you confirm with the Refinitiv Helpdesk as they can reach out to the specific team to confirm the content. Of course, the workaround is to programmatically extract this from the documentTitle.
Hi @nick.zincone.1, yes, I'm interested in getting "Public Company" in a specific, dedicated field. `SearchAll` seems to provide a very limited set of fields per result, and I've been discovering a lot of useful ones through trial and error...I'll try reaching out to the Helpdesk to see if they have any comprehensive documentation on the search/ endpoint. Thanks!
