Forum Discussion

maddenapally's avatar
maddenapally
Contributor
7 years ago

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

4 Replies

  • nmrao's avatar
    nmrao
    Community Hero
    7 years ago
    You can verify.
    More details of the issue, please?
    How could some one understand your issue with the given description?

    • maddenapally's avatar
      maddenapally
      Contributor
      7 years ago

      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
        Community Hero
        7 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