Thanks for the heads up on the newer https://postalpro.usps.com/ZIP_Locale_Detail file. I converted my script over to being a Python script that uses ZIP_Locale_Detail.xlsx as the source and doesn't require API access anymore.

My new file contains all of the ZIP + city/state combo from that file now.