Getting the List of Data Providers

Usage

Gets the list of data providers of a Web Intelligence document.

The list can contain universes (unv and unx), BEx queries, Microsoft Excel spreadsheets, and free-hand SQL data providers.

Request

GET /documents/<documentID>/dataproviders

Response

Response type: application/xml or application/json

Response body: the list of <dataprovider> elements with the following information:

  • <id>
  • <name>
  • <dataSourceId> is the data source identifier
  • <dataSourceType> is the type of data source (unx, unv, bex, excel, and fhsql)
  • <updated> is the date of the last update

Example

GET /documents/7738/dataproviders

XML response:

<dataproviders>
    <dataprovider>
        <id>DP0</id>
        <name>Query 1</name>
        <dataSourceId>6187</dataSourceId>
        <dataSourceType>unv</dataSourceType>
        <updated>2006-09-20Z</updated>
    </dataprovider>
    <dataprovider>
        <id>DP1</id>
         <name>Query 2</name>
         <dataSourceId>6191</dataSourceId>
         <dataSourceType>unx</dataSourceType>
         <updated>2014-04-23T09:08:20.000+02:00</updated>
    </dataprovider>
    <dataprovider>
        <id>DP2</id>
        <name>Query 3</name>
        <dataSourceId>6120</dataSourceId>
        <dataSourceType>bex</dataSourceType>
        <updated>2014-04-23T09:08:20.000+02:00</updated>
    </dataprovider>
    <dataprovider> 
        <id>DP3</id>  
        <name>Query 4</name>  
        <dataSourceId>6641</dataSourceId>  
        <dataSourceType>excel</dataSourceType>  
        <updated>2014-04-29T13:37:24.000+02:00</updated>
    </dataprovider>
    <dataprovider> 
        <id>DP4</id>  
        <name>Query 5</name>  
        <dataSourceId>6250</dataSourceId>  
        <dataSourceType>fhsql</dataSourceType>  
        <updated>2014-08-29T08:32:37.000+02:00</updated> 
    </dataprovider> 
</dataproviders>

JSON response:

{"dataproviders":
    {"dataprovider":
        [{"id":"DP0","name":"Query 1","dataSourceId":6187,"dataSourceType":"unv",
            "updated":"2014-04-23T09:08:20.000+02:00"},
         {"id":"DP1","name":"Query 2","dataSourceId":6191,"dataSourceType":"unx",
            "updated":"2014-04-23T09:08:20.000+02:00"},
         {"id":"DP2","name":"Query 3","dataSourceId":6120,"dataSourceType":"bex",
            "updated":"2014-04-23T09:08:20.000+02:00"},
         {"id":"DP3","name":"Query 4","dataSourceId":6641,"dataSourceType":"excel",
            "updated":"2014-04-29T13:37:24.000+02:00"},
         {"id":"DP4","name":"Query 5","dataSourceId":6250,"dataSourceType":"fhsql",
            "updated":"2014-08-29T08:32:37.000+02:00"}]
    }
}