Modifying JDBC response to compare with JSON input

[Aplis]

Hello,

I have a JDBC step, where it returns empty tags if no data is present on the table. Then am comparing this repsosne to excel (datasource) using assertions where my REST input value is NULL.

How do i compare an empty tag to a  NULL input ? Also the fields are dynamic where they may have data or jus returns empty tags.

Can anyone help me with this.?Thanks in advance for your time.. 

 Grrovy that i came up with . Not sure if am on right path or not .. 

def ActualSourceCode = context.expand( '${CTL_RAD#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/SOURCE_CODE[1]}' )
log.info "JDBCSourceCode= $ActualSourceCode"

def ExpectedSourceCode = context.expand( '${DataSource#SourceCode1}' )
log.info "EXCELSourceCode= $ExpectedSourceCode"

if(ActualSourceCode == 'NOVALUE')
{

ExpectedSourceCode = 'NOVALUE'
assert ExpectedSourceCode == ActualSourceCode
log.info "SourceCodeNotEntered = $ActualSourceCode"
}
else
{
assert ExpectedSourceCode == ActualSourceCode
log.info "SourceCodeEntered = $ActualSourceCode"
}

[Olga_T]

Hi @Aplis, thanks for reaching out!

Community, can anyone look into the above code please? Any suggestions on how to implement the task?

[Nastya_Khovrina]

Please check this article which may help you: https://smartbear-cc.force.com/portal/KbArticleViewer?name=How-Do-I-Compare-Two-Dynamic-JSON-Respons...

[AlexKaras]

Hi,

You may also consider custom formatting options of JsonSlurper to adjust json contents: http://groovy-lang.org/json.html