To get details from Shipping Partner.

AppSheet AppSheet Q&A
1

Dear friends,

I have a need recently. I have developed an app which manages parcel shipping and courier outward records.

Shipping companies like FedEx, DTDC , India post are providing API to get Consignment status like In shipping , Out of Delivery, Delivered etc.

Those companies will be giving Consignment number /docket number etc which is used for tracking.

  1. Is it possible to pull details from third-party sites ?

  2. Is it chargeable under app sheet plan ?

Current position in my app

  1. I have a table called consignments

  2. It has column called Consignment number which is used for tracking the consignment .

In simple words … I am planning to track and get & fed the consignment details to my appsheet app by using automation bot or action instead of doing it from shipper site manually.

Here they have explained how get consignment status from India post.

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://cept.gov.in/apiintegration/pdf/DOP_BulkCustomerIntegration_v8_1.pdf&ved=2ahUKEwj1482Qjd-CAxUtfGwGHfkqBuEQFnoECAwQAQ&usg=AOvVaw0p-1gNeco-aBNGK5RwBU

This is to get serviceable area by pincode : -

http://www.postalpincode.in/Api-Details

I request all colleagues to help me in completing this issue.

1 Like
2

I believe you can create a bot to Call a Script which calls the API and also use the response to update the status column.

https://support.google.com/appsheet/answer/11997142?hl=en

1 Like
3

Without Appscript is not possible?

1 Like
4

Is it possible through Web hook ?

1 Like
5

Unfortunately I am not knowledgeable enough to answer your question. Let’s hope someone else can help you here..

1 Like
6

@Suvrutt_Gurjar , @AleksiAlkio @jyothis_m @MultiTech @SkrOYC @Rifad

I request you to help me with this.

1 Like
7

You can for sure do what you’re wanting, but it will require you to make use of scripts that interact with the external APIs.

  • There will be some tricky fiddly bits to get figured out, but all and all it’s possible to accomplish what you want.
  • The hardest part will be in ensuring that all the numbers are 100% exact; this can be tricky sometimes, and you’ll easily get to like 90% - but that last 10% is the make or break. Once you figure out all these fiddly bits though, you’ll have a smooth running system.

To get started:

  • Start looking into how to make a google apps script to interact with the API you want.

    • If I were you, I’d just get the documentation from these api’s and feed it to Appster - or just vanilla GPT4 - telling it what you need the script to do. You can then back and forth with it while you test and refine to get everything working.

  • Get a simple bot up and running for you to test how to call a script and get a response.

    • You could make a very simple script that simple returns a text value, and call this script through a bot. This would allow you to see how to go about getting a script integrated with your bot, and how to handle the return values.
    • You can see some of the technical stuff in my OpenAi in AppSheet series; there’s a script you call that sends you prompt to the OpenAi server and returns the answer. So you could find a lot of the 1, 2, 3 of how to set this up through these videos.
    • https://www.youtube.com/playlist?list=PLo4qc7daF3rfQdy21Af91aoebPwFZ6pWD

It will be rather technical, with a lot of fiddly bits in the middle to get right; but with Ai it will be MUCH simpler than you’re thinking. :robot: ? :flexed_biceps:

I asked Appster what it thought, and it has a pretty good high level overview