Reltio Connect

 View Only
  • 1.  Empty value for date in the payload

    Posted 06-15-2023 11:28

    Hi Team, in our post request we usually insert a DateOfBirth for Individual entity. There are times when we dont get value for DateOfBirth and DOB attribute which is of date type is empty.

    When we do a post request with empty date field we are getting below error:

                "severity""Error",
                "errorMessage""Invalid attribute format specification for configuration/entityTypes/
                "errorCode"160,
                "errorDetailMessage""Invalid attribute value specification for configuration/entityTypes/"
       How do we fix this issue?


    ------------------------------
    Akash Sabarad
    Securian
    IL
    ------------------------------


  • 2.  RE: Empty value for date in the payload

    Founding Member
    Posted 06-15-2023 15:49

    Ideally attributes with null value should be filtered out before posting the data to MDM. 



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



  • 3.  RE: Empty value for date in the payload

    Posted 06-15-2023 15:59

    Yes we are checking if the value is NULL and removing the field. However since the attribute dosent get any value in the payload it throwing the error.



    ------------------------------
    Akash Sabarad
    Securian
    IL
    ------------------------------



  • 4.  RE: Empty value for date in the payload

    Founding Member
    Posted 06-16-2023 04:16

    So if DoB/Any attribute value is null then it should not be part of payload at all.  e.g., if DoB is null then

    Incorrect JSON
     "attributes": {

          "FirstName": [
            {
              "value": "Arya"
            }
          ],
         "DoB": [
            {
              "value": ""
            }
          ],
          "LastName": [
            {
              "value": "Stark"
            }
          ]}
    Correct JSON

     "attributes": {

          "FirstName": [
            {
              "value": "Arya"
            }
          ],
          "LastName": [
            {
              "value": "Stark"
            }
          ]}


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



  • 5.  RE: Empty value for date in the payload

    Reltio Partner
    Posted 06-16-2023 10:34

    Hi Akash,

    You can try this and it works!

    [
        {
            "type": "configuration/entityTypes/Customer",
            "attributes": {
                "Name": [
                    {
                        "value": "Hello World"
                    }
                ],
                "TierEndDate": [
                    {
                        "value": null
                    }
                ]
            }
        }
    ]
    Just provide the value null without double quotes and it won't be posted as value on UI.
    You can cross check in UI and also via API. you will not have the attribute.
    Please try out and update!


    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------