Question

WLM queue to SQL database

  • 19 January 2023
  • 0 replies
  • 9 views

Badge +2

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"
      }
    }
  ]
}


0 replies

Be the first to reply!

Reply