Getting the Details of a Data Provider

Gets the details of a data provider for a Web Intelligence document.

Request

GET <webiURL>/documents/{documentId}/dataproviders/{dataProviderId}

Where:

  • {documentId} is the document identifier
  • {dataProviderId} is the identifier of the data provider available for a document
Response

Response type: application/xml or application/json

Response body: the details of the data provider, with:

  • id
  • name
  • dataSourceId
  • dataSourcePrefix, used as prefix for data source object IDs of .unv universes only
  • The date and time of the last update
  • ispartial
  • The number of rows
  • The objects dictionary, with:
    • id
    • name
    • description
    • dataSourceObjectId
    • formulaLanguageId, used as key for data filters

Example

GET <webiURL>/documents/18809/dataproviders/DP0

<dataprovider>
    <id>DP0</id>
    <name>Query 1</name>
    <dataSourceId>7599</dataSourceId>
    <dataSourcePrefix>DS0</dataSourcePrefix>
    <updated>2012-07-31T15:44:25.000+02:00</updated>	
    <duration>1</duration>
    <isPartial>false</isPartial>
    <rowCount>284</rowCount>
    <flowCount>1</flowCount>
    <dictionary>
        <expression dataType="String" qualification="Dimension">
            <id>DP1.DO1</id>
            <name>City</name>
            <description>City</description>  
            <dataSourceObjectId>AZ_CITY</dataSourceObjectId> 
            <formulaLanguageId>[City]</formulaLanguageId> 
        </expression>  
        <expression dataType="String" qualification="Dimension">
            <id>DP1.DO1d</id> 
            <name>Customer</name>  
            <description>Customer</description>  
            <dataSourceObjectId>AZ_CUSTOM</dataSourceObjectId>  
            <formulaLanguageId>[Query 2].[Customer]</formulaLanguageId> 
        </expression>  
        <expression dataType="String" qualification="Dimension"> 
            <id>DP1.DO6</id>
            <name>Sales Person</name>
            <description>Sales Person</description>
            <dataSourceObjectId>AZ_SALES</dataSourceObjectId>
            <formulaLanguageId>[Query 2].[Sales Person]</formulaLanguageId>
        </expression>  
        <expression dataType="Numeric" qualification="Measure"> 
            <id>DP1.DO5c</id> 
            <name>Order Amount</name>
            <description>Order Amount</description> 
            <dataSourceObjectId>MCWZZCK8Z39ES5HKKFA52FG78E</dataSourceObjectId> 
            <formulaLanguageId>[Query 2].[Order Amount]</formulaLanguageId> 
        </expression>  
        <expression dataType="Numeric" qualification="Measure"> 
            <id>DP1.DO5f</id>  
            <name>Order Quantity</name>  
            <description>Order Quantity</description>  
            <dataSourceObjectId>M7MRKCICEBY5WYKQ8AL86VY9Q8</dataSourceObjectId>  
            <formulaLanguageId>[Query 2].[Order Quantity]</formulaLanguageId> 
        </expression> 
    </dictionary>  
</dataprovider>