How to create the Error description?

[Former Member]

Hi Experts,

Scenario : Webservice -> XI -> JDBC (Synh)

Pass the EmpId as a webservice request and get the corresponding Emp address as a response.

Q: How to set the error description/error message, If we don't have address info. for the requested EmpId?

Regards

Sara

[Former Member · Accepted solution]

Hi

I believe you should be able to do that in the "response" message mapping by checking the value for the address node and after that set the value of the response to say "Invalid id" or something

regards

krishna

[Former Member · Accepted solution]

Hi Krishna,

Could you please provide one example for this error message creation?

Regards

Sara

[bhavesh_kantilal · Accepted solution]

Sara,

The response of the JDBC request in this case will not have a ROW tag created.

In the message mapping you can check for the occurence of the ROW tag and if there is no ROW tag then you can create the target error strcuture.

Regards

Bhavesh

[Former Member]

Are you using integration process?

[Former Member]

No Rajesh, I am not using Integration Process.

[Former Member]

Hi Sara,

You would have mapped the response mapping from the result of the JDBC select to the outbound message type.

In the response mapping, if you can check if the value of the resultset is "null", which means there is no address for the ID. In that case you can change the result to be some custom error message.

You would be needing to use the standard boolean function "if" and a standard "Constant" function, where you would enter your custom error message and map the output of the if condition to the source/outbound element node.

regards

krishna