Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
REFINITIV
Question by hiroko.goto · Oct 18, 2018 at 11:15 PM · dss rest apitrth rest apiscript

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

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,

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by gteage01 · Oct 19, 2018 at 03:38 AM

@hiroko.goto

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


dss-gui-ftp-restapi-screen.png (260.3 KiB)
Comment

People who like this

0 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
hiroko.goto · Oct 24, 2018 at 02:14 AM 0
Share

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

avatar image
REFINITIV
gteage01 · Oct 25, 2018 at 01:32 PM 0
Share

@hiroko.goto

Hi Hiroko,

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

Best regards,

Gareth

avatar image
REFINITIV
hiroko.goto · Oct 25, 2018 at 09:19 PM 0
Share

Thank you, noted.

Regards,

Hiroko

avatar image
REFINITIV
Answer by Christiaan Meihsl · Oct 19, 2018 at 03:43 AM

@hiroko.goto, 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.

Comment
veerapath.rungruengrayubkul

People who like this

1 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Christiaan Meihsl ♦♦ · Oct 22, 2018 at 09:55 AM 0
Share

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

avatar image
REFINITIV
hiroko.goto · Oct 24, 2018 at 02:15 AM 0
Share

Thank you, Christiaan.

Best regards,

Hiroko

avatar image
REFINITIV
hiroko.goto · Oct 25, 2018 at 09:21 PM 0
Share

Chrsitiaan Thank you very much for your advice!

Best regards,

Hiroko

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

DataScope with Java Isin features request

GOOGLE, APPL and AMZN Implied Vol

DSS Rest API, is it possible to have 250 days ROLLING history for an equity? could you provide an example?

fx rate extraction

why to say "Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken"

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges