question

bin0 avatar image
1 0 1 4

mapping from RIC to PermID.

I got two questions in order to get ESG combined scores by use a RIC code.

1. which filed I can use to mapping from RIC to PermID in the ESG Bulk Symbology and company reference data

2. if I have the PermID, whick filed I can query to get this company's combined ESG scores.

Thanks

refinitiv-data-platformresg
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

zoya faberov avatar image
28.3k 30 11 15

Hello @bin0 ,

Conveying the answer from ESG Bulk expert:

"Hello Bin,

The easiest way to return ESG combined score for RIC’s would be to use the Request Response API:

https://api.refinitiv.com/data/environmental-social-governance/v2/views/scores-full?universe=IBM.N

As a bulk client, you will need to download and combine 2 different files to achieve the same result. This will return the full universe of all ESG Organizations and RIC codes.

  1. Bulk-ESG-Global-Symbology-InstrumentQuote-v1-Jsonl-
    https://api.refinitiv.com/file-store/v1/file-sets?bucket=bulk-ESG&packageId=4dc5-4efa-bf8327db-8997-57899e9833cc
    Within this file you can find the RIC codes:
    {"IdentifierData":[{"IdentifierValue":"IBM.N"}],"IdentifierType":{"IdentifierType":{"Name":"RIC"}}
    they can be mapped within the same JSONLine to the PermID: "IssuerOrganizationId":"4295904307"
  2. The scores file you need to download will depend upon the type of ESG license and level of history you have subscribed to.
    Assuming you have the full history scores license, Bulk-ESG-Global-Scores-Full-v1-Jsonl-
    https://api.refinitiv.com/file-store/v1/file-sets?bucket=bulk-ESG&packageId=4f1d-c1e4-b448e23b-a51a-e4315800de31
    (If you have a different level of ESG score license, you will need to use a different packageId)
    The Scores User Guide can help you to identify this.
    Documentation | Refinitiv Developers

All scores are delivered within this bulk file, not just the company combined scores.
"ESGScores":{"ESGCombinedScore":{"Value":"0.3868518467762233","ValueCalculationDate":"2021-05-15T18:45:54.757Z","ValueScoreGrade":"C"}

I hope this helps. "

10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.