Example of exporting a customer in real time
Less than to read
This example illustrates the export of one customer.
SOAP Request
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wss="http://www.adonix.com/WSS" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header/>
<soapenv:Body>
<wss:run soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<callContext xsi:type="wss:CAdxCallContext">
<codeLang xsi:type="xsd:string">ENG</codeLang>
<poolAlias xsi:type="xsd:string">IMPORT-EXPORT</poolAlias>
<poolId xsi:type="xsd:string"/>
<requestConfig xsi:type="xsd:string">
<![CDATA[adxwss.optreturn=JSON&adxwss.beautify=true&adxwss.trace.on=off]]>
</requestConfig>
</callContext>
<publicName xsi:type="xsd:string">AOWSEXPORT</publicName> /** AOWSEXPORT = web service name **/
<inputXml xsi:type="xsd:string">
<![CDATA[{
"GRP1": {
"I_MODEXP": "BPC", /** export template **/
"I_CHRONO": "NO" /** do not use chrono management **/
},
"GRP2": [
{
"I_TCRITERE": "[F:BPC]BPCNUM='NA003'" /** selection criteria **/
}
],
"GRP3": {
"I_EXEC": "REALTIME", /** execute the export immediately **/
"I_RECORDSEP": "|" /** record separator **/
}
}]]>
</inputXml>
</wss:run>
</soapenv:Body>
</soapenv:Envelope>
SOAP Response
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wss="http://www.adonix.com/WSS">
<soapenv:Body>
<wss:runResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<runReturn xsi:type="wss:CAdxResultXml">
<messages xsi:type="soapenc:Array" soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" soapenc:arrayType="wss:CAdxMessage[1]">
<messages href="#id0"/>
</messages>
<resultXml xsi:type="xsd:string">{
"GRP1": {
"I_MODEXP": "BPC",
"I_CHRONO": "NO"
},
"GRP2": [
{
"I_TCRITERE": "[F:BPC]BPCNUM='NA003'"
}
],
"GRP3": {
"I_EXEC": "REALTIME",
"I_RECORDSEP": "|",
"O_FILE": "B;US;NA003;Fun Times Stores;FunTimes;FunTimes;ST001;ST001;CORP;ST003;USD;;;;NA003;NTX;CH30NET;LOCAL;200;222;0;1;;;;;;|A;CORP;2;Corporate;848 S Robertson Blvd;;;60620;Chicago;US;;|A;ST001;1;Corporate;848 S Robertson Blvd;;;60620;Chicago;US;3102752411;|A;ST002;1;Seattle;1084 Madison St;;;98104;SEATTLE;US;;|A;ST003;1;Atlanta;1715 N Brown Rd;;;30043-8119;LAWRENCEVILLE;US;;|A;ST004;1;Baltimore;10901 York Parkway;;;21281;BALTIMORE;US;4107891235;|A;ST005;1;Syracuse;1375 Marshall Parkway;;;13224;SYRACUSE;US;3158894567;|D;ST001;Fun Times - Corporate;;3;;FOB;1;;;;|D;ST002;Fun Times - Seattle;;3;;FOB;1;;;;|D;ST003;Fun Times - Atlanta;;3;;FOB;1;;;;|D;ST004;Fun Times - Baltimore;;3;;FOB;1;;;;|D;ST005;Fun Times - Syracuse;;3;;FOB;1;;;;|",
"O_REQNUM": "0", /** no query number because import was real-time **/
"O_STATUS": "0", /** no web service error **/
"O_MESSA": "" /** no error message **/
}
}</resultXml>
<status xsi:type="xsd:int">1</status>
<technicalInfos xsi:type="wss:CAdxTechnicalInfos">
<busy xsi:type="xsd:boolean">false</busy>
/** ... **/
<traceRequestSize xsi:type="xsd:int">0</traceRequestSize>
</technicalInfos>
</runReturn>
</wss:runResponse>
<multiRef id="id0" soapenc:root="0" soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="wss:CAdxMessage">
<type>1</type> /** The type and message indicate the successful export of one record along with the name of a file containing the exported data. **/
<message>|1 lines exported (Table D:\Sage\X3CLOUD\folders\SEED\tmp\WMAOWS_EXPORT_BPC_XTEST_2249884210.csv)</message>
</multiRef>
</soapenv:Body>
</soapenv:Envelope>