Need to create an interface that would pick data from a staging table and based on that i need to insert value into the SIT.The SIT has three valuset.
1> need to check the value that is coming from stagimg table to match with value present in value set.
the first valus set is independent based on the value in the first valuset the second valueset value will popluate and then the third one will populate based on second valuset.

Please suggest as how i should I check the validaation and accordingly insert value in the api.

You could let the API do the work for you - it will validate the data for you using whatever rules are in place. Just make sure you report any errors as fully as you can. If your staging table had an error message column, for example, you could then write the error (if there was one) back to the row that was being processed when the error occurred.

Thanks for your reply but this would not serve my purpose.
Please suggest how can i validate the values for the three value set.

---Teena