Boomi Integration Tip: Working with dynamic and static database parameters

In boomi if you want to run an INSERT/UPDATE/QUERY operation in a connector shape you probably will need to use a ‘?’ as a dynamic parameter. In figure 1 we can see that the number of ‘?’ is exactly the same as the number of the fields (highlighted in blue).  In this situation the SQL statetment will work without any error.

 

 

 

 

If we need to use both dynamic and static parameters at the same time, and we use the same technique as above, with a static parameter, we get the following:

 

 

 

 

This will result in the error “First document failure: Invalid column index” :

 

 

 

 

The solution is to remove the static ‘CREATED_TAD’ field from the parameter but leave it in the SQL statement:

 

 

 

Get in touch today to see how WDCi can help your business.