question

Upvotes
Accepted
11 0 3 5

RDP ESG Api - Only JSON format supported or is it possible to have it in csv or xml?

rdp-apirefinitiv-data-platformesgjson
icon clock
10 |1500

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

Upvotes
Accepted
25.4k 90 13 25

Hi @alejandro.lesaga

The Refinitiv Data Platform APIs are based on JSON as one of the most popular open standard file / data exchange formats.

If you want to convert CSV or other formats you can do so using other 3rd party / open source libraries - for example on Python the pandas library has functionality to convert a json file to csv file. It should also be possible to do the same in other languages.


icon clock
10 |1500

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

Upvotes
24.8k 64 15 21

Hi @alejandro.lesaga, as Umer has pointed out, all the response data from RDP is based on JSON format only.

The ESG data is also available in the bulk download format, and I believe it is provided as a CSV file. The API for that is Client File Store which is currently in Beta, and needs a separate set of entitlements. Although, there is no ESG example, you can read about the CFS API in this tutorial. For bulk ESG data, the bucket name is EDS-BULK-ESG-Production.

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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