Data Stitch: Repeating element path does not have a predicate for selecting 1 instance – Warning by Jorge Herreria
Blog: PaaS Community
The “Repeating element path does not have a predicate for selecting 1 instance.” warning message will come up on some stitch statements; specially on the “Variable” field. It means the Location Path XPath expression will select more than one instance and then the operation (Append or Assign) will fail at runtime.
In this blog I’ll try to explain how to read the warning and how to fix the expression.
There is a lot of XPath and XSD Schema lingo in this post; however I’ll try to explain it with less lingo that I can. Wish me luck.
Expect twisted humor here and there; more of then than none.
A quote that I like: “If you want to be free, stay anonymous…”
The meaning of the warning
Lets start peeling the onion (warning) into heads and tales and then put it back together… I’m going to use an example and simulate a conversation with you.
The example orchestration the $input_RESPOSE is a Shopping Cart. The Stitch statement with the warning is trying to assign 123.99 to the item’s price. See the pic below. Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.