Web Scraping - Container Tracking from Searates Website to Excel

[randaubienghoc]

Hi everyone,

As lacking of essential IT knowledge, I am looking for your kind help to make codes for getting data (final destination & ETA estimated time of arrival) from website tracking container numbers SEARATES (Online Container & Freight Tracking System – Searates.com) to Excel.

I have tried method of using GetElementbyID using IE Internet Explorer but this website browser is seems obsolete and useless.

This SERATES website offer API information but it is too complicated for me to understand. I am enclosing container tracking list for your testing. Container Tracking List.xlsx

Hope someone could give me support on this project which is important for my job of logistics.

Thanks in advance.

 

[RoryA]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Web Scraping - Container Tracking from Searates Website to Excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[randaubienghoc]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Web Scraping - Container Tracking from Searates Website to Excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sorry for not mentioning link for cross-posting website. Herein the link: Web Scraping - Container Tracking from Searates Website to Excel
I hope receive your help.

 

[randaubienghoc]

Anyone? I am expecting your kind help on this issue. Thanks. Maybe some advices?

 

[Marc L]

​

Do you have at least your API key ?​

 

[randaubienghoc]

​

Do you have at least your API key ?​

API key? I do not understand how to get API key? ((

 

[Marc L]

​

So contact the website !​

​

Without any API key you must pilot IE under VBA …​