Reltio Connect

 View Only
  • 1.  apostrophe in Address Line

    Posted 22 days ago

    Reltio Idea - MDM-I-2156; 

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


    ------------------------------
    Vijay Reddy
    Allegis Group Inc
    Cumming GA
    ------------------------------


  • 2.  RE: apostrophe in Address Line

    Reltio Employee
    Posted 22 days ago

    Hi Vijay,

     Please share your full API request and response for further investigation 



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Staff Forward Deployed Engineer
    Reltio
    Bangalore
    ------------------------------



  • 3.  RE: apostrophe in Address Line

    Posted 21 days ago

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



    ------------------------------
    Vijay Reddy
    Allegis Group Inc
    Cumming GA
    ------------------------------



  • 4.  RE: apostrophe in Address Line

    Reltio Partner
    Posted 21 days ago

    Hi,

    i see the bracket is not properly closed at the end in filter condition.

    Try Closing  and then run the API

     



    ------------------------------
    PRAVIN BIRADAR
    PERSISTENT
    ------------------------------



  • 5.  RE: apostrophe in Address Line

    Posted 15 days ago

    May be there way typo while copying from the logs. I checked with the team and below is the actual request payload. Can you please try from you end and let us know 

    Resource : /mdm/entities/searchConnections

    {

      "filter": "(equals(attributes.AddressLine1,'287 NELSON'S CRT') and equals(attributes.City,'NEW WESTMINSTER') and equals(attributes.Country,'CAN') and equals(attributes.Zip.PostalCode,'V3L 0E3'))",

      "connections": []

    }



    ------------------------------
    Vijay Reddy
    Allegis Group Inc
    Cumming GA
    ------------------------------



  • 6.  RE: apostrophe in Address Line

    Reltio Partner
    Posted 15 days ago

     Hey,

    Replace  apostrophe with like this 

    287 NELSON\\'S CRT    instead of  287 NELSON'S CRT and in connection array try giving some input its working on my end.
    Thanks


    ------------------------------
    PRAVIN BIRADAR
    PERSISTENT
    ------------------------------



  • 7.  RE: apostrophe in Address Line

    Posted 14 days ago
    Thanks for the recommendation. We're aware of this change. The challenge is that we would need to apply it across multiple integration applications wherever we perform API searches on Organization or Address. We're looking for a solution from Reltio, ideally a configuration-level option that allows us to ignore apostrophes without having to modify each integration individually
    Can you please give me vote for my Aha request : https://reltio.ideas.aha.io/ideas/MDM-I-2156


    ------------------------------
    Vijay Reddy
    Allegis Group Inc
    Cumming GA
    ------------------------------



  • 8.  RE: apostrophe in Address Line

    Posted 13 days ago

    Good Afternoon Pravin , Based on your expertise, could you please advise whether similar scenarios exist for any other characters where we may encounter the same issue and require an override



    ------------------------------
    Vijay Reddy
    Allegis Group Inc
    Cumming GA
    ------------------------------