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

优质文章学习记录

— 9 min read
  • 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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="condition"value="1=1" /><Field name="sys"value="asf" /><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="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><Authentication user="xxx"password="xxxx" /><Connection application="tiptop"source="erp2.waichi.com" /><Organization name="BLPROD" /><Locale language="zh_tw" /></Access><RequestContent><Parameter><Record><Field name="setFields"value="pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10" /><Field name="setSql"value="SELECT pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10 FROM pmn_file WHERE pmn01 ='VFU22-22100017' AND pmn02 IN ('1','2','3') " /><Field name="setType"value="Single" /></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:CustomizeQueryDataRequest></soapenv:Body></soapenv:Envelope>
Could not load content