USDepartmentofLabor / Developer

Developer.dol.gov
6 stars 6 forks source link

DOL API is throwing an error "The URI you submitted has disallowed characters." when we are trying to call the API by filtering on the columns #154

Closed pricingmodel closed 2 years ago

pricingmodel commented 2 years ago

DOL API is throwing an error "The URI you submitted has disallowed characters." when we are trying to call the API by filtering on the columns

Request: https://data.dol.gov/get/inspection/limit/200/filter_column/SITE_ADDRESS=3300 EDISON WAY:SITE_CITY=FREMONT:SITE_STATE=CA:SITE_ZIP=94538

Please note this was working couple of weeks ago and we noticed this issue just today (06/02)

kgrabhorn-dol commented 2 years ago

@pricingmodel, we are analyzing the issue you reported and will provide a response by the end of the day. Thank you.

kgrabhorn-dol commented 2 years ago

@pricingmodel, thank you for reporting the issue. It has been resolved and your query provides results once again. Thank you.

pricingmodel commented 2 years ago

Thank You @kgrabhorn-dol. We are now seeing proper responses from the API

pricingmodel commented 2 years ago

@kgrabhorn-dol : We see that the issue is resolved but the filtering is not happening. For example the below request is returning the results that do not match the search criteria

https://data.dol.gov/get/inspection/limit/200/filter_column/ESTAB_NAME=LEE'S IMPERIAL WELDING INC:SITE_ADDRESS=3300 EDISON WAY:SITE_CITY=FREMONTSITE_STATE=CA:SITE_ZIP=94538

Could you please take a look at the issue.

pricingmodel commented 2 years ago

@kgrabhorn-dol : Could you please take a look at the above issue

kgrabhorn-dol commented 2 years ago

@pricingmodel, our team has analyzed this issue and are preparing to release an update to our code. I will post an update here once it is ready for you to use. Thank you, @kgrabhorn-dol

kgrabhorn-dol commented 2 years ago

The code for APIv2 was updated. The reported issue is fixed with this update. I'll keep this issue open for a couple of days for you to have an opportunity to verify. Thank you, @kgrabhorn-dol