cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Contributor

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

 
4 REPLIES 4
Highlighted
Community Hero

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

You can verify.
More details of the issue, please?
How could some one understand your issue with the given description?



Regards,
Rao.
Highlighted
Community Hero

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

Please see if the below sample and apply it to your need
https://github.com/nmrao/soapUIGroovyScripts/blob/master/groovy/compare/JdbcAndJsonCompare.groovy


Regards,
Rao.
Highlighted
Contributor

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

Thanks Rao Smiley Happy,  

 

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

Highlighted
Community Hero

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

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



Regards,
Rao.
New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Compete with community members in the TechCorner Challenge and get into the Leaderboard!

Rank Participant Points Earned
1 msiadak 12
2 nmrao 8
3 HimanshuTayal 3
Top Kudoed Authors