CommandWebService
Click here for a complete list of operations.
getODBCMetaData
Get ODBC driver meta data. Arguments are the Login token and the space Id.
SOAP
The following is a sample SOAP request and response. The placeholders shown need to be replaced with actual values.
Request
POST /CommandWebService.asmx HTTP/1.1 Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://www.birst.com/getODBCMetaData" <?xml version="1.0" encoding="utf-8"?> <s:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Body> <getODBCMetaData xmlns="http://www.birst.com/"> <token>string</token> <spaceID>string</spaceID> </getODBCMetaData> </s:Body> </s:Envelope>
Response
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <getODBCMetaDataResponse xmlns="http://www.birst.com/"> <getODBCMetaDataResult> <tables> <ODBCTableResult> <tableName>string</tableName> <isFact>boolean</isFact> <columns> <ODBCColumnResult> <columnName>string</columnName> <birstColumnName>string</birstColumnName> <dataType>int</dataType> <width>int</width> <aggsSupported> <string>string</string> </aggsSupported> <key>int</key> <isFact>boolean</isFact> </ODBCColumnResult> </columns> </ODBCTableResult> </tables> <relationships> <ODBCRelationshipResult> <primaryTable>string</primaryTable> <foreignTable>string</foreignTable> <primaryTableColumn>string</primaryTableColumn> <foreignTableColumn>string</foreignTableColumn> </ODBCRelationshipResult> </relationships> <errorCode>int</errorCode> <errorMessage>string</errorMessage> </getODBCMetaDataResult> </getODBCMetaDataResponse> </s:Body> </s:Envelope>