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>