storing json value to table

storing json value to table

  

{

"Id"      :12345,          

"Created_DateTime":  "1943-12-31" ,  

"Created_By"      :  "santhu",

"Posting_Request" : "sfjhv" ,

"Posting_Response": "vsdjhgv",      

"PostingStatus"   :    "success" ,  

"MetaData":  {

              "name"      :"santros",

              "surname"          :   "ms",

              "age":21,

              "Address":"fsdfdss",

             }


}

using this json value i want store the MetaData   values to  table ,how should i achieve this .could you please help me.

Solution

Hi Santhu,

You need to convert JSON to record list then you can iterate foreach loop for that record list and you will be able to save MetaData values to DB.


Regards

-SK-

Solution

Hello,


Step by step:

  1. First you need to create a Table to store that Data
  2. Create a structure to store the json - you can achieve this by right click on the folder Structures and select the "add structure from JSON", paste or json there,
  3. Create an action that receives the json as text
  4. Convert Json to RecordList
  5. Iterate the MetaData branch and create the records on the Database.

The last 2 step are the ones that Shashi identified.


Regards,

Davide Periquito wrote:

Hello,


Step by step:

  1. First you need to create a Table to store that Data
  2. Create a structure to store the json - you can achieve this by right click on the folder Structures and select the "add structure from JSON", paste or json there,
  3. Create an action that receives the json as text
  4. Convert Json to RecordList
  5. Iterate the MetaData branch and create the records on the Database.

The last 2 step are the ones that Shashi identified.


Regards,


thank you for your reply.. its working now...

Shashi kant Shukla wrote:

Hi Santhu,

You need to convert JSON to record list then you can iterate foreach loop for that record list and you will be able to save MetaData values to DB.


Regards

-SK-

thank you shashi its working now..