Reltio Connect

 View Only
  • 1.  Creating an Entity via API

    Posted 05-22-2023 10:00

    Hi Experts,

    With the help of the Reltio tutorial(11.24 on the time bar), I am trying to create a new entity and ending up with the error. 

    Below is the JSON script I have created and used in the body of the Postman

    [
        {
            "type""configuration/entityTypes/FirstTable",
            "attributes": {
                "Addresses": [
                    "123 Dehradun",
                    "456,Dehradun",
                    "Jaipur,Rajasthan",
                    "CP,Delhi"
                ],
                "Phone": [
                    "9891 123 123",
                    "9810 235 123",
                    "9991 263 223",
                    "9891 678 345"
                ],
                "FirstName": [
                    "Piyush",
                    "Mayank",
                    "Jack",
                    "David"
                ],
                "LastName": [
                    "Sharma",
                    "Kumar",
                    "Daniel",
                    "Jones"
                ]
            }
        }
    ]

     
    Result Below:

    [
        {
            "index"0,
            "errors": {
                "severity""Error",
                "errorMessage""Type is not found for URI configuration/entityTypes/FirstTable and tenant Vt8g4ESlE82zQlh",
                "errorCode"119,
                "errorDetailMessage""Type is not found for URI configuration/entityTypes/FirstTable and tenant Vt8g4ESlE82zQlh"
            },
            "successful"false
        }
    ]



    My conclusion on this:
    - Either I misunderstood the tutorial (Creating the entity) as the error (Result) says Type not found (FirstTable). It will not find the entity type, as it is something I am trying to create. 
    - Or I made some mistakes.




    ------------------------------
    PIYUSH SHARMA
    ------------------------------


  • 2.  RE: Creating an Entity via API

    Founding Member
    Posted 05-22-2023 10:51

    Hi Piyush,

    There are multiple challenges in the payload. They very first in "type" defines the entity type of the data model eg.,g Person, Account, HCO, HCP etc. Second the Reltio expected JSON structure is a bit different to what you have pulled here. You can refer to this docs link and several other associated with it on how to perform CURD operations by using Reltio API: https://docs.reltio.com/en/explore/get-going-with-apis-and-rocs-utilities/reltio-rest-apis/model-apis/entities-api/create-entities 



    ------------------------------
    Ashish Rawat
    Sr. Manager
    Fresh Gravity
    Bangalore
    ------------------------------



  • 3.  RE: Creating an Entity via API

    Reltio Employee
    Posted 05-22-2023 11:27

    Just for reference a properly formatted entity create might look like this:

    [
        {
            "type": "configuration/entityTypes/Individual",
            "crosswalks": [
                {
                    "type": "configuration/sources/CRM",
                    "value": "20230315002616"
                }
            ],
            "attributes": {
                "FirstName": [
                    {
                        "value": "Daniel"
                    }
                ],
                "LastName": [
                    {
                        "value": "Gage"
                    }
                ],
                "Type": [
                    {
                        "value": "Loyalty"
                    }
                ],
                "Phone": [
                    {
                        "value": {
                            "Type": [
                                {
                                    "value": "Mobile"
                                }
                            ],
                            "Number": [
                                {
                                    "value": "404-585-8702"
                                }
                            ]
                        }
                    }
                ],
                "BirthInfo": [
                    {
                        "value": {
                            "DoB": [
                                {
                                    "value": "01/01/1970"
                                }
                            ]
                        }
                    }
                ],
                "Email": [
                    {
                        "value": {
                            "Type": [
                                {
                                    "value": "Work"
                                }
                            ],
                            "Email": [
                                {
                                    "value": "dan.gage@reltio.com"
                                }
                            ]
                        }
                    }
                ],
                "Gender": [
                    {
                        "value": "Male"
                    }
                ]
            }
        }
    ]

     



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



  • 4.  RE: Creating an Entity via API

    Posted 05-22-2023 11:56

    Thank you, @Daniel Gage for sharing the sample script. I have modified it accordingly.

    The one you shared is with a crosswalk, but I am trying with no crosswalk and still getting the error. Can you please share your inputs?

    [
        {
            "type""configuration/entityTypes/FirstTable",
            "attributes": {
                "Addresses": [
                    {
                        "value""23 Rd Dehradun"
                    },
                    {
                        "value""46 Rd,Dehradun"
                    },
                    {
                        "value""Jaipur,Rajasthan"
                    },
                    {
                        "value""CP,Delhi"
                    }
                ],
                "Phone": [
                    {
                        "value""9891 123 123"
                    },
                    {
                        "value""9810 235 123"
                    },
                    {
                        "value""9991 263 223"
                    },
                    {
                        "value""9891 678 345"
                    }
                ],
                "FirstName": [
                    {
                        "value""Piyush"
                    },
                    {
                        "value""Mayank"
                    },
                    {
                        "value""Jack"
                    },
                    {
                        "value""David"
                    }
                ],
                "LastName": [
                    {
                        "value""Sharma"
                    },
                    {
                        "value""Kumar"
                    },
                    {
                        "value""Daniel"
                    },
                    {
                        "value""Jones"
                    }
                ]
            }
        }
    ]





    ------------------------------
    PIYUSH SHARMA
    Cloudsufi
    ------------------------------



  • 5.  RE: Creating an Entity via API
    Best Answer

    Reltio Employee
    Posted 05-22-2023 12:19

    If you are using the Reltio out of the box Phone and Addresses data structures, it should look like below.  

    I do encourage you to use a crosswalk - without it, it will create a new records every time you perform this post, even with the same data.  Automatica merge rules on key fields will consolidate the profiles, but you will still have many records being consolidated.  Another option is to explore surrogate crosswalks.  

    [
        {
            "type": "configuration/entityTypes/FirstTable",
            "attributes": {
                "Addresses": [
                    {
                        "value": {
                            "AddressLine1": [
                                {
                                    "value": "23 Rd Dehradun"
                                }
                            ],
                            "AddressLine2": [
                                {
                                    "value": "46 Rd,Dehradun"
                                }
                            ],
                            "City": [
                                {
                                    "value": "Jaipur,Rajasthan"
                                }
                            ],
                            "State": [
                                {
                                    "value": "CP,Delhi"
                                }
                            ],
                            "Country": [
                                {
                                    "value": "India"
                                }
                            ]
                        }
                    }
                ],
                "Phone": [
                    {
                        "value": {
                            "Number": [
                                {
                                    "value": "+91 9891 123 123"
                                }
                            ]
                        }
                    },
                    {
                        "value": {
                            "Number": [
                                {
                                    "value": "+91 9810 235 123"
                                }
                            ]
                        }
                    },
                    {
                        "value": {
                            "Number": [
                                {
                                    "value": "+91 9991 263 223"
                                }
                            ]
                        }
                    },
                    {
                        "value": {
                            "Number": [
                                {
                                    "value": "+91 9891 678 345"
                                }
                            ]
                        }
                    }
                ],
                "FirstName": [
                    {
                        "value": "Piyush"
                    },
                    {
                        "value": "Mayank"
                    },
                    {
                        "value": "Jack"
                    },
                    {
                        "value": "David"
                    }
                ],
                "LastName": [
                    {
                        "value": "Sharma"
                    },
                    {
                        "value": "Kumar"
                    },
                    {
                        "value": "Daniel"
                    },
                    {
                        "value": "Jones"
                    }
                ]
            }
        }
    ]


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