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": r
    {
      "json": {
        "Instance": "West",
        "MainID": "1001",
        "Financial Year": 2023,
        "SecondaryID": "9000,9001,9002",
        "Identifier": "JIRA1234"
      }
    }
  ]
}