Forum Discussion

KBTokzan's avatar
KBTokzan
Occasional Contributor
7 years ago

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 eventC...
  • KBTokzan's avatar
    KBTokzan
    7 years ago

    Hi Olga_T,

     

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

     

    Thanks,

    KB Tokzan

     

Lucian's avatar
Lucian
Community Hero
7 years ago

Hi,

 

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

  • KBTokzan's avatar
    KBTokzan
    Occasional Contributor
    7 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
      7 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
      • Lucian's avatar
        Lucian
        Community Hero
        7 years ago

        Ok, I am sorry but I still don't know exactly what you are trying to extract. :smileyhappy: Nevertheless there is a Property Trasnfer step in SoapUI. So you could:

         

        1. Create a TestCase property (see more about properties here);

        2. Add a Property Transfer step 

        3. Reference the property wherever you need. (info about referencing properties are also in the link I provided)

  • KBTokzan's avatar
    KBTokzan
    Occasional Contributor
    7 years ago

    Sorry forgot to attached the picture

    • Lucian's avatar
      Lucian
      Community Hero
      7 years ago

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