topic Re: Problem querydata with newline (\ and newline, tab ect) in ArcGIS REST APIs and Services Questions

Problem querydata with newline (\ and newline, tab ect)

nicogis — Thu, 29 Dec 2011 13:49:52 GMT

I have a value in a field string example "Test /n Test1...".
If I publish a mapserver and I do a request rest query with response type json: it returns "Test //n Test1..." but from json.org for newline in string I use /n. In rest esri uses QueryData because I have tried with this method and I have same response but if I use IRecordset I have no problem.


ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Desktop);
 IRecordSet pNewRs  = new RecordSet();
 IRecordSetInit prsInit = pNewRs as IRecordSetInit;

 IFields pFields = new Fields();
 IFieldsEdit pFieldsEdit = pFields as IFieldsEdit;
 pFieldsEdit.FieldCount_2 = 2;

 IField pField = new Field();
 IFieldEdit pFieldEdit = pField as IFieldEdit;
 pFieldEdit.Name_2 = "Type";
 pFieldEdit.Type_2 = esriFieldType.esriFieldTypeString;
 pFieldEdit.Length_2 = 50;
 pFieldsEdit.set_Field(0,pField);

 pField = new Field();
 pFieldEdit = pField as IFieldEdit;

 pFieldEdit.Name_2 = "Area";
 pFieldEdit.Type_2 = esriFieldType.esriFieldTypeDouble;
 pFieldsEdit.set_Field(1,pField);

 prsInit.CreateTable(pFields);

 ICursor pIC = prsInit.Insert();
 IRowBuffer pRowBuf = prsInit.CreateRowBuffer();

 
 pRowBuf.set_Value(0, "Test /n Test1");
 pRowBuf.set_Value(1, 10.2);
 pIC.InsertRow(pRowBuf);
 

 byte[] fs = Conversion.ToJson(pNewRs);
 using (System.IO.FileStream f = new System.IO.FileStream(@"c:\test.txt", System.IO.FileMode.Create))
 {
  f.Write(fs, 0, fs.Length);
  f.Flush();
  f.Close();
 }

I have "Test \n Test1" in test.txt:

{"displayFieldName":"","fieldAliases":{"Type":"Type","Area":"Area"},"fields":[{"name":"Type","type":"esriFieldTypeString","alias":"Type","length":50},{"name":"Area","type":"esriFieldTypeDouble","alias":"Area"}],"features":[{"attributes":{"Type":"Test \n Test1","Area":10.2}}]}

Re: Problem querydata with newline (\ and newline, tab ect)

RaviNarayanan — Tue, 03 Jan 2012 15:48:32 GMT

The escape character in json is backslash (\). I see that you have specified the newline with a forward slash as /n. Does it work if a backslash is used?

In 10.0 I get the following response for a querying a string field that has a carriage return and a newline:
{
      "attributes" : {
        "FID" : 10,
        "ID" : 12,
        "TEXTFIELD" : "new line \r\n in text",
        "TEXT_ESC" : "new line \r\n in text"
      }
    }

Re: Problem querydata with newline (\ and newline, tab ect)

nicogis — Wed, 04 Jan 2012 09:40:18 GMT

Thank you for replay.
Sorry I made a mistake in my writing: I meant that backslash. I have in field DENOM a string with this text: "Test \r\n Test1" but I have this result from this stardard query request (ags .net 10sp3 with data in file geodatabase): http: //myserver/ArcGIS/rest/services/myservice/MapServer/0/query?text=&geometry=&geometryType=esriGeometryPoint&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&objectIds=1&where=&time=&returnCountOnly=false&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=&outFields=*&f=pjson

...
"features" : [
    {
      "attributes" : {
        "OBJECTID" : 1,
        "IDEXT" : "01555",
        "DENOM" : "Test \\r\\n Test1",
        "INSEGNA" : " ",
....

What's the problem? I have tested also with querydata method in arcobjects and I have same problem. no problem with IRecordset arcobjects.

Re: Problem querydata with newline (\ and newline, tab ect)

RaviNarayanan — Thu, 05 Jan 2012 15:52:43 GMT

Domenico,

In JSON backslash is escaped. Since the new line is represented as \n in the string the backslash is probably getting escaped with an additional \.

Ravi

Re: Problem querydata with newline (\ and newline, tab ect)

nicogis — Fri, 06 Jan 2012 16:22:31 GMT

I understand what you say, but:
- why did you say that it is escaped while in your previous reply in the visualization of your response it is not escaped?

- why is it that, if I follow either Querydata method or IRecordset (see my previous example) I have two different results; the first one escaped while the second not escaped?

- the specification are not followed

Thank you in advance for your help.

Re: Problem querydata with newline (\ and newline, tab ect)

RaviNarayanan — Mon, 09 Jan 2012 14:25:42 GMT

Domenico,

The difference is , I had created the newline in the feature class by copy-pasting a new line from notepad++ into the field value. You are representing the newline by the escaped value \n.

Is your question specific to REST API or ArcObjects?

thanks
Ravi

Re: Problem querydata with newline (\ and newline, tab ect)

nicogis — Mon, 09 Jan 2012 19:16:17 GMT

Ok, thank you. Copy and Paste a new line.