Can we extract data file via API then download file itself via FTP?

hiroko.goto1

Can we script from specifying TRTH/DSS instrument lists to scheduling via REST API then extract out put file itself via FTP?

My client would like to script request steps until daily schedules with instrument lists and report templates through REST API. They would like to use FTP for the final step i.e. fetching scheduled output files from TRTH/DSS. Please advise if this is possible.

Regards,

gteage01

@hiroko.goto1

Hi Hiroko,

I find it easier to consider the REST API to have 2 separate options to extract data:

1) The 'physical component' ('Scheduled') option; which is covered by GUI, FTP and REST API; this where a physcial components (list, template, schedule - which goes to ouptut an extraction file), and regardless of which connection method used the changes are visible in a physical form, ie. make a change via GUI, FTP or REST API you can see the change via GUI, FTP or REST API...

2) The 'virtual' option ('On Demand') via REST API only; you compile the equivlent of a list and template, and submit the request via a call, and instead of getting the data back within a physical extract file users would get the data back in the request's response.

The screenshot below shows an example where I have created created the physical components via REST API and the components are also reflected in the GUI and FTP locations:

Best regards,

Gareth

Christiaan Meihsl

@hiroko.goto1, your query does not specify if your customer is using DSS or TRTH.

TRTH does not have FTP capabilities. For scheduled requests, output files can be retrieved either manually through the GUI, or via the API. For the API, there are script samples that show how to retrieve data from a schedule, see the very simple Bash script using Curl and the Python Code Sample, both available under the TRTH downloads tab. In that same location there are also 3 Java samples illustrating that, see those that related to immediate schedules. REST API Tutorial 12 also describes the HTTP requests for data retrieval after a scheduled extraction. Finally, .Net tutorial 4 describes the same in C#.

DSS has FTP capabilities, which I am not familiar with. As a starter on those features, see the DSS User Guide. For the details, see the DSS FTP User Guide.

Christiaan Meihsl

https://community.developers.refinitiv.com/discussion/comment/33525#Comment_33525

@hiroko.goto1, I just edited my response, adding a link to the FTP user guide.

hiroko.goto1

https://community.developers.refinitiv.com/discussion/comment/33521#Comment_33521

Hi Gareth,

Thank you for your advice.

Can you please confirm if my below understanding is correct?

(1) We can create DSS settings from instrument lists/report templates to Schedules through 'physical component (scheduled)' option by REST API.

(2) We can then download output files via FTP.

Thank you and regards,

Hiroko

hiroko.goto1

https://community.developers.refinitiv.com/discussion/comment/33525#Comment_33525

Thank you, Christiaan.

Best regards,

Hiroko

gteage01

https://community.developers.refinitiv.com/discussion/comment/33521#Comment_33521

@hiroko.goto1

Hi Hiroko,

Yes that is correct for DSS. As @Christiaan Meihsl mentioned you can't do for TRTHv2 as there's no FTP for TRTHv2, but for DSS that's possible.

Best regards,

Gareth

hiroko.goto1

https://community.developers.refinitiv.com/discussion/comment/33521#Comment_33521

Thank you, noted.

Regards,

Hiroko

hiroko.goto1

https://community.developers.refinitiv.com/discussion/comment/33525#Comment_33525

Chrsitiaan Thank you very much for your advice!

Best regards,

Hiroko