Issues updating QueryParameters using Restful API

[former_member507665]

Hello,

I am trying to update the QueryParameters section of the query spec for an existing Webi document.

I "GET" the query specification with this URL: http://<server>:6405/biprws/raylight/v1/documents/294893/dataproviders/DP0/specification

When I make my change and run a "PUT" against the same URL I get a success message back but it says the resource has not been modified.

<success>
<message>The resource of type "Data provider" with identifier "DP0" has not been modified.</message>
<id>DP0</id>
</success>

If I remove a column from the boQuery section of the XML and also make my parameter change then the PUT is successful and the resource is updated.

I need to be able to make a change to a data providers queryParameter without editing the columns, am I using the wrong endpoint or doing something wrong?

[former_member507665]

Hi,

I am "GET"ing the XML for the DP0 specification from this endpoint

http://<server>:6405/biprws/raylight/v1/documents/294893/dataproviders/DP0/specification

and it returns this code

<?xml version="1.0" encoding="UTF-8"?>
<queryspec:QuerySpec xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:queryspec="http://com.sap.sl.queryspec" version="19" dataProviderId="DP0">
    <queryParameters sampleSize="500" samplingMode="None">
        <duplicatedRowsProperty activated="true" value="true"/>
        <maxRetrievalTimeInSecondsProperty value="0"/>
        <maxRowsRetrievedProperty value="0"/>
        <removeEmptyRowsProperty activated="true" value="true"/>
        <allowOtherUserToEditQueryProperty activated="true" value="true"/>
        <resetContextOnRefreshProperty activated="true" value="true"/>
        <stripQueryProperty/>
        <useBexQueryDefaultValue activated="true" value="true"/>
        <rightTrim/>
    </queryParameters>
    <queriesTree xsi:type="queryspec:QueryDataNode">
        <bOQuery name="Query 1" identifier="_EeTHANBaEei887fOWTDp5A">
            <resultObjects identifier="OBJ_103" name="Customer State"/>
            <resultObjects identifier="OBJ_102" name="Customer City"/>
            <resultObjects identifier="OBJ_61" name="Revenue"/>
            <conditionPart/>
        </bOQuery>
    </queriesTree>
</queryspec:QuerySpec>

and I am editing the line for rightTrim and "PUT"ting to this endpoint

<rightTrim activated="true" value="true"/>

http://<server>:6405/biprws/raylight/v1/documents/294893/dataproviders/DP0/specification

the response I get is

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<success>
    <message>The resource of type "Data provider" with identifier "DP0" has not been modified.</message>
    <id>DP0</id>
</success>

[DellSC]

What endpoint are you using? Can you post the code that you're using to modify the params? Also, are you editing the params to update the report and save it or are you editing them to run the report?

-Dell