REST GET HTTP query parameter size limit?

[davidwilhelm-in]

I am using snapLogic to integrate our ServiceNow instance with a client ServiceNow instance. When we have a comment with a great deal of text, the REST PUT call to the client fails.

For the client REST GET parameters, is there a max size limit for the HTTP Query Parameter?

How would I have the client increase the parameter size limit?

Thanks

[davidwilhelm-in]

Below is the error message in snapLogic when attempted to excute the REST Put:

REST Put[d96ed4a0-4669-4be5-afc8-17130e662ec4 -- 153be354-dcc2-415d-86ed-c1a6b8d9db18]
com.snaplogic.snap.api.SnapDataException: Cannot lookup a property on a null value at sl.EvaluatorUtils.propertyRef(EvaluatorUtils.java:1292) at SC.evaluate(Unknown Source) at com.snaplogic.util.ExpressionUtils$MyExpressionProperty.eval(ExpressionUtils.java:221) at com.snaplogic.snap.api.impl.PropertyValuesImpl$ValidatingExpressionProperty.eval(PropertyValuesImpl.java:914) at com.snaplogic.snap.api.impl.PropertyValuesImpl$ValidatingExpressionProperty.eval(PropertyValuesImpl.java:902) at com.snaplogic.snaps.rest.RestCommon.eval(RestCommon.java:501) at com.snaplogic.snaps.rest.RestCommon.access$200(RestCommon.java:91) at com.snaplogic.snaps.rest.RestCommon$3.resolveUrl(RestCommon.java:468) at com.snaplogic.snap.api.rest.RestRequestExecutor.execute(RestRequestExecutor.java:187) at com.snaplogic.snap.api.rest.RestRequestExecutor.execute(RestRequestExecutor.java:238) at com.snaplogic.snaps.rest.RestWriteCommon.process(RestWriteCommon.java:219) at com.snaplogic.snaps.rest.Put.process(Put.java:43) at com.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:95) at com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:68) at com.snaplogic.snap.api.SimpleSnap.execute(SimpleSnap.java:67) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:772) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:518) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:838) at com.snaplogic.cc.snap.common.SnapRunnableImpl.access$000(SnapRunnableImpl.java:114) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:361) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:357) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:356) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:114) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Error Fingerprint[0] = efp:sl.dTYRWis5

REST Put[d96ed4a0-4669-4be5-afc8-17130e662ec4 -- 153be354-dcc2-415d-86ed-c1a6b8d9db18]
java.lang.Throwable at java.lang.Throwable.getStackTraceElement(Native Method) at java.lang.Throwable.getOurStackTrace(Throwable.java:827) at java.lang.Throwable.getStackTrace(Throwable.java:816) at org.apache.logging.log4j.core.impl.Log4jLogEvent.calcLocation(Log4jLogEvent.java:546) at org.apache.logging.log4j.core.impl.Log4jLogEvent.getSource(Log4jLogEvent.java:537) at com.snaplogic.cc.log.JsonLogLayout.writeFileInfo(JsonLogLayout.java:136) at com.snaplogic.cc.log.JsonLogLayout.writeAllFields(JsonLogLayout.java:109) at com.snaplogic.cc.log.JsonLogLayout.toSerializable(JsonLogLayout.java:91) at com.snaplogic.cc.log.JsonLogLayout.toSerializable(JsonLogLayout.java:43) at org.apache.logging.log4j.core.layout.AbstractStringLayout.toByteArray(AbstractStringLayout.java:148) at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.append(AbstractOutputStreamAppender.java:112) at org.apache.logging.log4j.core.appender.RollingRandomAccessFileAppender.append(RollingRandomAccessFileAppender.java:98) at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:152) at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:125) at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:116) at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84) at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:390) at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:378) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:362) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:352) at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:63) at org.apache.logging.log4j.core.Logger.logMessage(Logger.java:147) at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:1022) at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:980) at org.apache.logging.slf4j.Log4jLogger.debug(Log4jLogger.java:123) at com.snaplogic.cc.jstream.ChannelFactory.unregisterSubscribers(ChannelFactory.java:297) at com.snaplogic.cc.snap.common.SnapRunnableImpl.postStop(SnapRunnableImpl.java:942) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:885) at com.snaplogic.cc.snap.common.SnapRunnableImpl.access$000(SnapRunnableImpl.java:114) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:361) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:357) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:356) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:114) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Error Fingerprint[0] = efp:java.lang._FeA5bt3

[davidwilhelm-in]

This looks like another issue. Let me create a new incident on the client dev instance and try again.

[davidwilhelm-in]

Here is the error message for the large comment in the snapLogic API.

REST Put[ce3eb9b8-f444-49e9-9924-700b9e2ca178 -- 5883aa9c-4023-4bec-9123-860b39135282]
com.snaplogic.snap.api.SnapDataException: Failed to process HTTP response at com.snaplogic.snap.api.rest.RestResponseProcessor.process(RestResponseProcessor.java:359) at com.snaplogic.snap.api.rest.RestRequestExecutor.execute(RestRequestExecutor.java:245) at com.snaplogic.snap.api.rest.RestRequestExecutor.execute(RestRequestExecutor.java:226) at com.snaplogic.snap.api.rest.RestRequestExecutor.execute(RestRequestExecutor.java:238) at com.snaplogic.snaps.rest.RestWriteCommon.process(RestWriteCommon.java:219) at com.snaplogic.snaps.rest.Put.process(Put.java:43) at com.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:95) at com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:107) at com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:75) at com.snaplogic.snap.api.SimpleSnap.execute(SimpleSnap.java:67) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:772) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:518) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:838) at com.snaplogic.cc.snap.common.SnapRunnableImpl.access$000(SnapRunnableImpl.java:114) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:361) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:357) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:356) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:114) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:209) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.snaplogic.instrument.TracingInputStream.read(TracingInputStream.java:88) at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) at sun.security.ssl.InputRecord.read(InputRecord.java:503) at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:961) at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:918) at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) at org.apache.http.impl.io.AbstractSessionInputBuffer.fillBuffer(AbstractSessionInputBuffer.java:160) at org.apache.http.impl.io.SocketInputBuffer.fillBuffer(SocketInputBuffer.java:84) at org.apache.http.impl.io.AbstractSessionInputBuffer.readLine(AbstractSessionInputBuffer.java:273) at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:240) at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:206) at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:169) at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:137) at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284) at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326) at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178) at java.io.InputStreamReader.read(InputStreamReader.java:184) at java.io.Reader.read(Reader.java:140) at org.apache.http.util.EntityUtils.toString(EntityUtils.java:244) at org.apache.http.util.EntityUtils.toString(EntityUtils.java:288) at com.snaplogic.snap.api.rest.RestResponseProcessor.process(RestResponseProcessor.java:315) ... 26 more Error Fingerprint[0] = efp:com.snaplogic.snap.api.rest.GlKL03N8 Error Fingerprint[1] = efp:java.net.OvGCC0TY

REST Put[ce3eb9b8-f444-49e9-9924-700b9e2ca178 -- 5883aa9c-4023-4bec-9123-860b39135282]
java.lang.Throwable at java.io.RandomAccessFile.writeBytes(Native Method) at java.io.RandomAccessFile.write(RandomAccessFile.java:525) at org.apache.logging.log4j.core.appender.rolling.RollingRandomAccessFileManager.flush(RollingRandomAccessFileManager.java:129) at org.apache.logging.log4j.core.appender.rolling.RollingRandomAccessFileManager.write(RollingRandomAccessFileManager.java:112) at org.apache.logging.log4j.core.appender.OutputStreamManager.write(OutputStreamManager.java:136) at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.append(AbstractOutputStreamAppender.java:114) at org.apache.logging.log4j.core.appender.RollingRandomAccessFileAppender.append(RollingRandomAccessFileAppender.java:98) at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:152) at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:125) at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:116) at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84) at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:390) at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:378) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:362) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:352) at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:63) at org.apache.logging.log4j.core.Logger.logMessage(Logger.java:147) at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:1022) at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:980) at org.apache.logging.slf4j.Log4jLogger.debug(Log4jLogger.java:123) at com.snaplogic.snap.api.rest.RestHttpClient.stopCleanUpConnManager(RestHttpClient.java:291) at com.snaplogic.snaps.rest.RestCommon.cleanup(RestCommon.java:530) at com.snaplogic.cc.util.SnapUtil.cleanup(SnapUtil.java:245) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:541) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:838) at com.snaplogic.cc.snap.common.SnapRunnableImpl.access$000(SnapRunnableImpl.java:114) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:361) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:357) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:356) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:114) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Error Fingerprint[0] = efp:java.io.TRxupL8H

[davidwilhelm-in]

I tried testing in postman as well. When I set the parameters and the endpoint, and the basic auth, it does not error but the client incident record is not updated, even with a small comment.

Here is my PUT URL: https://{{server_name}}.service-now.com/api/now/table/incident/{{client_case_sys_id}}?state={{state}}&x_suca_insight_int_insight_number={{x_suca_insight_int_insight_number}}&comments={{comments}}&close_code={{close_code}}&close_notes={{close_notes}}

I have the variables set

I have the two headers set content-type = application/json, and Accept = application/json

When I run this PUT, the postman body returns the xml for the incident record from their system but nothing gets updated.

The parameters work just fine from the snapLogic api. I must be missing something in postman. If I can get this to work, I would be able to verify the error message returned from the client instance instead of the snapLogic error message.

[Tanner6]

Hey David,

I am by no means technical but moving large amounts of data between MSP's and their customers is something that we specialize in at Perspectium.

Here is some information about how we helped our customers if you are interested.