Reltio Connect

 View Only

  • 1.  Json parsing in RIH

    Posted 07-19-2023 04:35

    Hi Team,

    Was working on a requirement where i have a scenario to be handled through RIH as stated below.

    Json structure - 

    Target - Loading to Reltio Entity
    Question - 
    I have a block """data -> document -> ingested data""" where values are dynamic - in this example we have 15 value and it may vary as per the payload.
    Each block has data as below - 
    "ingestion": {
      "value": "Not a Customer",
      "field_name": "Customer Status"
    },
    Where i need to perform mapping and validation based on field_name value.
    If field_name = Customer Status - i need to pass a validation,
    If field_name = date - i need to calculate the age
    I was able to map others / straight forward variable but this particular part i am bit stuck.
    Thanks & Regards,



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



  • 2.  RE: Json parsing in RIH

    Reltio Partner
    Posted 07-19-2023 08:36

    Hi Chetan,

    You should be able to use Conditionals here to resolve the issue.

    Check this out: Formula mode - Add conditions to formulas | Workato Docs

    It is simple as if else block and based on datapill value you can decide what to be used.

    Try and let me know if you face any challenges.



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

    Original Message


  • 3.  RE: Json parsing in RIH

    Posted 07-19-2023 12:45

    Hi Sheshadri,

    We have used conditional formatting option, but this requirement needs something in json parsing i believe.

    Example -If we look over this example, to map the relevant if condition or output field we only have ingested data -> ingestion -> value in metadata. 

    But what is needed is, while getting the response we are getting data in above mentioned format.

    Even to have some IF condition, i must be able to first toggle between the key values.

    Configuration - 

    Response from API

    Was looking for a way to achieve this.

    Thanks & Regards,



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

    Original Message


  • 4.  RE: Json parsing in RIH

    Reltio Partner
    Posted 07-20-2023 10:49

    Hi Chetan,

    Are you mapping this to Nested/Simple Attributes?

    If Nested then i would still say that conditionals is the right one to be implemented.

    If you are unable to use conditionals let me know we can have a catchup once



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

    Original Message


  • 5.  RE: Json parsing in RIH

    Posted 07-20-2023 13:37

    Hi Sheshadri,

    I tried all possible combinations using conditional statements functionality, but unable to get desired requirement satisfied.

    May be i need to explain elaborately. 

    Thanks & Regards,



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

    Original Message


  • 6.  RE: Json parsing in RIH

    Reltio Partner
    Posted 07-21-2023 07:11

    Hi Chetan,

    We cannot do any parsing in JSON.

    The final option is to use a code block like Python, Ruby in intermediary step and have the required transformation, later you can map the output of code block to Reltio connector.

    I would suggest to use code block as FINAL option only.



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

    Original Message


  • 7.  RE: Json parsing in RIH

    Posted 09-28-2023 10:25

    I have a similar requirement to parse json with dynamic nested arrays and load into Reltio Entity. The output of the json parser is showing the dynamic nested arrays, however I cannot read the list of the array in my next step which is loading into Reltio Entity. Can you please share on how you solved this? Thanks!



    ------------------------------
    Anu Peri
    Medical Solutions
    ------------------------------

    Original Message


  • 8.  RE: Json parsing in RIH

    Reltio Employee
    Posted 10-10-2023 15:06

    Hi Chetan,

    It looks like ingested data is an array.  Would it be possible to use the 'Repeat Action' using the ingested data array as the input, and then have a separate Reltio Update action for each occurrence of the data array?  Setting it up in batch mode would allow the output to be bundled into batches limiting the number of required API calls.

    A more crude way of attacking this would be utilizing the Reltio 'Custom action' feature and passing it a raw JSON.  The raw JSON would need to be constructed using either the Python or Javascript actions to format the payload into the right format.

    Thanks,

    Chris



    ------------------------------
    Christopher Jezorek
    ------------------------------

    Original Message


Related Content