Dear Team: Kindly tell me how to get extracted file content for legal entity detail in json.

Dear Team: Kindly tell me is there any way to get the extracted file content of DSS legal entity details in JSON format.Currently I am getting it in string format and it is difficult to convert that.
Currently I am getting data like this
DownloadedFile:
DownloadedFile:
Country of Incorporation,Date of Incorporation,Derived Ultimate Parent Entity ID,Derived Ultimate Parent Official Name,Derived Ultimate Parent OrgID,Derived Ultimate Parent RCP ID,Derived Ultimate Parent Reuters Editorial RIC,Entity PermID,Headquarters City/Town,Headquarters Country,Headquarters Country Description,Headquarters Fax,Headquarters Postal/Zip Code,Headquarters State Code,Headquarters Country,Headquarters Street1,Headquarters Street2,Headquarters Street3,Headquarters Street4,Headquarters Street5,Headquarters Telephone,Legal Entity OrgID,Official Name,Registered City/Town,Registered Country Description,Registered Fax,Registered Postal/Zip Code,Registered State Code,Registered Country,Registered Street1,Registered Street2,Registered Street3,Registered Street4,Registered Street5,Registered Telephone,TRBC Business Sector Code,TRBC Business Sector Code Description,TRBC Economic Sector Code,TRBC Economic Sector Code Description,TRBC Industry Code,TRBC Industry Code Description,TRBC Industry Group Code,TRBC Industry Group Code Description,Derived Parent Entity ID,Derived Parent Official Name,Derived Parent OrgID,Derived Parent RCP ID,Derived Parent Reuters Editorial RIC
IN,19950119,0x0003ef06c4921ea2,TATA SONS LIMITED,143869,500071938,,4295872706,MUMBAI,IN,India,912267789000,400001,,IN,TCS House,"Raveline Street, Fort",NA02,,,912267789999,100445905,TATA CONSULTANCY SERVICES LIMITED,MUMBAI,India,912267789660,400021,,IN,9th Floor Nirmal Building,Nariman Point,NA02,,,912267789595,5720,Software & IT Services,57,Technology,57201010,IT Services & Consulting,572010,Software & IT Services,0x0003ef06c4921ea2,TATA SONS LIMITED,143869,500071938,
US,20040729,0x0003ef06cde7d616,"FACEBOOK, INC.",102739130,600137791,FB.OQ,4297297477,MENLO PARK,US,United States,NA02,94025-1452,CA,US,1601 Willow Rd,NA02,NA02,,,16506187714,102739130,"FACEBOOK, INC.",WILMINGTON,United States,13026365454,19808-1660,DE,US,2711 Centerville Rd,NA02,NA02,,,13026365400,5720,Software & IT Services,57,Technology,57201030,Internet Services,572010,Software & IT Services,0x0003ef06cde7d616,"FACEBOOK, INC.",102739130,600137791,FB.OQ
Best Answer
-
Yes and No.
No: JSON is not an available file format for scheduled extractions where you are simply using the API to pull down the generated file. Note: XML is an option here which may be better than CSV for you.
Yes: In that On Demand extractions submitted via the API using the ExtractWithNotes() method return the results in JSON.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.5K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 560 WebSocket API
- 39 FX Venues
- 15 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
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 281 Open PermID
- 46 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 724 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- 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
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛