mule returning primary key on successful insert
<p>Hi there I'm new to Mule and I needed pointer on how to process records. I'm trying to perform an operation where I insert a new record into one table and if the record is inserted successfully, obtain the primary key and insert it into another table where the primary key is part of the foreign key. </p>

<p>I don't know which connector or component to use to check if an insert was successful so that I can insert the primary key into another table. </p>

<p>My primary key is a uuid generated as a variable. I tried returning the GUID from sql server using using the following documentation but it didn't work. Any help or pointers on either question will help.</p>

<p><a href="https://doctorjw.wordpress.com/2015/10/01/mule-and-getting-the-generated-id-of-a-newly-inserted-row/" rel="nofollow">https://doctorjw.wordpress.com/2015/10/01/mule-and-getting-the-generated-id-of-a-newly-inserted-row/</a></p>