Problem while exporting to CSV

[Former Member]

When i am trying to export BO report to CSV through JAVA code ,I am able generate CSV file.

But in the CSV file im getting data provider query name along with column header,that i dont want in my CSV file.

Please help me out in this .

code:

  CSVView csvView = doc.getDataProviders().getItem(0).getResultAsCSV(-1);

writeBytes(csvView.getContent().getBytes(), reportName +".csv", saveDir + requestId);

Please see the image i have attached.

In the file im getting "Group number(Unit purchase)" , I dont want the text inside bracket in my CSV.

Please suggest me on this.

[former_member197386]

Hi Swamy,

If you use the Webi REST API, you can get CSV from a dataprovider very easily (one HTTP call):

[GET] [GET] <url>/documents/18809/dataproviders/DP0/flows/0

"Year";"State";"Lines";"Sales revenue"

"2004";"California";"Accessories";"489665,9"

"2004";"California";"City Skirts";"11072,2"

"2004";"California";"City Trousers";"10935,1"

"2004";"California";"Dresses";"110209,8"

"2004";"California";"Jackets";"38369,4"

"2004";"California";"Leather";"26911,5"

"2004";"California";"Outerwear";"60164,5"

"2004";"California";"Overcoats";"22093,7"

"2004";"California";"Shirt Waist";"193185,5"

"2004";"California";"Sweaters";"70719,6"

Best reards,

Anthony