SoapUI Pro (Automate JSon payload)

[KBTokzan]

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

[Lucian]

Hi,

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

[KBTokzan]

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]

Sorry forgot to attached the picture

[Lucian]

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

[KBTokzan]

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]

Ok, I am sorry but I still don't know exactly what you are trying to extract.  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)

[Olga_T]

Hi all,

@Lucian, thanks for trying to figure it out 

@KBTokzan, was the assumption above correct? Do the steps help you?

[KBTokzan · Accepted solution]

Hi @Olga_T,

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

Thanks,

KB Tokzan