Let me explain my situation. I recieve via a queue an XML file which will affect three different tables using ODATA RESTful services.
My logical conclusion to simplify the ODATA schema (instead of doing a batch) is to redirect the XML into three local proxys with different XQuery transformations. Then these proxys will call out the Web Services to update the database.
Can anyone help me? Can I use a for-each loop within a route node or is there another way to do this?
There are 3 options to route a payload/request to multiple different services (local proxies in your case) -
I believe using 3 Publish actions is most suitable for your use-case.