Forum Discussion

KBTokzan's avatar
KBTokzan
Occasional Contributor
6 years ago
Solved

SoapUI Pro (Automate JSon payload)

Hi Guys,

 

I am new on SoapUI pro, here is the scenario.

 

I have four methods namely (create, update, delete, and get) for the event service, so from my update json I need to pass the eventCode which is generated from the create Method.

 

I am able to connect to the DB and I am also aware of the datasource and JDBC Request.

 

Can you please suggest a way or a link on how I can achieve this.

 

Thanks in advance,

KB Tokzan

  • KBTokzan's avatar
    KBTokzan
    6 years ago

    Hi Olga_T,

     

    Yes it did .. I managed to solve my problem by using the property transfer ..

     

    Thanks,

    KB Tokzan

     

8 Replies

Sort By
  • Lucian's avatar
    Lucian
    Community Hero
    6 years ago

    Hi,

     

    Can you please share a sample response from the jdbc request?

    • KBTokzan's avatar
      KBTokzan
      Occasional Contributor
      6 years ago

      Hi Lucian,

       

      Thanks for the reply, please see the screen for from my jdbc response,

       

      To update the very same results I need to pass the event code in my json (below)

       

      {
      "unitOfMeasureDescription": "RedesignUpdate",
      "unitOfMeasureBusinessDescription": "RedesignUpdate",
      "unitOfMeasureCode": "UOM-Rede",
      "unitOfMeasureUnit": "cm",
      "dataType": {
      "dataTypeCode": "DECIMAL"
      },
      "effectiveFromDate": "2018-09-03",
      "effectiveToDate": "2999-12-31"
      }

       

      I can update any parameter aslong as I am passing the correct/existing code.

       

      As I mentioned I need to find a way that I can be able to read the code from the DB and pass it to my json without doing it manually, bacause we have to intergrate this with jenkins

       

      Thanks,

      KB Tokzan 

       

       

      • KBTokzan's avatar
        KBTokzan
        Occasional Contributor
        6 years ago
        I am referring to "unitOfMeasureCode" by eventCode .. the code is is also stored on the DB if you can refer to my screenshot attachment
    • KBTokzan's avatar
      KBTokzan
      Occasional Contributor
      6 years ago

      Sorry forgot to attached the picture

      • Lucian's avatar
        Lucian
        Community Hero
        6 years ago

        I am sorry. I don't get what that event code is. Can you help me out here?