0

tracking fedex API

.

14 replies

null
    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    How can i get a automatic stas=tus from fedex on a etracking number that is in the system

    i have seen it work in google sheets with json

    here is a screen shot and video link https://www.youtube.com/watch?v=3-OqIpDx2IQ

    how can i duplicate this result in NINOX i just ned the status of delivery

    Capture trk

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Marc... Great use case..   Doing a quick App search on Zapier .. I did not see FedEx.. however, I did find this.. 
    https://zapier.com/blog/updates/1637/shipcloud-integrations

    I also see that FedEx has a developer API.. 

    https://www.fedex.com/en-us/developer.html

    and a quick GTS (google that sh*t) yielded 

    https://www.youtube.com/watch?v=3-OqIpDx2IQ

    So.. it certainly does seem possible. 

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    well if anyone can explain how to duplicate this result it would be great , i have no idea how to work json

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Marc.. 

    It seems that your referenced example is using https://www.npmjs.com/package/shipit .  

    This reviews how to use the http functions..  https://ninoxdb.de/en/manual/api/http-calls

    Support also hosts a weekly webinar covering integrations.. You can register here  https://ninoxdb.de/en/webinar

    If you look in the ENglish Webinar.. there are a few examples..   If you look at 36_Document_Database_Structure.. it shows an example of using the Ninox REST/API to discover the strucgture of your Ninox Cloud / Team Database..  Once you figure out the http calls.. Ninox does a pretty good job and parsing the JSON object for you .. so you can simple refer to the object.. You do have to know the expected field names / types.. etc.. 

    If I get some time later.. I will play with the provided example..    

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Marc, 
    Here ya go.. 

    shipIT

    ShipIt Code.. 

    shipItCode

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    Thank you!!

    will try, let you know.

    • mpdickens
    • 4 yrs ago
    • Reported - view

    Works great! Further, you can format jason.activities as text and get everything... Thanks Mconneen!

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @mpdickens ... You do not have to "format" it.. It is already a json object.. Just iterate over it.. I was too lazy in the example.. :) 

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    can you chare a copy of the DB?

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    ok got working.

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Marc.. 

    Very good!   Do not tell people how easy it is.. Then they will not want to hire me to code / configure it for them. :) 

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    thank you for your help , i am trying to get the carrier result but i am having trouble 
    the

    http://shipit-api.herokuapp.com/api/guess/ "TRACKING-NUMBER" it would return the carrier is such format ["fedex"] but i do not know how to get it into my carrier field , i am not getting somthing right

     

    i used the same idea for the code
    let t := this;
    let response := do as server
    http("GET", t.'URL 2')
    end;
    if response.error then
    alert("Error" + text(response.error))
    else
    let json := response.result;
    t.(carrier := text(json))??????????????
    end

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    oh sorry , i used URL field insted of formula that combines the url with the tracking number field so i am getting the result in this format  ["fedex"] so now i just have to strip the sides so that i can use a formula field insted of the first url that would auto combine the url and carrier to get the results. that way all needed is to fill the tracking number field

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    ok got that done , any way for the status to show the activity detail of the most recent activity instead of a 4 it should shoe delivered 

    in google sheets it is done like this

    =importjson(join("","http://shipit-api.herokuapp.com/api/carriers/",B5,"/",A5),"activities/0/details")

Content aside

  • 4 yrs agoLast active
  • 14Replies
  • 3573Views