Add a check of non existence in a API response

Question

i have this kind&nbsp;of API response :&nbsp;
&nbsp;
{"response": {"responsesRecherche": { &nbsp;&nbsp; "1":&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "consultation":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Id": "16391821108191", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "referenceFonctionnelle": "Dume OE US 78 - CTR016", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idTypeProcedure": "01", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idNatureMarket": "01", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idTypeMarket": "01" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "lot": [{"numeroLot": "016"}], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Opérateur Economique": {"id": "38103128500491"}, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Dume OE":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "dumeOEId": "mybmttmy", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "statutDume": "REMPLACE", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "nouveauDume":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "dumeOEId": "uxudjs9s", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "statutDume": "VALIDE", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "accessible": true, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de création": "2018-09-11 04:57:22", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de modification": "2018-09-11 04:57:22" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "accessible": true, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de création": "2018-09-11 04:57:00", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de modification": "2018-09-11 04:57:22" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp; }, &nbsp;&nbsp; "2":&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "consultation":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Id": "56559466095920", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "referenceFonctionnelle": "Dume OE US 78 - CTR016", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idTypeProcedure": "01", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idNatureMarket": "01", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idTypeMarket": "01" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "lot": [{"numeroLot": "03"}], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Opérateur Economique": 18, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Dume OE":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "dumeOEId": "qo92j8tt", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "statutDume": "VALIDE", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "accessible": true, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de création": "2018-09-11 04:12:02", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de modification": "2018-09-11 04:12:02" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp; },...
...
&nbsp; &nbsp;"50":&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "consultation":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Id": "31739414944098", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "referenceFonctionnelle": "Dume A - CTR021", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idTypeProcedure": "01", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idNatureMarket": "01", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "idTypeMarket": "01" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "lot": [{"numeroLot": "78"}], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Opérateur Economique": 18, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Dume OE":&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "dumeOEId": "7bewwsrj", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "statutDume": "VALIDE", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "accessible": true, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de création": "2018-09-13 08:41:44", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Date de modification": "2018-09-13 08:41:44" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp; },}}}
&nbsp;
I have to check creation dates of the Dume OE object. "Date de création" in french.&nbsp;
So my following script works perfectly when all Dume OE objects are complete recorded.
But we have new problem, API returns incomplete response for some Dume OE :&nbsp;
&nbsp;&nbsp; "42":&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "consultation": "16391821108191", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "lot": [{"numeroLot": "03"}], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Opérateur Economique": 18, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Dume OE": "uxudjs9s" &nbsp;&nbsp; }, there is no information on Dume OE object. I have to add a IF which check "date de création" existence,
before check his format and value.. I try "contains" method, but i have groovy error :(
&nbsp;
My script :&nbsp;
&nbsp;
import net.sf.* import net.sf.json.* import net.sf.json.groovy.* import com.eviware.soapui.support.XmlHolder def GU = new com.eviware.soapui.support.GroovyUtils( context )
def Response = context.expand ( '${CP_CTR006_DateDebutSansDateFin#Response}').toString() def Slurp = new JsonSlurper().parseText(Response) &nbsp;.response.responsesRecherche &nbsp;.collect {keyname, keyvalue -&gt; keyvalue } // créé la liste de valeurs derrière le compteur &nbsp;.collect { it."Dume OE"} &nbsp; def cpt = Slurp.size() log.info " Dates trouvées = " + cpt
def i=0 checkdate = true def testdate = testRunner.testCase.testSuite.getProperty("DateCreation").valuetestdate = testdate.substring(1,11)testdate = testdate + " 00.00.00" while (i&lt;cpt &amp;&amp; checkdate==true) {
// TO DO : Add condition IF "Date de création" not exist in Slurp[i] object before check date &nbsp;if (Slurp[i]."Date de création" &lt; testdate) {checkdate = false } &nbsp;&nbsp;assert checkdate &nbsp; &nbsp;i++ } if (checkdate) {log.info "Toutes les dates sont postérieures à " + testdate }
&nbsp;
It is not hard but i am weak with collection objects :(

luluberlu · Accepted Answer

hi.
I try but it don't work. same error "groovy.lang.MissingPropertyException: No such property: Date de création for class: java.lang.String
I try this just after :&nbsp;
if (Slurp[i].("Date de création")) { &nbsp;&nbsp;if (Slurp[i]."Date de création" &lt; testdate) {checkdate = false } &nbsp;&nbsp;assert checkdate &nbsp; &nbsp;i++} }
but i got the same error :(&nbsp;
i think i should use "contains" method rightly.&nbsp;

jhunt · Answer

Hi,
You can use this, and this pattern is used quite often:
 if (Slurp[i]."Date de création" &amp;&amp; Slurp[i]."Date de création" &lt; testdate) {checkdate = false }
First it will check the conditiion on the left - if there's a value for the date, the left will be satisfied and then it goes on to check the date dagainst the test date. 
&nbsp;
But if there's no date returned, the condition on the left will fail, and so the whole thing will be false. In that case, the check on the right won't actually be calculated (which is good, because it means it won't throw an exception for trying to compare nothing to the testdate).

luluberlu · Answer

i found solution this noon.
i coudld not test key existence correctly. i try with Slurp[i].containsKey("Date de création"] and it dont works also :(
So i convert my object into a string and use indexof method, and it is ok now. not perfect but it works.
&nbsp;
def Str = Slurp[i].toString()
def DC = Str.indexOf("Date de création")
if (DC == -1) { log.info "ATTENTION..."
else {&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; if Slurp[i]."Date de création" &lt; tesdate) {
...
}}

Forum Discussion

Add a check of non existence in a API response

3 Replies

Related Content

[solved] check response attrtibutes

Check if item exists

check an item exists in the dropdown list

How to check that an image Region does not exist any longer?

Require condition to check depending upon the Json Node response

Recent Discussions

SOAP Request works in SoapUI, but not in C# code

How to configure Swagger in Paas to use it in Oracle APEX instance.

log4j1.x vulnerability

Soapui 5.7.1 dependency : thoughtworks:xstream:jar:1.4.20

SoapUI OSS apidocs are outdated in April 2024