on 08-06-2009 10:34 AM
Hi,
I have a JDBC to HTTP interface which should process the data based on the field from the database. This field contains an entire XML data and a particular tag in this XML decides whether the interface should process data or not..
Can you please tell me how to proceed with this?
Thanking you in advance,
Regards,
Krupesh Kuttappa
Edited by: Krupesh Kuttappa on Aug 6, 2009 11:37 AM
I am getting the following error
<SAP:Code area="RCVR_DETERMINATION">NO_RECEIVER_CASE_ASYNC</SAP:Code>
<SAP:P1 />
<SAP:P2 />
<SAP:P3 />
<SAP:P4 />
<SAP:AdditionalText />
<SAP:ApplicationFaultMessage namespace="" />
<SAP:Stack>No receiver could be determined</SAP:Stack>
when I am using the XPATH expression as /Table[not(contains(Field3, 'VALUE')]
Can anyone please help me?
Thanking you in advance
Regards,
Krupesh Kuttappa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am sorry i think i missed little information while showing the structure. Please find the updated structure.
<Table>
<Field1>Value1</Field1>
<Field2>Value2</Field2>
.
.
<Field3>......<field1>VALUE1</field1><field2>VALUE2</field2>..........</Field3>
.
.
</Table>
Field1, Field2 and Field3 are fields in the database table. Field3 contains XML data.
The number of tags inside the field Field3 is dynamic.
Currently I am trying with the XPATH expression "/Table[not(Field3.contains('VALUE')] EX"
Will let you know the result.
Thank you for your help.
Regards,
Krupesh Kuttappa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thank you all for your help.
My payload structure is
<Table>
<Field1>Value1</Field1>
<Field2>Value2</Field2>
.
.
<Field3><field1>VALUE1</field1><field2>VALUE2</field2></Field3>
.
.
</Table>
Field1, Field2 and Field3 are fields in the database table. Field3 contains XML data. Now I need to check for VALUE2 NOT EQUAL to VALUE. If this is the case then only I need to send the data to receiver.
Can you please share the XPATH expression for this?
Regards,
Krupesh Kuttappa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can achieve this by conditional receiver. In the receiver determination step, Put the condition on your deciding field. If the condition meet, the message will be processed else it will error out that no receiver found.
Shweta.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This field contains an entire XML data and a particular tag in this XML decides whether the interface should process data or not..
But my question is how to get the value of the Tag that I am intrested in.
<SRC><Name>SDN</Name><Forum>ProcessIntegration</Forum></SRC>
If the above is your field which contains an XML and you have to check for the tag <Forum> then, on the left operand select the field (SRC).....keep the operator as Contains Pattern.....and in the left Operand give the value as
*<Forum>*
This is a workaround......check if it works....refer this WIKI: https://wiki.sdn.sap.com/wiki/display/XI/XpathConditioninReceiverDetermination
Regards,
Abhishek.
Hi Krupesh,
If you have a complex condition then you can write a xpath on your own. Check this blog for some examples:
/people/shabarish.vijayakumar/blog/2006/06/07/customise-your-xpath-expressions-in-receiver-determination
If you couldnot figure out then let us know your condition and the sample payload so that somebody can help you out.
Regards,
---Satish
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.