Hi Team. We have a client looking to pull Commodities Tradeflow data monthly as part of their automated process to store the data into a database using a python client. Could you let us know what API options are available?
@katherinemalagueno1
The client can use the LSEG Data Library for Python to retrieve data through the Workspace desktop session.
The example is available on GitHub. The client needs to modify the configuration file to set the default session to "desktop.workspace".
"default": "desktop.workspace",
After that, specify the application key in the configuration.
"desktop": { "workspace": { "app-key": "YOUR APP KEY GOES HERE!" }
The client can use the get_data method to retrieve data.
This method can retrieve the same data as the =RDP.Data function in the Workspace Excel. Therefore, the client needs to contact the helpdesk team for the instruments, fields, and parameters that can provide the retrieved. Then, apply those values to the get_data method.
Otherwise, you can share the =RDP.Data formular used to retrieve the required data. Then, I can convert it to Python code.
