Resource Query Node Syntax

Trying to query using the resource node to verify if a user exists in security. When I hard-code the ID value (jsmith), I get data back, but when I use an IPA variable (<!RMID>), I get nothing. I verified the value for my variable and it's the right value/case before the resource query node (RMID=jsmith). So, what parenthesis, brackets, curly brace syntax do I need to make the following work?

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<TRANSACTION user="lawson" method="getRMQuery">
<OBJECT><![CDATA[People]]></OBJECT>
<ATTRIBUTES><ATTRIBUTE><![CDATA[ID]]></ATTRIBUTE>
<ATTRIBUTE><![CDATA[Email]]></ATTRIBUTE>
<ATTRIBUTE><![CDATA[Name]]></ATTRIBUTE>
<ATTRIBUTE><![CDATA[PortalRole]]></ATTRIBUTE>
<ATTRIBUTE><![CDATA[Role]]></ATTRIBUTE>
</ATTRIBUTES>
<WHERE><![CDATA[({ID}=<!RMID>)]]></WHERE> Works when: <WHERE><![CDATA[({ID}=jsmith)]]></WHERE>
<OUTPUTSERVICEATTRS/></TRANSACTION>

Thanks in advance!

Natacha

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

unknown

Try putting double quotes around the value jsmith. RMID="jsmith"

unknown

Do this: trim(RMID.toLowerCase())

rm_benefit_administration_aca_training.pptx

unknown

Your syntax looks fine. There is an issue with RMQuery depending upon the version of IPA installed. What version of Landmark/IPA are you running? You may want to check with Infor Xtreme to see if this was corrected in your version.

unknown

When I hard code the value, I don't need quotes around jsmith - I get data. I tried adding double quotes around the "<!RMID>" variable and I still get no results.

unknown

I am running 10.1.1.70. I'll check with XTreme. Thanks!

unknown

What I mean is where ever you are setting the value for RMID you need to surround the value with double quotes. I have to do this when it is a string variable or it won't work.

0904080826502268.xls

clin

Try printing the variable <!RMID> in MsgBulider node and see if printed jsmith with or without double quotes. if printed with double quote then the issue in variable assignment.

unknown

Our use of Resource Query in limited. We use it to look up information on the Managed Identities section. For that, we use a variable, ldapValue, against the SERVICE. This allows us access to SSOP, EMPLOYEE, etc. Then retrieve what we want. Below is example of 'ssop' as value for 'ldapValue' to retrieve email and name.

<?xml version="1.0"?>

<TRANSACTION user="daServletUser" method="getRMQuery"><SERVICE><![CDATA[<!ldapValue>]]></SERVICE><SERVICEATTRS><SERVICEATTR><NAME><![CDATA[USER]]></NAME><VALUE><![CDATA[<!lsf_ID>]]></VALUE></SERVICEATTR></SERVICEATTRS><OBJECT><![CDATA[People]]></OBJECT><ATTRIBUTES><ATTRIBUTE><![CDATA[Email]]></ATTRIBUTE><ATTRIBUTE><![CDATA[FirstName]]></ATTRIBUTE><ATTRIBUTE><![CDATA[LastName]]></ATTRIBUTE></ATTRIBUTES><OUTPUTSERVICEATTRS/></TRANSACTION>

robert-canham

Did you check your log in either the designer console or the work unit? That should show you the variable replacement done and may make the issue easier to see.

unknown

Thanks for the suggestion! I added the MsgBuilder and found that my variable value had a carriage return at the end. I trimmed the string and now get data back with the following syntax (NO QUOTES):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><TRANSACTION user="lawson" method="getRMQuery"><OBJECT><![CDATA[People]]></OBJECT><ATTRIBUTES><ATTRIBUTE><![CDATA[ID]]></ATTRIBUTE><ATTRIBUTE><![CDATA[Email]]></ATTRIBUTE><ATTRIBUTE><![CDATA[Name]]></ATTRIBUTE></ATTRIBUTES><WHERE><![CDATA[({ID}=<!RMID>)]]></WHERE><OUTPUTSERVICEATTRS/></TRANSACTION>

Copyright © 2025 Infor. All rights reserved.