FedEx Package Rate Integration with NetSuite direct integrate by WebServices

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>
      <RateRequest>
         <WebAuthenticationDetail>
            <ParentCredential>
               <Key>XXXXXX</Key>
               <Password>XXXXXX</Password>
            </ParentCredential>
            <UserCredential>
               <Key>XXXXXX</Key>
               <Password>XXXXXX</Password>
            </UserCredential>
         </WebAuthenticationDetail>
         <ClientDetail>
            <AccountNumber>XXXXXX</AccountNumber>
            <MeterNumber>XXXXXX</MeterNumber>
         </ClientDetail>
         <TransactionDetail>
            <CustomerTransactionId>RateRequest_v28</CustomerTransactionId>
         </TransactionDetail>
         <Version>
            <ServiceId>crs</ServiceId>
            <Major>28</Major>
            <Intermediate>0</Intermediate>
            <Minor>0</Minor>
         </Version>
         <RequestedShipment>
            <ShipTimestamp>2020-02-25T12:34:56-06:00</ShipTimestamp>
            <DropoffType>REGULAR_PICKUP</DropoffType>
            <ServiceType>PRIORITY_OVERNIGHT</ServiceType>
            <PackagingType>FEDEX_BOX</PackagingType>

<TotalWeight>
   <Units>LB</Units>
   <Value>20.0</Value>
</TotalWeight>
<Shipper>
   <AccountNumber>XXXXXX</AccountNumber>
   <Contact>
      <CompanyName>FedEx-WAPI</CompanyName>
      <PhoneNumber>XXXXXX</PhoneNumber>
   </Contact>
   <Address>
      <StreetLines>SN2000 Test Meter 8</StreetLines>
      <StreetLines>10 Fedex Parkway</StreetLines>
      <City>AUSTIN</City>
      <StateOrProvinceCode>TX</StateOrProvinceCode>
      <PostalCode>XXXXXX</PostalCode>
      <CountryCode>US</CountryCode>
   </Address>
</Shipper>
<Recipient>
   <AccountNumber>XXXXXX</AccountNumber>
   <Contact>
      <PersonName>Recipient Contact</PersonName>
      <PhoneNumber>XXXXXX</PhoneNumber>
   </Contact>
   <Address>
      <StreetLines>Recipient Address Line 1</StreetLines>
      <StreetLines>Recipient Address Line 2</StreetLines>
      <City>Collierville</City>
      <StateOrProvinceCode>TN</StateOrProvinceCode>
      <PostalCode>XXXXXX</PostalCode>
      <CountryCode>US</CountryCode>
   </Address>
</Recipient>
<ShippingChargesPayment>
   <PaymentType>SENDER</PaymentType>
   <Payor>
      <ResponsibleParty>
         <AccountNumber>XXXXXX</AccountNumber>
         <Tins>
            <TinType>BUSINESS_STATE</TinType>
            <Number>123456</Number>
         </Tins>
      </ResponsibleParty>
   </Payor>
</ShippingChargesPayment>
<RateRequestTypes>LIST</RateRequestTypes>
<PackageCount>1</PackageCount>
<RequestedPackageLineItems>
   <SequenceNumber>1</SequenceNumber>
   <GroupNumber>1</GroupNumber>
   <GroupPackageCount>1</GroupPackageCount>
   <Weight>
      <Units>LB</Units>
      <Value>20.0</Value>
   </Weight>
   <Dimensions>
      <Length>12</Length>
      <Width>12</Width>
      <Height>12</Height>
      <Units>IN</Units>
   </Dimensions>
   <ContentRecords>
      <PartNumber>XXXXXX</PartNumber>
<ItemNumber>XXXXXX</ItemNumber>
                  <ReceivedQuantity>12</ReceivedQuantity>
                  <Description>ContentDescription</Description>
               </ContentRecords>
            </RequestedPackageLineItems>
         </RequestedShipment>
      </RateRequest>
   </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 

• <cause>UnrecoverableClientError</cause>
  <code>SchemaError</code>
  <desc>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.