I have a json response for “add item to queue” which needs to be added to the database
I would like to add 3 rows in Database using this Json response which is sitting as a row in Queue
WLM queue will have
Instance :West, MainID :1001, Financial Year :2023, Secondary ID: 9000,9001,9002, Identifier :JIRA1234
Need to write 3 entries in database (since there are 3 secondary IDs)
Row 1 - West 1001 2023 9000 JIRA1234
Row 2 - West 1001 2023 9001 JIRA1234
Row 3 - West 1001 2023 9002 JIRA1234
Please suggest how to do the same
Json response to “Add item to queue”
{
"workItems": [
{
"json": {
"Instance": "West",
"MainID": "1001",
"Financial Year": 2023,
"SecondaryID": "9000,9001,9002",
"Identifier": "JIRA1234"
}
}
]
}
