Forum Discussion

maddenapally's avatar
maddenapally
Contributor
6 years ago

I want to map JSON Request objects to Oracle database column's, Need to do verify?

maddenapally's avatar
maddenapally
Contributor

Thanks Rao :smileyhappy:,  

 

I want to verify How is the data inserting into DB Columns from JSON Request. 

For Example: I have property name the should be goes to property column, I have to verify.

Please find the attached file for more information.

 

Regards,

Karthik

nmrao's avatar
nmrao
Champion Level 3
6 years ago

Thank you for the screen shot, maddenapally 

 

Still not clear what steps does the test case has? and where would you like to use the requested map?

 

Anyways, below is the way to map in groovy script as per the screen shot

 

def map = [action: 'HTL_SELL_START.HTL_CD',
           chainCode: 'HTL_SELL_START.SELL_START_CD',
	   brandCode: 'HTL_SELL_START.SELL_START_NM',
           propertyCode: 'HTL_SELL_START.SELL_START_DESC'
           propertyName: 'HTL_SELL_START.BEG_DT']

For example if the test case contains

1. REST Request step with POST method

2. JDBC step to retrieve the data

And the objective is to verify, then have a look script here