<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi Tao,</div><div><br data-mce-bogus="1"></div><div>You just need to add the name of the attribute which should be included as a parameter of the "get()" method. In this case the line of code would look something like this:</div><div><br data-mce-bogus="1"></div><div>LookupTableType lt = service.lookupTables().oid("b04a994d-ee4f-4c5b-86e7-045e5a5e6af0").get(null, Collections.singletonList("row"), null);<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Hope this helps.</div><div><br data-mce-bogus="1"></div><div> <!--StartFragment--><div data-marker="__SIG_POST__" style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-mce-style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">--<br></div><div style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-mce-style="color: #000000; font-family: arial, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Best Regards,<br><br>Matus Macik | Developer and Identity Management Engineer<br>matus.macik@evolveum.com | www.evolveum.com<br>Evolveum</div><!--EndFragment--> </div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"Tao Jiang" <t.jiang@unsw.edu.au><br><b>To: </b>"Matus Macik" <matus.macik@evolveum.com>, "midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>Sent: </b>Thursday, February 24, 2022 5:47:59 AM<br><b>Subject: </b>RE: [midPoint] Search look up table using Midpoint Java Rest Client 4.4<br></div><div><br><style>/*<![CDATA[*/p.MsoNormal, li.MsoNormal, div.MsoNormal {
margin: 0.0cm;
font-size: 11.0pt;
font-family: Calibri , sans-serif;
}
a:link, span.MsoHyperlink {
color: rgb(5,99,193);
text-decoration: underline;
}
span.EmailStyle20 {
font-family: Calibri , sans-serif;
color: windowtext;
}
*.MsoChpDefault {
font-size: 10.0pt;
}
div.WordSection1 {
page: WordSection1;
}
/*]]>*/</style></div><div data-marker="__QUOTED_TEXT__">
<div class="WordSection1">
<p class="MsoNormal">Hi Matus,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thank you for fixing this. I have got the latest code and it works.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">But I am now having trouble getting the lookup table rows. Could you please help with this?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">When running command line, I need to add “include=row” to retrieve lookup table rows data. Not sure if there is something in java that does this.</p>
<p class="MsoNormal">curl --user admin:Zisssssssss -X GET <a href="https://host:443/midpoint/ws/rest/lookupTables/b04a994d-ee4f-4c5b-86e7-045e5a5e6af0?include=row" target="_blank" rel="nofollow noopener noreferrer">
https://host:443/midpoint/ws/rest/lookupTables/b04a994d-ee4f-4c5b-86e7-045e5a5e6af0?include=row</a></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">My dummy java code below only return size =1 with null values. There are many rows in the Lookup table.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">public</span></b><span style="font-size:10pt;font-family:'consolas';color:black">
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">void</span></b><span style="font-size:10pt;font-family:'consolas';color:black"> load<span style="background:#ceccf7">Lookup</span>Table()
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">throws</span></b><span style="font-size:10pt;font-family:'consolas';color:black"> Exception {<!-- --></span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> Service
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">service</span><span style="font-size:10pt;font-family:'consolas';color:black"> = getService();</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> List<LookupTableRowType>
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableList</span><span style="font-size:10pt;font-family:'consolas';color:black"> =
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">service</span><span style="font-size:10pt;font-family:'consolas';color:black">.lookupTables().oid(</span><span style="font-size:10pt;font-family:'consolas';color:#2a00ff">"b04a994d-ee4f-4c5b-86e7-045e5a5e6af0"</span><span style="font-size:10pt;font-family:'consolas';color:black">).get().getRow();</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas'"> </span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> System.</span><b><i><span style="font-size:10pt;font-family:'consolas';color:#0000c0">out</span></i></b><span style="font-size:10pt;font-family:'consolas';color:black">.println(</span><span style="font-size:10pt;font-family:'consolas';color:#2a00ff">"Lookup
table size:"</span><span style="font-size:10pt;font-family:'consolas';color:black"> +
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableList</span><span style="font-size:10pt;font-family:'consolas';color:black">.size()); //this line retured: Lookup table size:1</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">for</span></b><span style="font-size:10pt;font-family:'consolas';color:black">(</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">int</span></b><span style="font-size:10pt;font-family:'consolas';color:black">
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">i</span><span style="font-size:10pt;font-family:'consolas';color:black">=0;
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">i</span><span style="font-size:10pt;font-family:'consolas';color:black"><</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableList</span><span style="font-size:10pt;font-family:'consolas';color:black">.size();
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">i</span><span style="font-size:10pt;font-family:'consolas';color:black">++) {<!-- --></span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> LookupTableRowType
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableRowType</span><span style="font-size:10pt;font-family:'consolas';color:black"> =
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableList</span><span style="font-size:10pt;font-family:'consolas';color:black">.get(</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">i</span><span style="font-size:10pt;font-family:'consolas';color:black">);</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> System.</span><b><i><span style="font-size:10pt;font-family:'consolas';color:#0000c0">out</span></i></b><span style="font-size:10pt;font-family:'consolas';color:black">.println(</span><span style="font-size:10pt;font-family:'consolas';color:#2a00ff">"lookup
key="</span><span style="font-size:10pt;font-family:'consolas';color:black"> + </span>
<span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableRowType</span><span style="font-size:10pt;font-family:'consolas';color:black">.getKey());
</span><span style="font-size:10pt;font-family:'consolas';color:#3f7f5f">//this line returned: lookup key=null</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> System.</span><b><i><span style="font-size:10pt;font-family:'consolas';color:#0000c0">out</span></i></b><span style="font-size:10pt;font-family:'consolas';color:black">.println(</span><span style="font-size:10pt;font-family:'consolas';color:#2a00ff">"lookup
label="</span><span style="font-size:10pt;font-family:'consolas';color:black"> +
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">lookupTableRowType</span><span style="font-size:10pt;font-family:'consolas';color:black">.getLabel().getContent().get(0));
</span><span style="font-size:10pt;font-family:'consolas';color:#3f7f5f">//this line threw: NullPointerException</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas'"> </span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> }</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">
</span><span style="font-size:10pt;font-family:'consolas'"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> }</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thank you very much!</p>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Kind regards,</span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black"> </span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Tao Jiang</span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">UNSW IT</span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Email: <a href="mailto:t.jiang@unsw.edu.au" target="_blank" rel="nofollow noopener noreferrer">
t.jiang@unsw.edu.au</a></span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Phone: </span><span style="font-size:12pt;color:#252423;background:#fafafa">+61 2 9065 8771</span></p>
</div>
<p class="MsoNormal"> </p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Matus Macik <matus.macik@evolveum.com>
<br>
<b>Sent:</b> Thursday, 24 February 2022 1:54 AM<br>
<b>To:</b> midPoint General Discussion <midpoint@lists.evolveum.com><br>
<b>Cc:</b> Tao Jiang <t.jiang@unsw.edu.au><br>
<b>Subject:</b> Re: [midPoint] Search look up table using Midpoint Java Rest Client 4.4</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">Hello,</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">I tried the code snipped and actually it's a bug in the MidPoint Client I was able to reproduce. I have created a Jira issue under <a href="https://jira.evolveum.com/browse/MID-7686" target="_blank" rel="nofollow noopener noreferrer">https://jira.evolveum.com/browse/MID-7686</a> and
also already pushed a fix. You should find it on the current master branch of the MidPoint Client project. </span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">--</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">Best Regards,<br>
<br>
Matus Macik | Developer and Identity Management Engineer<br>
<a href="mailto:matus.macik@evolveum.com" target="_blank" rel="nofollow noopener noreferrer">matus.macik@evolveum.com</a> | <a href="http://www.evolveum.com" target="_blank" rel="nofollow noopener noreferrer">
www.evolveum.com</a><br>
Evolveum</span></p>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">
<hr size="2" width="100%" align="center" id="zwchr">
</span></div>
<div>
<p class="MsoNormal"><b><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">From:
</span></b><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black">"midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank" rel="nofollow noopener noreferrer">midpoint@lists.evolveum.com</a>><br>
<b>To: </b>"midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank" rel="nofollow noopener noreferrer">midpoint@lists.evolveum.com</a>><br>
<b>Cc: </b>"Tao Jiang" <<a href="mailto:t.jiang@unsw.edu.au" target="_blank" rel="nofollow noopener noreferrer">t.jiang@unsw.edu.au</a>><br>
<b>Sent: </b>Monday, February 21, 2022 7:14:05 AM<br>
<b>Subject: </b>[midPoint] Search look up table using Midpoint Java Rest Client 4.4</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Dear Midpoint community,</span></p>
<p class="MsoNormal"><span style="color:black"> </span></p>
<p class="MsoNormal"><span style="color:black">I have tried to use Midpoint Java Rest Client (version 4.4) to search Look up table using the code below:</span></p>
<p class="MsoNormal"><span style="color:black"> </span></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">public</span></b><span style="font-size:10pt;font-family:'consolas';color:black">
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">void</span></b><span style="font-size:10pt;font-family:'consolas';color:black"> searchLookupTable()
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">throws</span></b><span style="font-size:10pt;font-family:'consolas';color:black"> Exception {<!-- --></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> Service
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">service</span><span style="font-size:10pt;font-family:'consolas';color:black"> = getService();</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> ItemPathType
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">namePath</span><span style="font-size:10pt;font-family:'consolas';color:black"> =
</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">new</span></b><span style="font-size:10pt;font-family:'consolas';color:black"> ItemPathType();</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">namePath</span><span style="font-size:10pt;font-family:'consolas';color:black">.setValue(</span><span style="font-size:10pt;font-family:'consolas';color:#2a00ff">"name"</span><span style="font-size:10pt;font-family:'consolas';color:black">);</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> SearchResult<LookupTableType>
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">result</span><span style="font-size:10pt;font-family:'consolas';color:black"> = (SearchResult<LookupTableType>)
</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">service</span><span style="font-size:10pt;font-family:'consolas';color:black">.lookupTables().search().queryFor(LookupTableType.</span><b><span style="font-size:10pt;font-family:'consolas';color:#7f0055">class</span></b><span style="font-size:10pt;font-family:'consolas';color:black">).item(</span><span style="font-size:10pt;font-family:'consolas';color:#6a3e3e">namePath</span><span style="font-size:10pt;font-family:'consolas';color:black">).eq(</span><span style="font-size:10pt;font-family:'consolas';color:#2a00ff">"UAC
Lookup"</span><span style="font-size:10pt;font-family:'consolas';color:black">).get();</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">
</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> }</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">
</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">The last statement ran into java.lang.NullPointerException.
</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">I can confirm the “UAC Lookup” look up table exists by execute the following query via curl command.</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"><query xmlns=<a href="http://prism.evolveum.com/xml/ns/public/query-3" target="_blank" rel="nofollow noopener noreferrer">http://prism.evolveum.com/xml/ns/public/query-3</a>></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> <filter></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> <equal></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> <path>name</path></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> <value>UAC Lookup</value></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> </equal></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> </filter></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"></query></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">Could anyone tell me what’s wrong with the java code?</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:'consolas';color:black">Thank you very much in advance!</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black"> </span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Kind regards,</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Tao Jiang</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">UNSW IT</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Email: <a href="mailto:t.jiang@unsw.edu.au" target="_blank" rel="nofollow noopener noreferrer">
t.jiang@unsw.edu.au</a></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="font-size:12pt;color:black">Phone: </span><span style="font-size:12pt;color:#252423;background:#fafafa">+61 2 9065 8771</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black"> </span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'arial' , sans-serif;color:black"><br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank" rel="nofollow noopener noreferrer">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank" rel="nofollow noopener noreferrer">https://lists.evolveum.com/mailman/listinfo/midpoint</a></span></p>
</div>
</div>
</div></div><div data-marker="__SIG_POST__"><br data-mce-bogus="1"></div></div></body></html>