How to Download Fedex Tracking information

[#1]

Has anyone tried downloading FEDEX tracking information in Qlikview.

I am looking to pass the Tracking number through the URL and download data in a table.

[#2 · Accepted solution]

I was able to get some data by following this method. But the response for some reason I am getting is not complete.

1. I installed the Qlik Web connector and got a temporary license from qlik to use General web connector.

2. Selected the connector and used Raw response

3. Method: POST , URL https://ws.fedex.com:443/web-services

4. Signed up at FedEx Developer site and got the Account Number, Meter Number, Key, Unique ID.

5. in the POST/PATCH/PUT parameters added XML data in the following format with the information from Point 4

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v14="http://fedex.com/ws/track/v14">
<soapenv:Header/>
<soapenv:Body>
  <v14:TrackRequest>
   <v14:WebAuthenticationDetail>
    <v14:ParentCredential>
     <v14:Key>****USER KEY****</v14:Key>
     <v14:Password>****PASSWORD***</v14:Password>
    </v14:ParentCredential>

    <v14:UserCredential>
     <v14:Key>*****USER KEY*******</v14:Key>
     <v14:Password>******PASSWORD******</v14:Password>
    </v14:UserCredential>

   </v14:WebAuthenticationDetail>

<v14:ClientDetail>

    <v14:AccountNumber>***ACCOUNT NUMBER****</v14:AccountNumber>

    <v14:MeterNumber>****METER NUMBER****</v14:MeterNumber>

   </v14:ClientDetail>

   <v14:TransactionDetail>
    <v14:CustomerTransactionId>>Track By Number_v14</v14:CustomerTransactionId>
    <v14:Localization>
     <v14:LanguageCode>EN</v14:LanguageCode>
     <v14:LocaleCode>US</v14:LocaleCode>
    </v14:Localization>
   </v14:TransactionDetail>
   <v14:Version>
    <v14:ServiceId>trck</v14:ServiceId>
    <v14:Major>14</v14:Major>
    <v14:Intermediate>0</v14:Intermediate>
    <v14:Minor>0</v14:Minor>
   </v14:Version>

   <v14:SelectionDetails>
    <v14:CarrierCode>FDXE</v14:CarrierCode>
    <v14:PackageIdentifier>
     <v14:Type>TRACKING_NUMBER_OR_DOORTAG</v14:Type>
     <v14:Value>******TRACKING NUMBER*******</v14:Value>
     </v14:PackageIdentifier>

    <v14:ShipmentAccountNumber/>
    <v14:SecureSpodAccount/>
    <v14:Destination>
     <v14:GeographicCoordinates>rates evertitque aequora</v14:GeographicCoordinates>
    </v14:Destination>
   </v14:SelectionDetails>
 
</v14:TrackRequest>
</soapenv:Body>
</soapenv:Envelope>

6. Click on Save Inputs and Run the Table, This will generate a XML Response.

Currently I am getting the response but doesn't give me complete tracking information from FedEx. I am still trying to figure out.

[#3]

The above method worked. to get the complete information I had to modify the XML code.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v14="http://fedex.com/ws/track/v14">
<soapenv:Header/>
<soapenv:Body>
  <v14:TrackRequest>
   <v14:WebAuthenticationDetail>
    <v14:ParentCredential>
     <v14:Key>****USER KEY****</v14:Key>
     <v14:Password>****PASSWORD***</v14:Password>
    </v14:ParentCredential>

    <v14:UserCredential>
     <v14:Key>*****USER KEY*******</v14:Key>
     <v14:Password>******PASSWORD******</v14:Password>
    </v14:UserCredential>

   </v14:WebAuthenticationDetail>

<v14:ClientDetail>

    <v14:AccountNumber>***ACCOUNT NUMBER****</v14:AccountNumber>

    <v14:MeterNumber>****METER NUMBER****</v14:MeterNumber>

   </v14:ClientDetail>

   <v14:TransactionDetail>
    <v14:CustomerTransactionId>>Track By Number_v14</v14:CustomerTransactionId>
    <v14:Localization>
     <v14:LanguageCode>EN</v14:LanguageCode>
     <v14:LocaleCode>US</v14:LocaleCode>
    </v14:Localization>
   </v14:TransactionDetail>
   <v14:Version>
    <v14:ServiceId>trck</v14:ServiceId>
    <v14:Major>14</v14:Major>
    <v14:Intermediate>0</v14:Intermediate>
    <v14:Minor>0</v14:Minor>
   </v14:Version>

   <v14:SelectionDetails>
   
    <v14:PackageIdentifier>
     <v14:Type>TRACKING_NUMBER_OR_DOORTAG</v14:Type>
     <v14:Value>******TRACKING NUMBER*******</v14:Value>
     </v14:PackageIdentifier>

 
   </v14:SelectionDetails>

</v14:TrackRequest>
</soapenv:Body>
</soapenv:Envelope>

[#4]

Also I was able to achieve the samething using Qlikview Rest Connector.