08.06.01.tiptop webserver接口篇（收集接口:查询接口）

• 1、EF OA的接口
  • 测试区：http://erp2.waichi.com/web/ws/r/aws_efsrv_toptest?wsdl
  • 正式区：http://erp2.waichi.com/web/ws/r/aws_efsrv?wsdl
• 2、ERP日常接口
  • 测试区：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 正式区：http://erp.waichi.com/web/ws/r/aws_ttsrv2?wsdl
• 3、字段说明
  • user：erp账号
  • password：erp的密码
  • application：呼叫端系統代號
    • 后台代码：g_access.application 可以获取
  • source：呼叫端來源 IP or Host
  • Organization: 填写ERP运营中心代号
  • language：zh_tw(繁體) / zh_cn(簡體) / en_us(英文)

本页目录：

• 1、单表查询
  • 1.1、ima_file
  • 1.2、smy_file
  • 1.3、pmc_file
  • 1.4、gen_file
  • 1.5、gem_file
  • 1.6、gec_file
  • 1.7、azi_file
  • 1.8、mse_file
• 2、多表查询
  • pja_file(一) 对 pjb_file（多）
• 3、自定义查询

单表查询

• 使用Apipost工具进行http接口访问

ima_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetItemData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_item_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetItemDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="ima01 = 'FFB-WS8762NNN-05'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetItemDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

smy_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetMFGDocument接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_mfg_document.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetMFGDocumentRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="1=1"/><Fieldname="sys"value="asf"/><Fieldname="kind"value="1"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetMFGDocumentRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

pmc_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetSupplierData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_supplier_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetSupplierDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="pmc01 LIKE 'WC-%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetSupplierDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

gen_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetEmployeeData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_employee_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetEmployeeDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="gen01 LIKE 'BL076%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetEmployeeDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

gem_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetEmployeeData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_department_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetDepartmentDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="gem01 LIKE 'NFC%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetDepartmentDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

gec_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetTaxTypeData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_tax_type_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetTaxTypeDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="gec01 LIKE 'T1%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetTaxTypeDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

azi_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetCurrencyData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_currency_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetCurrencyDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="azi01 LIKE '%B%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetCurrencyDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

mse_file

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetBrandData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_brand_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetBrandDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="mse01 LIKE '%' "/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetBrandDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

多表查询

pja_file(一) 对 pjb_file（多）

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • GetProjectWBSData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_project_wbs_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetProjectWBSDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="pja01='2015ITEM06' AND pjb02='0043-0001-0002'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetProjectWBSDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

自定义查询

• 源代码：
  • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
  • CustomizeQueryData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_customize_query_data.4gl
• 请求参数
  • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
  • 请求方式：POST
  • Header

Content-Type:text/xml;charset=UTF-8 SOAPAction:""

- Body - raw 选xml

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:CustomizeQueryDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="setFields"value="pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10"/><Fieldname="setSql"value="SELECT pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10 FROM pmn_file WHERE pmn01 ='VFU22-22100017' AND pmn02 IN ('1','2','3') "/><Fieldname="setType"value="Single"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:CustomizeQueryDataRequest></soapenv:Body></soapenv:Envelope>