Asserting NULL values
I'm doing comparison of values in Oracle database on one end and the service at the other. There are attributes which return NULL value and those same attributes are not found in the service response...
Forum Discussion
Instead, please to try JSONPath count assertion.
Thing is, I cannot be certain that the response will be returned NULL and when it's a non-NULL value, I need the assertion, so I need one that would cover both cases.
- Hmm.
And want non scripting solution.
Not good at JSONPath. May be you can show sample response along what data needs to be asserted.Unfortunately, I cannot share the response cause of the NDA, but here's an example of what it might look like:
{
"list":{
"attribute" : someValue
}
}
And the SQL query 'select attribute from table' returns the value 'someValue'.
Now let's say that the attribute from the SQL query returns '(null)', in that case the 'list' node would not contain the 'attribute' element.
Funny thing is that when you reference a non-existing element in the REST request, it returns an empty string, which should be perfect and it's the same when you reference a NULL value in the JDBC request, but they just won't match for some reason.
- You can show with dummy values with same structure to avoid confusion later to relate to actual case.
By the way, list representation is incorrect.
Any specific reason you don't want do in Script?
