Reltio Connect

 View Only
  • 1.  Reference attribute in Object filter in SQS

    Posted 28 days ago

    Hi Team,

    I have a very common scenario but need to put optimal solution on the same.

    Scenario - We have an attribute Address which is a Reference attributes such as Address.

    Need a solution where when Address alone is changed, then SQS output should contain all the details given under Payload fields.

    Filters used, but these are not working - 

    • (equals(type,'configuration/entityTypes/HCP') and exists(attributes. Address))
    • (equals(type,'configuration/entityTypes/HCP') and exists(delta.attributes. Address))

    Any suggestions ?

    Thanks & Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------


  • 2.  RE: Reference attribute in Object filter in SQS
    Best Answer

    Reltio Employee
    Posted 23 days ago

    Hi Chetan,

    Please try below:

    objectFilter = equals(type, 'configuration/entityTypes/HCP') and changes(configuration/entityTypes/Address/attributes)

    See the doc link below:

    https://docs.reltio.com/en/developer-resources/data-integration-apis/data-integration-apis-at-a-glance/events-api#:~:text=To%20prevent%20notifications%20triggered%20by%20changes%20in%20reference%20attributes



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



  • 3.  RE: Reference attribute in Object filter in SQS

    Posted 21 days ago

    Thanks a lot @Snehil Kamal, it worked.

    Can you please help me to fix the below. i am trying to filter using ovChanged in delta section in Snapshot+Delta mode.

    Filter - (equals(delta.ovChanged,true))

    Thanks & Regards,
    Chetan

     



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------