7.104 对接接口获取xml

登录

本帖最后由 trueboy 于 2022-7-11 00:06 编辑

老系统,只支持xml想用活字格来实现传参数给接口, 接口返回xml报文,解析报文,将字段存储到某表里.请给一个详细的设置步骤,比如发送http命令,是怎么设置的?谢谢,

附加为客户提供的接口信息,

sfb01 varchar2(20) /*工单号*/
---------------------------------------------------------------------------------------------------------------------
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay">
<soapenv:Header/>
<soapenv:Body>
<tip:getasfi301xRequest>
<tip:request> <Request>
<Access>
<Authentication user ="tiptop" password="" />
<Connection application ="ERP" source="192.168.5.11" />
<Organization name ="KSHY" />
<Locale language ="zh_cn" />
</Access>
<RequestContent>
<Parameter>
<Record>
<Field name ="workorder" value="M23-KSHY22070002" />
</Record>
</Parameter>
<Document/>
</RequestContent>
</Request>
</tip:request>
</tip:getasfi301xRequest>
</soapenv:Body>
</soapenv:Envelope>

复制代码

sfb01 varchar2(20) /*工单号*/
sfb102 varchar2(10) /*机台*/
sfb05 varchar2(40) /*料号*/
ima02 varchar2(120) /*品名*/
ima021 varchar2(120) /*规格*/
sfb08 number(15,3) /*数量*/
sfbud03 varchar2(20) /*模具编号*/
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<fjs1:getasfi301xResponse xmlns:fjs1="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay">
<fjs1:response><![CDATA[<Response>
<Execution>
<Status code="0" sqlcode="0" description=""/>
</Execution>
<ResponseContent>
<Parameter/>
<Document>
<RecordSet id="1">
<Master name="sfb_list">
<Record>
<Field name="workorder" value="M23-KSHY22070002"/>
<Field name="machine_no" value="1029"/>
<Field name="product_no" value="5S-00027-0219-0"/>
<Field name="product_name" value="端子"/>
<Field name="specification" value="9453T-10A-NP"/>
<Field name="qty" value="27500.000"/>
<Field name="mould" value="TS00027-020-1AHB"/>
</Record>
</Master>
</RecordSet>
</Document>
</ResponseContent>
</Response>]]></fjs1:response>
</fjs1:getasfi301xResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>