FedEx Package Rate Integration with NetSuite direct integrate by WebServices-CarlZeng
Quick TECHNICAL Note
Reality: UPS only support WebServices integration(or window platform exe application: FedEx Ship Manager® Lite), friendly for JAVA, PHP or C#.
We need to calling UPS SOAP services in NetSuite directly, so there is JSON -> XML for input expected XML parameters and parse API return result XML -> JSON action.
Different from UPS, There is high request for xml’s element order/sequence for FedEx API.
This’s a re-usable framework for intergration with WebServices platform/application.
Registration for the Developer Keys
We will need registration on webside got
Developer Test Key: PFPtfQE9ME1N****
Required for FedEx Web Services for Intra Country Shipping in US and Global
and the Email Box:
Title: Your Developer Test Key Registration is complete
Test Account Information
<spacer.gif>
Test URL: https://wsbeta.fedex.com:443/web-services
Test Password: H6F4kyFrYIQxALXOTbH53****
FedEx Web Services Testing Information:
FedEx Shipping Account Number: **0088000
FedEx Meter Number: ***2012**
On NetSuite Side we are targeting to achieve xml files like the sample:
Example 1:Rate Request
<SOAP-ENV:Envelope xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/“ xmlns:SOAP-
ENC=”http://schemas.xmlsoap.org/soap/encoding/“ xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance“ xmlns:xsd=”http://www.w3.org/2001/XMLSchema“ xmlns=”http://fedex.com/ws/rate/v28">
SOAP-ENV:Body
And all above xml element is dynamically transfered from NetSuite Sales Order data(and also data from location, currency, custom record types, settings), We got those data(in expected order), using the Google Project’s X2JS to convert from JSON to XML.
Next resolve the across domain ajax call by using NetSuite 2.0 API https.post
var response = https.post({
url: ‘https://wsbeta.fedex.com:443/web-services‘,
body: new X2JS().json2xml_str(PostDataObj),
headers: {
“Accept”: “image/gif, image/jpeg, image/pjpeg, text/plain, text/html, */*“,
“Content-Type”: “text/xml”,
“Access-Control-Allow-Origin”: ‘*‘,
}
});
Need to thanks this thread for useful notes: https://stackoverflow.com/questions/62523251/creating-a-http-post-call-for-fedex-web-services
FedEx Webservices Errors
Response Code 400 or 500
- Accross domain Error
- Schema Error
UnrecoverableClientError SchemaErrorvalidation failure for RateRequest Error:cvc-complex-type.2.4.a: Invalid content was found starting with element - Check the XML object sent to FedEx, the order of the element MUST match to the WDSL schema
- Check the XML object elements if there is addtional property
FedEx 404 Unrecoverable ClientError
- Double check the target server url address
- test url: https://wsbeta.fedex.com:443/web-services
- production url: https://ws.fedex.com:443/web-services
Share tools used between XML and JSON
- Testing/xmlTOjson/jsonTOxml: https://peterdaugaardrasmussen.com/json2xml/
- Source Code: https://github.com/abdolence/x2js
- Useful Javascript framework for convention between XML and JSON
- Format XML: https://jsonformatter.org/xml-formatter
- Format JSON: https://www.sojson.com/json/json\_online.html
- XML compare/diff https://extendsclass.com/xml-diff.html
- Be careful, the result of the xml diff is not in element order, the diff not acurate for FedEx test
- Comparing XML files: https://extendsclass.com/xml-diff.html
- POSTMAN simulate and compare the input and output
- Powerful and Easy to use
- XML Formatter https://www.freeformatter.com/xml-formatter.html
- Make XML clean and clear
- JSON Reviewer/Formatter http://jsonviewer.stack.hu
- Clean and clear
- JSON to XML https://www.convertjson.com/json-to-xml.htm
Estimate Rate
- UPS https://www.theupsstore.com/tools/estimate-shipping-cost
- FedEx https://www.fedex.com/en-us/online/rating.html
Integrate with existing UPS integration
While end-use switching shipping carries, we need to clean up the backend package list data and rebuild for current shipping carrier, since UPS and FedEx are using DIFFERENT formating and propertys.