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.

@alejandro.lesaga

Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Upvotes
Accepted
25.3k 87 12 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
22k 58 14 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.