Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by rajat.agarwal · Oct 09, 2018 at 11:39 AM · datastreamvbadfocominterfacerequesttable

gRTCOMInterface.ProcessRequestTable hangs up

Hi, I'm using VBA to automate executing multiple Datastream Request Tables iteratively. It seems that each request table calls gRTCOMInterface.ProcessRequestTable to fetch the data from datastream servers. However, I noticed that after a couple of requests, this method gets hung up and the data retrieval process never completes.

Unfortunately, this leades to the fact that all subsequent code in my macro which was supposed to be executed, after the retrieval is complete, never gets executed and I need to restart Excel.

I was therefore wondering:

1. Is there a way to implement a time-out around gRTCOMInterface.ProcessRequestTable such that after say 15 minutes elapse, gRTCOMInterface.ProcessRequestTable is automatically aborted?

2. Is there a way to see what's going on behind the scenes in gRTCOMInterface.ProcessRequestTable so that I can implement some error-handling on my own?

Thanks!

People who like this

0 Show 1
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.

avatar image
vicissitude · Feb 06, 2019 at 04:39 PM 0
Share

Hi. I have a question about how you achieve it. I suppose that you use VBA to automatically fill in the Request Table and call gRTCOMInterface.ProcessRequestTable to retrieve the data into a specific workbook and then automatically save that workbook, right? Thanks.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by paul.bacon · Oct 17, 2018 at 06:52 AM

Hi rajat.agarwal

This forum is for the use of the API service - rather than request tables, questions on those should be directed to the helpdesk. However, I have looked into your request and have a few points.

We typically do not expose the code behind ProcessRequestTable command and its not something we support. I have found that there are examples in the template library such (as Datastream Historical Constituents.xlsm) – where the output from a Request Table is manipulated after the data has been downloaded - you may wish to look at these.


cusersu9006407desktoptempcapture.jpg (105.9 KiB)
Comment

People who like this

0 Show 0 · 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.

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 >
10 People are following this question.

Related Questions

using schedual task in windows to run Data Stream request

Is there a VBA macro to refresh DataStream DSGRID() functions?

Datastream for Office (DFO) Excel Add-In Connection Status

How to get the same results in python API as the one from DFO?

Retrieve Datastream data when we only subscribe to Eikon

  • 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