I've been asked to help out on a friend's project. The client is running a nationwide campaign, and when a user clicks on an ad they will be sent to a landing page with a URL like this: https://URL/landing/?loc_physical_ms=1023631. The client wants me to take the location ID (in this case, 1023631), convert it to a geographical location, compare it to a provided JSON list of offices, and put the ID of the office closest to the location ID on the page.
I am new to AdWords, so I'm not sure if this can be done. I know from the LocationCriteria CSV file that 1023631 is Cleveland, but I don't see any ZIP or separate City or State information there that I could use. CSV is probably off the table anyway, as I don't have database access and converting it to JSON would yield an enormous file. If I use the API, can I get postal code or city/state information using the location ID?