Restful api Not Refreshing Multiple values in InList Prompts

[Former Member]

I am using Restful web service to refresh the document which as filter values with InList and EqualTo prompts. When saving the refreshed report into any format say PDF using Restful api the report data is incorrect. I am using the below XML as a request body.

<parameters>

    <parameter>

        <id>0</id>  

        <answer>      

            <values>

                <value>0</value>

                <value>2</value>

                <value>761</value>

                <value>858</value>

                <value>863</value>

                <value>867</value>

                <value>868</value>

                <value>869</value>

                <value>870</value>

                <value>871</value>

                <value>872</value>

                <value>873</value>

                <value>893</value>

            </values>

        </info>

    </answer>

</parameter>

<parameter>

    <id>1</id>

    <answer>

        <values>

            <value>BURDN</value>

        </values>

    </answer>

</parameter>

</parameters>

If I provide single value in InList and EqualTo Prompt then the report produces the correct data. But this is not the case when passing multiple InList values and EqualTo prompts.

Can any body please suggest me the possible solutions.

[daniel_paulsen]

it could be the "</info>" tag making the answer incorrect.  Try removing that.

Also if you do a GET to the same URL after doing your "PUT" with multiple values, what does the response look like?

Dan

[Former Member]

Hi Dan,

Thanks for your response. Sorry by mistake I copied over the XML. There is no </info> tag present while posting the request body to Restful web service

Below is the Reqeust Body:

<parameters>

    <parameter>

        <id>0</id> 

        <answer>     

            <values>

                <value>0</value>

                <value>2</value>

                <value>761</value>

                <value>858</value>

                <value>863</value>

                <value>867</value>

                <value>868</value>

                <value>869</value>

                <value>870</value>

                <value>871</value>

                <value>872</value>

                <value>873</value>

                <value>893</value>

            </values>       

    </answer>

</parameter>

<parameter>

    <id>1</id>

    <answer>

        <values>

            <value>BURDN</value>

        </values>

    </answer>

</parameter>

</parameters>

Below is the actual document properties.

<parameters>

    <parameter dpId="DP0" type="prompt" optional="false">

        <id>0</id>

        <technicalName>Enter Oracle Code:</technicalName>

        <name>Enter Oracle Code:</name>

        <answer type="Numeric" constrained="false">

            <info keepLastValues="false" cardinality="Single">

                <lov mandatorySearch="false" searchable="true" refreshable="true" partial="false" hierarchical="false">

                    <id>UNIVERSELOV_DS0.DO394</id>

                    <updated>2016-03-04T11:09:30.000Z</updated>

                    <intervals>

                        <interval id="0">

                            <value>0</value>

                            <value>973</value>

                        </interval>

                        <interval id="1">

                            <value>974</value>

                            <value>1077</value>

                        </interval>

                        <interval id="2">

                            <value>1080</value>

                            <value>1179</value>

                        </interval>

                        <interval id="3">

                            <value>1187</value>

                            <value>1514</value>

                        </interval>

                        <interval id="4">

                            <value>1515</value>

                            <value>1564</value>

                        </interval>

                        <interval id="5">

                            <value>1565</value>

                            <value>1616</value>

                        </interval>

                        <interval id="6">

                            <value>1617</value>

                            <value>1820</value>

                        </interval>

                        <interval id="7">

                            <value>1821</value>

                            <value>1870</value>

                        </interval>

                        <interval id="8">

                            <value>1871</value>

                            <value>1967</value>

                        </interval>

                        <interval id="9">

                            <value>1968</value>

                            <value>2069</value>

                        </interval>

                        <interval id="10">

                            <value>2070</value>

                            <value>2128</value>

                        </interval>

                        <interval id="11">

                            <value>2129</value>

                            <value>2181</value>

                        </interval>

                        <interval id="12">

                            <value>2182</value>

                            <value>2237</value>

                        </interval>

                        <interval id="13">

                            <value>2238</value>

                            <value>2341</value>

                        </interval>

                        <interval id="14">

                            <value>2343</value>

                            <value>2432</value>

                        </interval>

                        <interval id="15">

                            <value>2433</value>

                            <value>2485</value>

                        </interval>

                        <interval id="16">

                            <value>2486</value>

                            <value>2536</value>

                        </interval>

                        <interval id="17">

                            <value>2537</value>

                            <value>2588</value>

                        </interval>

                        <interval id="18">

                            <value>2589</value>

                            <value>2661</value>

                        </interval>

                        <interval id="19">

                            <value>2668</value>

                            <value>2852</value>

                        </interval>

                        <interval id="20">

                            <value>2853</value>

                            <value>2944</value>

                        </interval>

                        <interval id="21">

                            <value>2945</value>

                            <value>3219</value>

                        </interval>

                        <interval id="22">

                            <value>3220</value>

                            <value>3269</value>

                        </interval>

                        <interval id="23">

                            <value>3270</value>

                            <value>3319</value>

                        </interval>

                        <interval id="24">

                            <value>3320</value>

                            <value>3370</value>

                        </interval>

                        <interval id="25">

                            <value>3371</value>

                            <value>3421</value>

                        </interval>

                        <interval id="26">

                            <value>3426</value>

                            <value>3521</value>

                        </interval>

                        <interval id="27">

                            <value>3522</value>

                            <value>3637</value>

                        </interval>

                        <interval id="28">

                            <value>3638</value>

                            <value>3687</value>

                        </interval>

                        <interval id="29">

                            <value>3688</value>

                            <value>3816</value>

                        </interval>

                        <interval id="30">

                            <value>3817</value>

                            <value>3869</value>

                        </interval>

                        <interval id="31">

                            <value>3870</value>

                            <value>3919</value>

                        </interval>

                        <interval id="32">

                            <value>3920</value>

                            <value>3996</value>

                        </interval>

                        <interval id="33">

                            <value>3997</value>

                            <value>4090</value>

                        </interval>

                        <interval id="34">

                            <value>4091</value>

                            <value>4189</value>

                        </interval>

                        <interval id="35">

                            <value>4190</value>

                            <value>4288</value>

                        </interval>

                        <interval id="36">

                            <value>4289</value>

                            <value>4346</value>

                        </interval>

                        <interval id="37">

                            <value>4347</value>

                            <value>5000</value>

                        </interval>

                        <interval id="38">

                            <value>5010</value>

                            <value>5285</value>

                        </interval>

                        <interval id="39">

                            <value>5286</value>

                            <value>5705</value>

                        </interval>

                        <interval id="40">

                            <value>5731</value>

                            <value>6539</value>

                        </interval>

                        <interval id="41">

                            <value>6540</value>

                            <value>6601</value>

                        </interval>

                        <interval id="42">

                            <value>6602</value>

                            <value>6672</value>

                        </interval>

                        <interval id="43">

                            <value>6673</value>

                            <value>7021</value>

                        </interval>

                        <interval id="44">

                            <value>7022</value>

                            <value>7225</value>

                        </interval>

                        <interval id="45">

                            <value>7226</value>

                            <value>7704</value>

                        </interval>

                        <interval id="46">

                            <value>7705</value>

                            <value>8289</value>

                        </interval>

                        <interval id="47">

                            <value>8290</value>

                            <value>9970</value>

                        </interval>

                    </intervals>

                    <values>

                        <value>0</value>

                        <value>2</value>

                        <value>761</value>

                        <value>858</value>

                        <value>863</value>

                        <value>867</value>

                        <value>868</value>

                        <value>869</value>

                        <value>870</value>

                        <value>871</value>

                        <value>872</value>

                        <value>873</value>

                        <value>893</value>

                        <value>901</value>

                        <value>902</value>

                        <value>903</value>

                        <value>904</value>

                        <value>905</value>

                        <value>906</value>

                        <value>907</value>

                        <value>908</value>

                        <value>909</value>

                        <value>911</value>

                        <value>912</value>

                        <value>913</value>

                        <value>914</value>

                        <value>915</value>

                        <value>916</value>

                        <value>917</value>

                        <value>918</value>

                        <value>919</value>

                        <value>922</value>

                        <value>923</value>

                        <value>924</value>

                        <value>925</value>

                        <value>926</value>

                        <value>927</value>

                        <value>928</value>

                        <value>962</value>

                        <value>963</value>

                        <value>964</value>

                        <value>965</value>

                        <value>966</value>

                        <value>967</value>

                        <value>968</value>

                        <value>969</value>

                        <value>970</value>

                        <value>971</value>

                        <value>972</value>

                        <value>973</value>

                    </values>

                    <columns mappingId="0">

                        <column type="Numeric" id="0">Oracle Code </column>

                    </columns>

                </lov>

            </info>

        </answer>

    </parameter>

    <parameter dpId="DP0" type="prompt" optional="false">

        <id>1</id>

        <technicalName>Enter Accounting Brand(s):</technicalName>

        <name>Enter Accounting Brand(s):</name>

        <answer type="Text" constrained="false">

            <info keepLastValues="false" cardinality="Multiple">

                <lov mandatorySearch="false" searchable="true" refreshable="true" partial="false" hierarchical="false">

                    <id>UNIVERSELOV_DS0.DO396</id>

                    <updated>2016-03-04T11:09:30.000Z</updated>

                    <values>

                        <value>BCGM</value>

                        <value>BRONI</value>

                        <value>BROOK</value>

                        <value>BUILD</value>

                        <value>BURDN</value>

                        <value>CLIMT</value>

                        <value>DRAIN</value>

                        <value>ELEC</value>

                        <value>FUSN</value>

                        <value>HEAT</value>

                        <value>HIRE</value>

                        <value>INFRA</value>

                        <value>IS</value>

                        <value>MPS</value>

                        <value>PARTS</value>

                        <value>PIPE</value>

                        <value>PLUMB</value>

                        <value>UNFIX</value>

                        <value>UPS</value>

                        <value>WU2HO</value>

                    </values>

                    <columns mappingId="0">

                        <column type="String" id="0">Trading Branch Primary Brand </column>

                    </columns>

                </lov>

            </info>

        </answer>

    </parameter>

</parameters>

Thanks,

Raj

[daniel_paulsen]

Hi Raj,

It seems that the first parameter, "Enter Oracle Code" is using "EqualTo" since the cardinality here is "Single":

        <name>Enter Oracle Code:</name>

        <answer type="Numeric" constrained="false">

            <info keepLastValues="false" cardinality="Single">

And the "Enter Accounting Brand(s)" parameter is using InList as its cardinality is multivalue:

        <name>Enter Accounting Brand(s):</name>

        <answer type="Text" constrained="false">

            <info keepLastValues="false" cardinality="Multiple">

can you verify this by running the report in BI Launchpad.  You should only be allowed to enter multiple values for the Accounting brand parameter.

Dan

[Former Member]

Hi Dan,

Yes, I am able to enter multiple values for the Accounting brand parameter in BI Launchpad and getting the expected output. However this is not refreshing using Restful WebService. I am using BI 4.1 SP6. Not sure my XML request body is correct or wrong? Can you have a look at my reuqest body and suggest some help to refresh the document with the In List + EqualTo prompts please?

Many Thanks,

Raj

[daniel_paulsen]

the problem is you are entering multiple values for a parameter that only allows one value.  You mentioned it works if you only set one value for each parameter. This makes sense.  You can ONLY add multiple values to the Accounting Brand parameter (<id>1</id>) so your request should be more like:

<parameters>

    <parameter>

        <id>0</id>

        <answer>    

            <values>

                <value>761</value>    <--Only a single value for this parameter

            </values>      

    </answer>

</parameter>

<parameter>

    <id>1</id>

    <answer>

        <values>

            <value>BURDN</value>          

            <value>BRONI</value>

            <value>CLIMT</value>

        </values>

    </answer>

</parameter>

</parameters>

Dan

[Former Member]

Hi Dan,

Thank you. I will try this and keep you posted the results.

Regards,

Raj

[Former Member]

Hi Dan,

I sent the correct XML body request to Restful API(as mentioned above) and getting the same incorrect out. Can you please shed some light on this?

Thanks,

Raj

[eric_festinger]

hi Raj

1. Which one is "the correct XML body request" you are mentionning? The (good) one which Dan posted, or yours (which is wrong)?
2. Please do activate "stack trace" in WebApplicationContainerServer (CMC / Servers) and copy-paste the response returned when you try to refresh the WebI document.
3. Please also copy/paste the output of .../biprws/raylight/v1/about.

Thanks and regards,

eric