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: 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
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.