2 Replies Latest reply on Jun 9, 2021 7:52 AM by Nico Heinze

    Need To Generate JSON message

    Heena Rajvanshi Active Member

           Hello All,


      I need to generate a JSON message for one to many relationship like we do for in our xml message or xml generator .


      For example: if a company ABC is dealing so many other companies i.e. they all act as a parties for company ABC.so i want to generate a JSON message which contain company ABC as a root and all other parties details should be contain in party area.



              "companyId": "'||ROWID_OBJECT||'",----companyABC

              "companyName": "'||STD_FULL_NAME||'",--------company ABC



                      "businessPartners": [


                             "mdmId": "'||ROWID_PARTY||'",---------all other parties details


                             "name": "'||PARTY_STD_FULL_NAME||'",---------all other parties details







      can any one help how i can handle this one-many relationship scenario?