Query specification

[Former Member]

Hi guys,

I am using the Restful SDK to get the dataproviders query specification (http://server:6405/biprws/raylight/v1/documents/{ID}/dataproviders/DP0/specification). The result XML is something like this:

<queryspec:QuerySpec xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:parameter="http://com.sap.sl.parameter" xmlns:queryspec="http://com.sap.sl.queryspec" dataProviderId="DP0">

    <queryParameters>   

    </queryParameters>

    <queriesTree xsi:type="queryspec:QueryOperatorNode" queryOperator="Union">

        <children xsi:type="queryspec:QueryDataNode">

            <bOQuery name="Query" identifier="_DQwTUS-BEeWGVJVUo9we">

                <resultObjects identifier="DS0.DO4fc" name="asdasdad"/>

                <conditionPart>

                    <conditionTree xsi:type="queryspec:ConditionOperatorNode" logicalOperator="And">

                    </conditionTree>

                </conditionPart>

            </bOQuery>

        </children>

    </queriesTree>

</queryspec:QuerySpec>

I have to parse this XML to identify all the universe objects used by the document (result objects and conditions too). Where can I find the formal schema/specification/documentation for this XML?

Are there any good examples available, to parse this XML?

Thx.

[former_member197386 · Accepted solution]

Hello,

Just be careful because all result objects may not be used in the document.

I think there is no particular documentation of the query specification. The format is the same used by IDT (Information Design Tool).

Best regards,

Anthony

[Former Member · Accepted solution]

Thx Anthony,

what do you mean by "all result objects may not be used in the document". If a query spec lists an object as a result object I would consider that object to be "used by" the document, meaning: I can't delete that object from the universe, because the document depends on that object.

Am I missing something?

[former_member197386 · Accepted solution]

Hello,

I just mean that some result objects might not be used in any reports.

I'm not sure what will be the result if you drop an object from universe if this one is used into a report. Probably you will get an error at refresh time?

Regards,

Anthony

[Former Member · Accepted solution]

It's alright if it is not in a report. If it is listed as a result object I consider it is being used. I don't want Webi users to get an error because an object has been removed from the universe.

Regards,

Domonkos

[former_member197386 · Accepted solution]

Ok, I understand the purpose of your application and I agree with your checks!

About the query specification (QS) format, we have a action item in our backlog to add also the support of the QS format (XML/JSON) used in SL RESTful API. But I can't say when it will be available... 😕

Regards,

Anthony