WebService


单击此处，获取完整的操作列表。

Get_DataTable_Data2

获取表数据带表名：sql_str SQL语句,p_table_name 表名,p_tns_name TNS名称(ERP、NEW_ERP、PLM、SUB、SCM)

测试

若要使用 HTTP POST 协议对操作进行测试，请单击“调用”按钮。
参数 值
sql_str:
p_table_name:
p_tns_name:

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_Data2"

<?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_Data2 xmlns="http://seagull_weixin/">
      <sql_str>string</sql_str>
      <p_table_name>string</p_table_name>
      <p_tns_name>string</p_tns_name>
    </Get_DataTable_Data2>
  </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_Data2Response xmlns="http://seagull_weixin/">
      <Get_DataTable_Data2Result>xmlxml</Get_DataTable_Data2Result>
    </Get_DataTable_Data2Response>
  </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_Data2 xmlns="http://seagull_weixin/">
      <sql_str>string</sql_str>
      <p_table_name>string</p_table_name>
      <p_tns_name>string</p_tns_name>
    </Get_DataTable_Data2>
  </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_Data2Response xmlns="http://seagull_weixin/">
      <Get_DataTable_Data2Result>xmlxml</Get_DataTable_Data2Result>
    </Get_DataTable_Data2Response>
  </soap12:Body>
</soap12:Envelope>

HTTP GET

以下是 HTTP GET 请求和响应示例。所显示的占位符需替换为实际值。

GET /WebService.asmx/Get_DataTable_Data2?sql_str=string&p_table_name=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_Data2 HTTP/1.1
Host: web.seagullgroup.cn
Content-Type: application/x-www-form-urlencoded
Content-Length: length

sql_str=string&p_table_name=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>