Template using USPS API to retrieve package status of shipments

[jaihawk8]

Has anyone developed a template that will use the USPS' API to complete the shipping status of packages?

I'm looking for something simple, where I paste my shipments into an Excel File that looks like this, and then it retrieves the shipping status:

Book2
	A	B	C
1	Date	Tracking Number	Shipping Status
2	3/27/2024	92748909901146543485257651
3
4
Sheet1

 

[John_w]

See if you can adapt the code here, which is for a different USPS API:

Can you do an API call in Excel using VBA?

Hello, Is there a way to do an API call in excel using VBA? or is there another non-macro way to do it? I am trying to use the United States Post Office's API to get the full nine digit zip code for addresses. The API requires a username and password which I have. I have linked to the technical...

www.mrexcel.com

You would need to change the XML string and specify the tracking API in the URL.