tracking fedex API
.
14 replies
-
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
-
@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-integrationsI 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.
-
well if anyone can explain how to duplicate this result it would be great , i have no idea how to work json
-
@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..
-
@Marc,
Here ya go..
ShipIt Code..
-
Thank you!!
will try, let you know.
-
Works great! Further, you can format jason.activities as text and get everything... Thanks Mconneen!
-
@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.. :)
-
can you chare a copy of the DB?
-
ok got working.
-
@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. :)
-
thank you for your help , i am trying to get the carrier result but i am having trouble
thehttp://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 -
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
-
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
- 5 yrs agoLast active
- 14Replies
- 3588Views