part of the payload as JSON sting to DB

Summary:

Hello All,

Receiving JSON from thirdparty , below is the payload. Part of the payload i.e metadata part in the payload should be mapped to DB column as json string.

Payload : after reading the json from thridparty in OIC integration

<transactions>

 <transactions>

   <transactionId>3456</transactionId>

   <date>2022-08-26T23:59:00Z</date>

   <amount>332.5</amount>

   <amountConverted>332.5</amountConverted>

   <bankReference>111111111111</bankReference>

   <type>DEBIT</type>

   <description>CCC ORIGINATION - 296097 - FILE 7878782339 COID 2770565408 WASHINGTON MILLS ELECT </description>

   <descriptionDetail>bank_reference: 111111111111 customer_reference: 00000000000</descriptionDetail>

   <currency>USD</currency>

   <currencyConverted>USD</currencyConverted>

   <dataProviderId>WFB</dataProviderId>

   <check_num />

   <category>CCC</category>

   <account>

    <institutionName>BBBBBBBBBBBBB</institutionName>

    <institutionId>rrr</institutionId>

    <accountNumber>****8290</accountNumber>