Layer7 API Management

I want to perform CRUD operation on JSON file as an input.

As data structure we have JSON array with objects for each entry e.g. for roles:

[

  {

               "role_id":1,

              "role_alias":"globaladmin",

               "role_name":"Global Admin",

               "role_desc":"descr of global admin "

  },

  {

               "role_id":2,

              "role_alias":"localadmin",

               "role_name":"Local Admin",

               "role_desc":"descr of local admin "

  } 

]

I want to UPDATE the "roles" tables with above details so effected rows would be 2.

Lets say, for role_id :1, i want to update role_name, similarly for role_id:2.

Please provide inputs how i can iterate through json objects and update the database.

Regards

Vidhi Gupta

To clarify you want to take the above and make a custom table named role that gets updated with each of these subgroups?

I can try to make a quick sample but not sure if I have your entire use case.

Here is a sample that will basically iterate through your message and treat individual records. 

I hope it helps.

..

Hello Charles,

Good example.

We can also loop the ${jsonRBAC.results} directly, it's already a multi-valued context variable after json path.

Regards,

Mark