Creating a Query

Creates a precompiled query statement in an instance of the open session.

This instance can be used to run this statement multiple times. The query is not stored to the CMS repository, but in memory.

Request

POST <slURL>/queries

Request body:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<query dataSourceType="unx" dataSourceId="..." xmlns="http://www.sap.com/rws/sl/universe">
    Query_Specification
</query>

Where:

  • dataSourceType is the universe type (unx)
  • dataSourceId is the universe identifier
  • Query_Specification is the XML query specification
Response

Response type: application/xml

The response is a message stating the success or failure of the request.

Example

Creating a Query with Result Objects Only

POST <slURL>/queries

With the following request body in an XML file:

<query dataSourceType="unx" dataSourceId="5808" xmlns="http://www.sap.com/rws/sl/universe">
    <querySpecification version="1.0">
        <queryData>
            <resultObjects>
                <resultObject path="Customer|folder\Geography|folder\City|dimension"
                    id="_IBo8L7IhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Customer|folder\Customer|dimension" 
                    id="_IBo8OrIhEeCk0Ylv-tlF2Q"/>
                <resultObject path="Inventory|folder\Stock Level|measure" 
                    id="_IB8eFrIhEeCk0Ylv-tlF2Q"/>
            </resultObjects>
        </queryData>
    </querySpecification>
</query>

Response:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<success>
    <message>The resource of type 'query' with identifier '6089913651317040730' has been
        successfully created.</message>
    <id>6089913651317040730</id>
</success>

The response contains the query identifier as <id>.