Last refreshed value for prompts & Custom query script

[former_member204024]

Hi,

I am a newbie to RESTful Webservices.  I am trying to change the datasource for a dataprovider.  While doing so I am interested to know the last refreshed prompt values if it has saved data.  Also I am interested in knowing whether "Use custom query script" option is enabled for the dataprovider.

If its enabled I want to skip the swapping of datasource as it reset the query.

Thanks in advance.

Regards,

Subramanian S.

[former_member197386 · Accepted solution]

Hello Subramanian,

And welcome

If you want to get the last refresh date of a Webi document, you can get it on document details:

[GET] /documents/1234

for instance.

Regards,

Anthony

[former_member204024 · Accepted solution]

Hi Antony,

I am looking for last refreshed prompt/parameter values.  To answer the mapping payload during my post request.

Regards,

Subramanian S.

[former_member197386 · Accepted solution]

Ok, I guess you mean previous answer values. You can get them using this kind of call:

[GET] .../documents/1234/parameters?lovInfo=false

Anthony

[former_member204024 · Accepted solution]

Thanks you Anthony.  I am saved this option is available in SP3.

Regards,

Subramanian S.

[former_member204024 · Accepted solution]

How to mark two respondent as correct.  You gave me one half of it, Eric gave me another half.  But SCN doesn't allow me to mark two of them as Correct answer.

Regards,

Subramanian S.

[former_member197386 · Accepted solution]

You have to do a difficult choice so!

Anthony

[former_member204024]

Hi Anthony,

Where to refer for the documentation of these option.

The link in Homepage is not working.

http://scn.sap.com/community/restful-sdk

Regards,

Subramanian S.

[former_member197386]

oh, there is a typo in the link

try :

SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Laye...

Anthony

[daniel_paulsen]

you're right, the link is incorrect.  I'll see if I can get it fixed.

documentation for webi SDKs is here:

SAP BusinessObjects Web Intelligence 4.1 – SAP Help Portal Page

Dan

[daniel_paulsen]

The link is fixed now

Dan

[former_member204024]

Thanks Dan.

[eric_festinger]

hello Subramanian,

Regarding the "Use custom query script" option, you should ask for the query plan of the dataprovider. It's mapped to "editable" attribute.

For example:

[GET] .../documents/9106/dataproviders/DP2/queryplan

<queryplan custom="false" editable="true">

    <union>

        <fullOuterJoin>

            ...

Regards,

eric

[former_member204024]

Hi Eric,

My hardluck I am in bo41sp3. So I couldn't run and see it.

Can you please confirm whether the attribute that you mention tag to "Use Custom Query Script" property or "Allow other users to edit all queries" property.

Thanks in advance.

Regards,

Subramanian S.

[former_member197386]

Maybe you could consider to move to 4.1 SP6 when it will be out?

Anthony

[eric_festinger]

(If I remove the error-checking to make it simpler here) the "editable" attribute is mapped to DataSource.getQueryCapability().getGeneralCapability().isCustomQueryScriptSupported().

eric