Reltio Connect

 View Only

  • 1.  Search Connection API not working with filter

    Reltio Partner
    Posted 28 days ago

    The 2nd filter which we are using to filter target entities after the inRelations or outRelations is not working and we are not getting expected result. If  we start the search from Person and want to fetch all related contract entities where policy number is given, we are only getting the person information. No relations ad related entities.

    For example

    https://mpe-01.reltio.com/reltio/api/TenantId/entities/_searchConnections

    Body:

    {<o:p></o:p>

        "filter": "equals(type,'Person') and equals(attributes.CustomerId,'4352425')",<o:p></o:p>

        "connections": [<o:p></o:p>

            {<o:p></o:p>

                "outRelations": [<o:p></o:p>

                    {<o:p></o:p>

                        "uri": "configuration/relationTypes/PersonToContract1"<o:p></o:p>

                    },<o:p></o:p>

                    {<o:p></o:p>

                        "uri": "configuration/relationTypes/PersonToContract2"<o:p></o:p>

                    },<o:p></o:p>

                    {<o:p></o:p>

                        "uri": "configuration/relationTypes/PersonToContract3"<o:p></o:p>

                    },<o:p></o:p><o:p></o:p>

                ],<o:p></o:p>

                "filter": "equals(type,'Contract') and equals(attributes.policyNumber,'GAB12435')"<o:p></o:p>

            }<o:p></o:p>

        ]<o:p></o:p>

    }<o:p></o:p>

    Response: 

    {
        "entities": [
            {
                "uri": "entities/ytyt65",
                "type": "configuration/entityTypes/Person",
                
                "attributes": {
                    .....
                },          
                "crosswalks": [
                    {
                        ..........
                    }
                ]
            }
        ]
    }



    ------------------------------
    sayan mallick
    Aviva
    ------------------------------


  • 2.  RE: Search Connection API not working with filter

    Reltio Employee
    Posted 28 days ago

    I have not seen the syntax your are leveraging.  I have gotten results with:

    POST: {{tenantURL}}/entities/_searchConnections?max=250&returnFullRelations=true&returnAnalyticAttributes=false&options=ovOnly&select=uri,label&filter=(equals(attributes.FirstName,'Dan') and equals(attributes.Specialties.Specialty,'ON'))

    Body:

    [
    {
    "outRelations": [
    {
    "uri": "configuration/relationTypes/HCPisAffiliatedWithHCO"
    }
    ],
    "filter": "startsWith(attributes.Name,'Prisma')"
    }
    ]

    Note that the results are designed to return ALL profiles which meet the filter condition specified in the querystring filter, and then for each of those records, see if any of them have the relationship(s) specified which link to objects which meets the filter criteria in the body.  

    Not all records in the base search results will have the indicated relationship.  You will need to parse the results     relations array to see which start and end objects match both criteria.  This API is not intended to be a graph search, but rather a search across parent and subsequently child objects without having to make multiple API calls.


    ------------------------------
    Dan Gage
    Principal Solution Consultant
    ------------------------------

    Original Message