DataWarehouse
Click here for a complete list of operations.
GetFLTableColumns
Get Datawarehouse columns by table name
Test
The test form is only available for requests from the local machine.SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
POST /ecomm/DataWarehouse.asmx HTTP/1.1 Host: ws.euromsg.com Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://ws.euromsg.com/datawarehouse/GetFLTableColumns" <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetFLTableColumns xmlns="http://ws.euromsg.com/datawarehouse"> <ServiceTicket>string</ServiceTicket> <DwTableName>string</DwTableName> </GetFLTableColumns> </soap:Body> </soap:Envelope>
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetFLTableColumnsResponse xmlns="http://ws.euromsg.com/datawarehouse"> <GetFLTableColumnsResult /> <columns> <DatawarehouseColumn> <ColumnName>string</ColumnName> <ColumnType>Alphanumeric or Combo or Date or Integer</ColumnType> <Visible>boolean</Visible> <Required>boolean</Required> <ColumnTypeDetail>string</ColumnTypeDetail> </DatawarehouseColumn> <DatawarehouseColumn> <ColumnName>string</ColumnName> <ColumnType>Alphanumeric or Combo or Date or Integer</ColumnType> <Visible>boolean</Visible> <Required>boolean</Required> <ColumnTypeDetail>string</ColumnTypeDetail> </DatawarehouseColumn> </columns> </GetFLTableColumnsResponse> </soap:Body> </soap:Envelope>
SOAP 1.2
The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.
POST /ecomm/DataWarehouse.asmx HTTP/1.1 Host: ws.euromsg.com Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <GetFLTableColumns xmlns="http://ws.euromsg.com/datawarehouse"> <ServiceTicket>string</ServiceTicket> <DwTableName>string</DwTableName> </GetFLTableColumns> </soap12:Body> </soap12:Envelope>
HTTP/1.1 200 OK Content-Type: application/soap+xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"> <soap12:Body> <GetFLTableColumnsResponse xmlns="http://ws.euromsg.com/datawarehouse"> <GetFLTableColumnsResult /> <columns> <DatawarehouseColumn> <ColumnName>string</ColumnName> <ColumnType>Alphanumeric or Combo or Date or Integer</ColumnType> <Visible>boolean</Visible> <Required>boolean</Required> <ColumnTypeDetail>string</ColumnTypeDetail> </DatawarehouseColumn> <DatawarehouseColumn> <ColumnName>string</ColumnName> <ColumnType>Alphanumeric or Combo or Date or Integer</ColumnType> <Visible>boolean</Visible> <Required>boolean</Required> <ColumnTypeDetail>string</ColumnTypeDetail> </DatawarehouseColumn> </columns> </GetFLTableColumnsResponse> </soap12:Body> </soap12:Envelope>