Aras - ECO Impact Matrix - Email body additional fields mapping

Offline Senthurpari Sargunam 8 months ago

Hello Aras experts,

I am currently working on customizing the Aras ECO e-Mail settings. Currently, the workflow triggers fields such as Activity, Instructions, Eco number, and Title in the email content. However, I've received a request from our business users to incorporate more information from the ECO impact matrix. Integrating fields like ChangeReason and Description was straightforward, as they are available in the same API call as the email query string.

On the other hand, attempting to retrieve details from the ECO Impact matrix (ECO-PartBOM) presents a challenge. This requires a separate API that takes the ECO's ID as input and responds with the associated ECO PartBOM information. This matrix includes data like PartBOM number, PartBOM name, Classification, subClass, Unit, and more.

I've constructed an AML query string, but I've encountered difficulty when trying to insert the Indexed xPath Item ID, specifically using the format id="${Item[2]/@id}". This action results in an exception, leading to the failure of the API execution.

I have a couple of inquiries:
1) Could someone kindly assist me in accessing the ECO ID or provide a potential solution for achieving this dynamic parameter insertion?
2) Is there a method to view the complete API RESPONSE and xPath directly on the page?

My query String: ( The bold AML ID has the problem in Xpath access )

<Item type="Activity" id="${Item/ActivityId}" action="get" select="name,message"/>
<Item type="${Item/@type}" id="${Item/@id}" action="get" select="item_number,title,id,change_reason,description"/>
<Item type="ItemType" id="${Item/@typeId}" action="get" select="label,name"/>
<Item type="Express ECO" id="${Item[2]/@id}" relName="Express ECO Affected Item" action="getItemRelationships">
<related_id>
<Item>
<Relationships>
<Item type="Affected Item Property" action="get" select="new_item_id"></Item>
</Relationships>
</Item>
</related_id>
</Item>

My HTML body:

<BODY>

You have been assigned a new change management activity in Aras Innovator (details below). Please log in to Aras to complete the work.
Activity: ${Item[@type="Activity"]/name} 
Instructions: ${Item[@type="Activity"]/message}
${Item[@type="ItemType"]/label}: ${Item[2]/item_number} 
Title: ${Item[2]/title} 
Change Reason: ${Item[2]/change_reason} 
Description: ${Item[2]/description} 


${substring("Some information needed to form this email was not found. Please contact your system administrator to ensure that the sender has privileges to view the items.", 1, (1-count(Item[2]))*158)}

<query_string>Type: ${Item/@type}</query_string>
<query_string>ID : ${Item/@id}</query_string> 
<query_string> ECO ID : ${Item[2]/id} <query_string>
</BODY>

Notification details:

Item[2]/@id error screen shot(xpath doesnot support for such index)

ECO Impact matrix screenshot ( these fields needs to access through AML and map HTML body.

Regards,

S. Senthurpari

Offline alaxala 8 months ago

Try to remove "[2]" in your query string. There is only one item in the context of query strings. But each of the query result is a separate item in the context of body. So your last query will be Item[4] in the body.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Senthurpari Sargunam 8 months ago in reply to alaxala

Thanks, Is there any way/solution to see the RESPONSE ? I would like to explore the xPath ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline alaxala 8 months ago in reply to Senthurpari Sargunam

You can use Aras Nash or InnovatorAdmin
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Senthurpari Sargunam 8 months ago in reply to alaxala

Hi Alaxala,

No, Let me rephrase my question. In the email notification I am able to print the <Query_string> in HTML_BODY. Meaning, I am able to see what this dynamic Query_string parameter framed as REQUEST in the incoming email. But after API render, email body consumes, xPath and mapped the RESPONSE fields inside tag.

I would lke to see the complete response such html_body. Is there any possibility to see the RESPONSE ?

Regards,

S. Senthurpari
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Senthurpari Sargunam 6 months ago in reply to Senthurpari Sargunam

Hi All,
This problem was already solved. We can achieve this result by calling the c# method in action
For example querystring
<Item type="${Item/@type}" id="${Item/@id}" action="c#methodname" select="impactmatrix"/>
then you can find xPath in HTML body and bind the fields

Regards,

S. Senthurpari
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel