1、EF OA的接口测试区http://erp2.waichi.com/web/ws/r/aws_efsrv_toptest?wsdl正式区http://erp2.waichi.com/web/ws/r/aws_efsrv?wsdl2、ERP日常接口测试区http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl正式区http://erp.waichi.com/web/ws/r/aws_ttsrv2?wsdl3、字段说明usererp账号passworderp的密码application呼叫端系統代號后台代码g_access.application 可以获取source呼叫端來源 IP or HostOrganization: 填写ERP运营中心代号languagezh_tw(繁體) / zh_cn(簡體) / en_us(英文)本页目录1、单表查询1.1、ima_file1.2、smy_file1.3、pmc_file1.4、gen_file1.5、gem_file1.6、gec_file1.7、azi_file1.8、mse_file2、多表查询pja_file(一) 对 pjb_file多3、自定义查询单表查询使用Apipost工具进行http接口访问ima_file源代码注册服务接口案例/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4glGetItemData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_item_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetItemDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvalueima01 FFB-WS8762NNN-05//Record/ParameterDocument //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.4glGetMFGDocument接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_mfg_document.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetMFGDocumentRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvalue11/Fieldnamesysvalueasf/Fieldnamekindvalue1//Record/ParameterDocument //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.4glGetSupplierData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_supplier_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetSupplierDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvaluepmc01 LIKE WC-%//Record/ParameterDocument //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.4glGetEmployeeData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_employee_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetEmployeeDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvaluegen01 LIKE BL076%//Record/ParameterDocument //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.4glGetEmployeeData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_department_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetDepartmentDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvaluegem01 LIKE NFC%//Record/ParameterDocument //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.4glGetTaxTypeData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_tax_type_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetTaxTypeDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvaluegec01 LIKE T1%//Record/ParameterDocument //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.4glGetCurrencyData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_currency_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetCurrencyDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvalueazi01 LIKE %B%//Record/ParameterDocument //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.4glGetBrandData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_brand_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetBrandDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvaluemse01 LIKE % //Record/ParameterDocument //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.4glGetProjectWBSData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_get_project_wbs_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:GetProjectWBSDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnameconditionvaluepja012015ITEM06 AND pjb020043-0001-0002//Record/ParameterDocument //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.4glCustomizeQueryData接口案例代码/u1/topprod/tiptop/aws/4gl/aws_customize_query_data.4gl请求参数urlhttp://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl请求方式POSTHeaderContent-Type:text/xml;charsetUTF-8 SOAPAction:- Body - raw 选xmlsoapenv:Envelope xmlns:soapenvhttp://schemas.xmlsoap.org/soap/envelope/xmlns:tiphttp://www.dsc.com.tw/tiptop/TIPTOPServiceGateWaysoapenv:Header/soapenv:Bodytip:CustomizeQueryDataRequesttip:request![CDATA[RequestAccessAuthenticationuserxxxpasswordxxxx/Connectionapplicationtiptopsourceerp2.waichi.com/OrganizationnameBLPROD/Localelanguagezh_tw//AccessRequestContentParameterRecordFieldnamesetFieldsvaluepmn33,pmn01,pmn02,pmn09,pmn37,pmnud10/FieldnamesetSqlvalueSELECT pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10 FROM pmn_file WHERE pmn01 VFU22-22100017 AND pmn02 IN (1,2,3) /FieldnamesetTypevalueSingle//Record/ParameterDocument //RequestContent/Request]]/tip:request/tip:CustomizeQueryDataRequest/soapenv:Body/soapenv:Envelope