Java SDK code to get details of Data provider with Excel as data source in BO 4.1

[Former Member]

Hi Experts,

I am developing a Java application using Restful webservices SDK to get webi report metadata.

I got a solution to get list of dataproviders in a webi report and SQL queries of each data provider. But not able to fetch information if the data provider is with Excel data source.

I searched a lot but not able to find solution for Excel data provider in BO 4.1 as PersonalDataProvider interface are deprecated from BO 4.0

Can anyone please help me in getting Excel data provider information.

Thanks and Regards,

Preethi M

[Former Member]

Hi Preethi,

You should be able to get the details using the Restful webservices. Which Service pack you are on?

The rest call should be

GET /documents/<documentID>/dataproviders

You can find the details from the from the Restful guide available at help.sap.com

The response should look like below

For any restful related queries please post to the below forum space which is dedicated space for Restful Webservices for better response.

Thanks,

Prithvi

[Former Member]

Hi Prithvi,

Thanks for your response.

I am able to get dataprovider details if the data source of data provider is Universe.

Now i need a Java sdk code to get dataprovider information/sql queries if data source of data provider is Excel.

And we are on BO 4.1 SP6

Can you please help me in that.

Thanks,

Preethi

[Former Member]

Hi Preethi,

I do not have an environment to test and let you know how the results would look like. You can try the below Rest calls and check if you get the desired details.

1. To retrieve the data providers of a document

GET /documents/<documentID>/dataproviders

A Document with excel as data source should return a response as below

<dataprovider>

  <id>DP3</id> 

  <name>Query 4</name> 

  <dataSourceId>6641</dataSourceId> 

  <dataSourceType>excel</dataSourceType> 

  <updated>2014-04-29T13:37:24.000+02:00</updated>

  </dataprovider>

2. To get the details of the excel you can then use the below rest call

GET /spreadsheets/<spreadsheetID>

Spreadsheet Id is the datasource id above.

3. To get QueryPlan, try

GET /documents/<documentID>/dataproviders/<dataProviderID>/queryplan

Let me know if you get the details you looking for with these rest calls. I would see if I can get an environment to check the behavior myself.

Thanks,

Prithvi

[Former Member]

Hi Prithvi,

Thanks.

Let me check with these rest calls.

Thanks and Regards,

Preethi