Reltio Connect

Reltio Idea - MDM-I-2156; 

Search Connection API returns a 400 Bad Request for apostrophe in Address Line

Hi Vijay,

 Please share your full API request and response for further investigation 

Reltio Idea - MDM-I-2156; 

Search Connection API returns a 400 Bad Request for apostrophe in Address Line

Reltio Ticket : 130090

Resource : /mdm/entities/searchConnections

{

    "filter": "(equals(attributes.AddressLine1,'957 St Mary's Rd') and equals(attributes.City,'Winnipeg') and equals(attributes.Country,'CA') and equals(attributes.Zip.PostalCode,'R2M 3R9')",

    "connections": []

}

Response : 

{
    "severity": "Error",
    "errorMessage": "Search request parsing failed with error - expression '(equals(attributes.AddressLine1,'957 St Mary's Rd') and equals(attributes.City,'Winnipeg') and equals(attributes.Country,'CA') and equals(attributes.Zip.PostalCode,'R2M 3R9')' is invalid",
    "errorCode": 179,
    "errorDetailMessage": "Request filter parameter parsing failed.",
    "innerErrorData": {
        "exception": "com.reltio.metadata.errors.CommonException:Code: SEARCH_REQUEST_PARSING_FAILED; Message parameters: [expression '(equals(attributes.AddressLine1,'957 St Mary's Rd') and equals(attributes.City,'Winnipeg') and equals(attributes.Country,'CA') and equals(attributes.Zip.PostalCode,'R2M 3R9')' is invalid]. Search request parsing failed with error - expression '(equals(attributes.AddressLine1,'957 St Mary's Rd') and equals(attributes.City,'Winnipeg') and equals(attributes.Country,'CA') and equals(attributes.Zip.PostalCode,'R2M 3R9')' is invalid. Request filter parameter parsing failed.",
        "stack": [
            "com.reltio.metadata.errors.CommonExceptionBuilder.build at CommonExceptionBuilder.java, line 65",
            "com.reltio.search.exception.SearchToCommonExceptionConverter.convert at SearchToCommonExceptionConverter.java, line 14",
            "com.reltio.rest.v6.exception.RESTExceptionHandler.handleSearchException at RESTExceptionHandler.java, line 82",
            "jdk.internal.reflect.DirectMethodHandleAccessor.invoke at DirectMethodHandleAccessor.java, line 103",
            "java.lang.reflect.Method.invoke at Method.java, line 580",
            "org.springframework.web.method.support.InvocableHandlerMethod.doInvoke at InvocableHandlerMethod.java, line 258",
            "org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest at InvocableHandlerMethod.java, line 191",
            "org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle at ServletInvocableHandlerMethod.java, line 118",
            "org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException at ExceptionHandlerExceptionResolver.java, line 471",
            "org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException at AbstractHandlerMethodExceptionResolver.java, line 73",
            "org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException at AbstractHandlerExceptionResolver.java, line 182",
            "org.springframework.web.servlet.DispatcherServlet.processHandlerException at DispatcherServlet.java, line 1360",
            "org.springframework.web.servlet.DispatcherServlet.processDispatchResult at DispatcherServlet.java, line 1161",
            "org.springframework.web.servlet.DispatcherServlet.doDispatch at DispatcherServlet.java, line 1106",
            "org.springframework.web.servlet.DispatcherServlet.doService at DispatcherServlet.java, line 979",
            "org.springframework.web.servlet.FrameworkServlet.processRequest at FrameworkServlet.java, line 1014",
            "org.springframework.web.servlet.FrameworkServlet.doPost at FrameworkServlet.java, line 914",
            "jakarta.servlet.http.HttpServlet.service at HttpServlet.java, line 590",
            "org.springframework.web.servlet.FrameworkServlet.service at FrameworkServlet.java, line 885",
            "jakarta.servlet.http.HttpServlet.service at HttpServlet.java, line 658",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 193",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "org.apache.tomcat.websocket.server.WsFilter.doFilter at WsFilter.java, line 51",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.rest.cache.RestOperationCachingRequestWrapFilter.doFilter at RestOperationCachingRequestWrapFilter.java, line 28",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.rest.operation.ContentTypeFilter.doFilter at ContentTypeFilter.java, line 35",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.rest.operation.RequestLoggingFilter.doFilter at RequestLoggingFilter.java, line 54",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.servlet.v6.RequestResponseSizeFilter.doFilter at RequestResponseSizeFilter.java, line 25",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter at CompositeFilter.java, line 108",
            "org.springframework.security.web.FilterChainProxy.lambda$doFilterInternal$3 at FilterChainProxy.java, line 231",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 365",
            "org.springframework.security.web.access.intercept.AuthorizationFilter.doFilter at AuthorizationFilter.java, line 101",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.access.ExceptionTranslationFilter.doFilter at ExceptionTranslationFilter.java, line 126",
            "org.springframework.security.web.access.ExceptionTranslationFilter.doFilter at ExceptionTranslationFilter.java, line 120",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.session.SessionManagementFilter.doFilter at SessionManagementFilter.java, line 131",
            "org.springframework.security.web.session.SessionManagementFilter.doFilter at SessionManagementFilter.java, line 85",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter at AnonymousAuthenticationFilter.java, line 100",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter at SecurityContextHolderAwareRequestFilter.java, line 179",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter at RequestCacheAwareFilter.java, line 63",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.oauth2.server.resource.web.authentication.BearerTokenAuthenticationFilter.doFilterInternal at BearerTokenAuthenticationFilter.java, line 145",
            "org.springframework.web.filter.OncePerRequestFilter.doFilter at OncePerRequestFilter.java, line 116",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter at HeaderWriterFilter.java, line 90",
            "org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal at HeaderWriterFilter.java, line 75",
            "org.springframework.web.filter.OncePerRequestFilter.doFilter at OncePerRequestFilter.java, line 116",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.context.SecurityContextHolderFilter.doFilter at SecurityContextHolderFilter.java, line 82",
            "org.springframework.security.web.context.SecurityContextHolderFilter.doFilter at SecurityContextHolderFilter.java, line 69",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal at WebAsyncManagerIntegrationFilter.java, line 62",
            "org.springframework.web.filter.OncePerRequestFilter.doFilter at OncePerRequestFilter.java, line 116",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal at DisableEncodeUrlFilter.java, line 42",
            "org.springframework.web.filter.OncePerRequestFilter.doFilter at OncePerRequestFilter.java, line 116",
            "org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter at FilterChainProxy.java, line 374",
            "org.springframework.security.web.FilterChainProxy.doFilterInternal at FilterChainProxy.java, line 233",
            "org.springframework.security.web.FilterChainProxy.doFilter at FilterChainProxy.java, line 191",
            "org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter at CompositeFilter.java, line 113",
            "org.springframework.web.servlet.handler.HandlerMappingIntrospector.lambda$createCacheFilter$4 at HandlerMappingIntrospector.java, line 267",
            "org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter at CompositeFilter.java, line 113",
            "org.springframework.web.filter.CompositeFilter.doFilter at CompositeFilter.java, line 74",
            "org.springframework.security.config.annotation.web.configuration.WebMvcSecurityConfiguration$CompositeFilterChainProxy.doFilter at WebMvcSecurityConfiguration.java, line 238",
            "org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate at DelegatingFilterProxy.java, line 362",
            "org.springframework.web.filter.DelegatingFilterProxy.doFilter at DelegatingFilterProxy.java, line 278",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.servlet.v6.AllowCrossDomainRequestsFilter.doFilter at AllowCrossDomainRequestsFilter.java, line 27",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.servlet.v6.PlatformShutdownFilter.doFilter at PlatformShutdownFilter.java, line 29",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "com.reltio.servlet.v6.OperationStatsInitializerFilter.doFilter at OperationStatsInitializerFilter.java, line 26",
            "org.apache.catalina.core.ApplicationFilterChain.internalDoFilter at ApplicationFilterChain.java, line 162",
            "org.apache.catalina.core.ApplicationFilterChain.doFilter at ApplicationFilterChain.java, line 138",
            "org.apache.catalina.core.StandardWrapperValve.invoke at StandardWrapperValve.java, line 165",
            "org.apache.catalina.core.StandardContextValve.invoke at StandardContextValve.java, line 88",
            "org.apache.catalina.authenticator.AuthenticatorBase.invoke at AuthenticatorBase.java, line 492",
            "org.apache.catalina.core.StandardHostValve.invoke at StandardHostValve.java, line 113",
            "org.apache.catalina.valves.ErrorReportValve.invoke at ErrorReportValve.java, line 83",
            "org.apache.catalina.valves.AbstractAccessLogValve.invoke at AbstractAccessLogValve.java, line 654",
            "org.apache.catalina.core.StandardEngineValve.invoke at StandardEngineValve.java, line 72",
            "org.apache.catalina.connector.CoyoteAdapter.service at CoyoteAdapter.java, line 342",
            "org.apache.coyote.http11.Http11Processor.service at Http11Processor.java, line 399",
            "org.apache.coyote.AbstractProcessorLight.process at AbstractProcessorLight.java, line 63",
            "org.apache.coyote.AbstractProtocol$ConnectionHandler.process at AbstractProtocol.java, line 903",
            "org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun at NioEndpoint.java, line 1775",
            "org.apache.tomcat.util.net.SocketProcessorBase.run at SocketProcessorBase.java, line 52",
            "org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker at ThreadPoolExecutor.java, line 973",
            "org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run at ThreadPoolExecutor.java, line 491",
            "org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run at TaskThread.java, line 63",
            "java.lang.Thread.run at Thread.java, line 1583"
        ]
    }
}

Hi Vijay,

 Please share your full API request and response for further investigation 

Reltio Idea - MDM-I-2156; 

Search Connection API returns a 400 Bad Request for apostrophe in Address Line