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

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






XXXXXX
XXXXXX


XXXXXX
XXXXXX



XXXXXX
XXXXXX


RateRequest_v28


crs
28
0
0


2020-02-25T12:34:56-06:00
REGULAR_PICKUP
PRIORITY_OVERNIGHT
FEDEX_BOX


LB
20.0


XXXXXX

FedEx-WAPI
XXXXXX



SN2000 Test Meter 8
10 Fedex Parkway
AUSTIN
TX
XXXXXX
US



XXXXXX

Recipient Contact
XXXXXX



Recipient Address Line 1
Recipient Address Line 2
Collierville
TN
XXXXXX
US



SENDER


XXXXXX

BUSINESS_STATE
123456




LIST
1

1
1
1

LB
20.0


12
12
12
IN


XXXXXX
XXXXXX
12
ContentDescription




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
    SchemaError
    validation 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.


评论

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注