Skip to Content

How to update the Query of an existing WEBI document's dataprovider, through the RESTful Web service SDK.

Hi,

I am trying to update the Query of an existing WEBI document's dataprovider, through the RESTful Web service SDK.

For this, first i will get the Dataprovider information,

Example:

URI: http://localhost:6405/biprws/raylight/v1/documents/11111/dataproviders/DP0

Expected result;

<dataprovider>

     <id>DP0</id>

     <name>Query 1</name>

     <dataSourceId>1234</dataSourceId>

     <updated>2014-04-18T11:55:21.000-08:00</updated>

     <duration>1</duration>

     <isPartial>false</isPartial>

     <rowCount>113</rowCount>

     <flowCount>11</flowCount>

     <dictionary>

          <expression qualification="Dimension" dataType="String">

               <id>DP0.DO1</id>

                <name>EmpID</name>

               <description>Employee ID.</description>

                <dataSourceObjectId>DS0.DO1</dataSourceObjectId>

          </expression>

          <expression qualification="Dimension" dataType="String">

               <id>DP0.DO2</id>

               <name>EmpName</name>

               <description>Employee Name.</description>

               <dataSourceObjectId>DS0.DO2</dataSourceObjectId>

          </expression>

     </dictionary>

     <query>SELECT Employee.EmpID, Employee.EmpName FROM Employee</query>

</dataprovider>

Then Changing the above dataprovider's Query to some thing like below,

<query>SELECT Employee.EmpID, Employee.EmpName FROM Employee where Upper(Employee.EmpName)='RAJ'</query>

Please let me know the RESTful Call required to do this.

Thanks in advance.

Thanks,

Mahendra.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 29, 2014 at 07:38 PM

    Hi

    Please have a look at 1988540 - Changing Dataproviders for a Webi Report using RESTful Web Services

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Add comment
    10|10000 characters needed characters exceeded