WebService
单击此处,获取完整的操作列表。
Get_DataTable_Data
获取表数据:sql_str SQL语句,p_tns_name TNS名称(ERP、NEW_ERP、PLM、SUB、SCM)
测试
若要使用 HTTP POST 协议对操作进行测试,请单击“调用”按钮。SOAP 1.1
以下是 SOAP 1.2 请求和响应示例。所显示的占位符需替换为实际值。
POST /WebService.asmx HTTP/1.1 Host: web.seagullgroup.cn Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://seagull_weixin/Get_DataTable_Data" <?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> <Get_DataTable_Data xmlns="http://seagull_weixin/"> <sql_str>string</sql_str> <p_tns_name>string</p_tns_name> </Get_DataTable_Data> </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> <Get_DataTable_DataResponse xmlns="http://seagull_weixin/"> <Get_DataTable_DataResult>xmlxml</Get_DataTable_DataResult> </Get_DataTable_DataResponse> </soap:Body> </soap:Envelope>
SOAP 1.2
以下是 SOAP 1.2 请求和响应示例。所显示的占位符需替换为实际值。
POST /WebService.asmx HTTP/1.1 Host: web.seagullgroup.cn 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> <Get_DataTable_Data xmlns="http://seagull_weixin/"> <sql_str>string</sql_str> <p_tns_name>string</p_tns_name> </Get_DataTable_Data> </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> <Get_DataTable_DataResponse xmlns="http://seagull_weixin/"> <Get_DataTable_DataResult>xmlxml</Get_DataTable_DataResult> </Get_DataTable_DataResponse> </soap12:Body> </soap12:Envelope>
HTTP GET
以下是 HTTP GET 请求和响应示例。所显示的占位符需替换为实际值。
GET /WebService.asmx/Get_DataTable_Data?sql_str=string&p_tns_name=string HTTP/1.1 Host: web.seagullgroup.cn
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <DataTable xmlns="http://seagull_weixin/">xmlxml</DataTable>
HTTP POST
以下是 HTTP POST 请求和响应示例。所显示的占位符需替换为实际值。
POST /WebService.asmx/Get_DataTable_Data HTTP/1.1 Host: web.seagullgroup.cn Content-Type: application/x-www-form-urlencoded Content-Length: length sql_str=string&p_tns_name=string
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <DataTable xmlns="http://seagull_weixin/">xmlxml</DataTable>