jeudi 13 août 2015

Large soql queries(over 5000 charcter length) to socrata is not supporting

I am using SodaClient to get information from a private data set in Socrata using the following code.

var records = (dynamic)null;

string searchCondition = "column1='something'AND (column2='something' OR 'somethingelse') ";

var clientExport = new SodaClient("host name", "app token", "username","password");

var dataset = clientExport.GetResource<modelname>("resourceid");
var offset = 0;
var limit = 1000;

var soql = new SoqlQuery().Where(searchCondition).Offset(offset).Limit(limit);
records = dataset.Query<modelname>(soql).ToList();

return records;

The problem is that sometimes the 'searchCondition ' can be very large say over 5000 characters, then the Sodaclient is returning error.

How can I send large soql queries to socrata? I also tried to get information using restful calls httpclient method but it also showing errors like.

An error occurred while sending the request. The server committed a protocol violation. Section=ResponseStatusLine



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire