Spaces in the text attribute throw

agrc / masquerade

Disguise UGRC's Web API endpoints as an Esri locator service.

https://github.com/agrc/masquerade#readme

MIT License

1 stars 0 forks source link

Spaces in the text attribute throw #124

Closed steveoh closed 1 year ago

steveoh commented 1 year ago

postgres thinks this is a string search and the quote is unterminated. I wonder if all quotes should be stripped. Double quotes would be considered a column etc so I don't think anything good will come from it.

e.g. /suggest?f=json&text=3000 N MAIN ST, LOGAN'&maxSuggestions=6

stdavis commented 1 year ago

What about for geocoding? Should I strip them for requests going to the web API as well?

steveoh commented 1 year ago

there are 0 roads and 453 address points with a single quote. I think you could strip it