2

I'd like to request a query that includes a single quote '.

http://data.cityofchicago.org/resource/xh8b-g55w.json?$where=license_description="Caterer's Liquor License"&$limit=1

returns

{
"code" : "query.execution.queryTooComplex",
"error" : true,
"message" : "No multi-column conditions are allowed",
"data" : {
"reason" : "validation.multi-column-condition"
  }
}
2

From Socrata Tech Support

The [Socrata SODA 2 API] expects strings to be enclosed in single quotes. You can use double single quotes to escape it within a string.

http://data.cityofchicago.org/resource/xh8b-g55w.json?$where=license_description='Caterer''s Liquor License'&$limit=1

2

Yep, that's exactly what you need to do. Looking at the error message you posted, it looks like you ended up confusing our query parser.

As we improve the SODA query APIs, we'll likely make that interface clearer.

Thanks,

Chris Metcalf

Director of Developer Platform

chris.metcalf (at) socrata.com

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.