Posting obo a client: Getting zero data from deal queries.
Have been circling back to this and now getting a plethora of 403 errors for subscription entitlements on things that were drawing correctly before. Any idea who can assist here?My authentication is working correctly (getting HTTP 200 responses), but I'm receiving zero data from deal queries.
Examples:
Example 1 - Basic Deal Access:
Query: SCREEN(U(IN(DEALS)),TOP(5)) Fields: TR.NIIssuer
Expected Result: List of 5 company names from recent deals
Current Result: Only header row, no data rows
Example 2 - ECM-Specific Access:
Query: SCREEN(U(IN(DEALS)),TR.NIisECM=True,TOP(5)) Fields: TR.NIIssuer, TR.NIIssueDate, TR.NIProceedsAmtAllMkts
Expected Result: 5 ECM deals with company, date, and deal value
Current Result: Only header row, no data rows
Example 3 - Deal Manager Access:
Query: SCREEN(U(IN(DEALS)),TOP(5)) Fields: TR.NIIssuer, TR.NIManagers
Expected Result: Companies and their investment banking syndicates
Current Result: Only header row, no data rows
My authentication works (HTTP 200), but all three queries above return only header rows with zero data rows. I need these examples to work for ECM competitive analysis. Not certain why its giving a 403 error now, these draws were working a few days ago.
We've isolated the issue with our data access. Our LSEG Workspace authentication works and we can access company/equity data, but we have zero access to deal transaction data.
Technical Evidence:
- Working: Direct ticker queries (AAPL.O, MSFT.O) return company data and revenue
- Working: Company fields like TR.CompanyName, TR.Revenue
- NOT Working: Any DEALS universe queries return 0 rows
- NOT Working: All screeners using
SCREEN(U(IN(DEALS)))
format
Specific Test Results:
AAPL.O,MSFT.O
with TR.CompanyName: ✅ Works (2 rows)MSFT.O
with TR.Revenue: ✅ Works ($281.7B)SCREEN(U(IN(DEALS)),TOP(1000))
: ❌ 0 rowsSCREEN(U(NewIssues),TOP(10))
: ❌ 0 rows- All deal-related universes: ❌ 0 rows
API Endpoint: POST
http://localhost:9000/api/v1/data
Let us know how to best proceed
Answers
-
REMOVED
Please do not post any user information on these public forums!!!
0 -
Please do not post any user information on these public forums!!!
Is the user able to get deals data using the LD library?
They are trying to directly interact with API proxy. This mechanism is not supported and will also be deprecated in future releases of the Workspace/LD library.
0 -
If the user needs REST API access, then please recommend enterprise products like LSEG Data Platform, Datascope, Tickhistory etc
0 -
Hi @Gurpreet , I have checked and the same to the client and here is her reply:
I was explicitly told that I could use the API locally to draw this information, also this endpoint was working fine until around a week ago. This is not an Api proxy this is a supported product by your team is it not? Can you please connect with our account managers to fix this.
Please advise.0 -
Please note that we are not the product support team.
Our role typically involves answering general or technical questions related to API usage and providing sample code snippets to help retrieve the required data.
For product-specific issues or support, please raise your query via LSEG Support.
If you can share the code used by the client, I’ll be happy to test it on my machine and assist further.
Moreover, 403 error could relate to the client network issue, such as proxy or firewall settings. The clients may contact their IT team to verify the network settings.
0 -
Hi @Jirapongse I have pasted the code here but it was removed as it contains client information.
Is there a way to sent it to you privately so you can test it out?0 -
There are two issues.
- We don't support this kind of usage. The client needs to use our LSEG Data Libraries (Python, .NET, and Typescript) to access the services from http://localhost:9000.
- The following screener formulas also don't work on the Workspace Excel
SCREEN(U(NewIssues),TOP(10)) SCREEN(U(Deal),TOP(10))
Please contact the helpdesk team to verify these formulas.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 708 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.3K Eikon Data APIs
- 14 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 6 Trading API
- 3K Elektron
- 1.5K EMA
- 259 ETA
- 570 WebSocket API
- 40 FX Venues
- 16 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 4 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 284 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 24 RDMS
- 2.2K Refinitiv Data Platform
- 890 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 124 Open DACS
- 1.1K RFA
- 108 UPA
- 196 TREP Infrastructure
- 232 TRKD
- 921 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 105 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛