RDP CommonName vs. DocumentTitle

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!

Find more posts tagged with

rdp-api

refinitiv-data-platform

Accepted answers

zoya faberov

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
    }, 
…

All comments

nick.zincone

Hi @Diane.Napolitano,

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.

Diane.Napolitano

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!