The zipcode is stripping leading zeros

[mclejar]

Hello,

In a recent update it seems that you have broken the zipcode field. Postal codes that start with 0 are missing the leading 0's. If we query agains postal code we get 0 results.

For example this restaurant in Boston has this for data:

{ "total_entries": 1, "per_page": 25, "current_page": 1, "restaurants": [ { "id": 106855, "name": "Nebo", "address": "520 Atlantic Ave", "city": "Boston", "state": "MA", "area": "Boston / New England", "postal_code": "2210", "country": "US", "phone": "6177236326", "lat": 42.353772, "lng": -71.053364, "price": 2, "reserve_url": "http://www.opentable.com/single.aspx?rid=106855", "mobile_reserve_url": "http://mobile.opentable.com/opentable/?restId=106855", "image_url": "https://www.opentable.com/img/restimages/106855.jpg" } ] }

You can see that the postal_code is "2210" when it should be "02210"

Therefore the following query returns 0 results:

https://opentable.herokuapp.com/api/restaurants?name=Nebo&address=520%20Atlantic%20Ave&city=Boston&state=MA&zip=02210

If we take off the zip param it works, but we have code that contains the zip right now.

Thanks!

[sosedoff]

Fixed.

[sosedoff]

There was an issue with XLS->CSV conversion, nothing to do with code.

[mclejar]

Thanks! Figured it was something like that. Actually one of the guys here called that exactly.