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

Discussion created by ciava.at on Dec 29, 2011
Latest reply on Jan 9, 2012 by ciava.at

Like • Show 0 Likes0
Comment • 6

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}}]}

Outcomes

rnarayanan-esristaff

Jan 3, 2012 7:48 AM

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"
      }
    }

Actions

ciava.at Jan 4, 2012 1:40 AM

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.

Actions

rnarayanan-esristaff

Jan 5, 2012 7:52 AM

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

Actions

ciava.at Jan 6, 2012 8:22 AM

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.

Actions

rnarayanan-esristaff

Jan 9, 2012 6:25 AM

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

Actions

ciava.at Jan 9, 2012 11:16 AM

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

Actions

6 Replies

rnarayanan-esristaff Jan 3, 2012 7:48 AM
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"
      }
    }
Like • Show 0 Likes0
Actions
ciava.at Jan 4, 2012 1:40 AM
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.
Like • Show 0 Likes0
Actions
rnarayanan-esristaff Jan 5, 2012 7:52 AM
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
Like • Show 0 Likes0
Actions
ciava.at Jan 6, 2012 8:22 AM
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.
Like • Show 0 Likes0
Actions
rnarayanan-esristaff Jan 9, 2012 6:25 AM
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
Like • Show 0 Likes0
Actions
ciava.at Jan 9, 2012 11:16 AM
Ok, thank you. Copy and Paste a new line.
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

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

Outcomes

Related Content

Recommended Content