title: How do you add multiple input parameters to database connector in Mule
body: <p>I am using Anypoint Studio 7.3 and Mule 4.1.</p>
  
  <p>I am using the database bulk insert connector and I would like to pass in multiple input parameters into the SQL insert.</p>
  
  <p>I have added multiple input parameters using the following syntax </p>
  
  <pre><code>{payload: payload, tableName: vars.tblName, username: vars.username}
  </code></pre>
  
  <p>but I get the error below and also not sure how I should reference the values in the payload is is still :Code or payload.Code: </p>
  
  <blockquote>
    <p>Cannot coerce Object ({payload: [{Code: "1",Name: "test1",Co...) to Array</p>
  </blockquote>
  
  <p>The configuration I am using is: </p>
  
  <pre><code>        &lt;db:bulk-insert doc:name="Bulk Insert" doc:id="36328b21-ffd9-485e-8afa-34b6cb742956" config-ref="db-config"&gt;
              &lt;db:bulk-input-parameters &gt;&lt;![CDATA[#[{payload: payload, tableName: vars.tblName, Username: vars.username}]]]&gt;&lt;/db:bulk-input-parameters&gt;
              &lt;db:sql &gt;#["INSERT INTO :tableName
  (
      :tableName,
      Code,
      Name,
      Comments
      User
  )
  VALUES 
  (
      NEWID(), 
      :Code, 
      :Name, 
      :Comments,
      :username
  )"]&lt;/db:sql&gt;
          &lt;/db:bulk-insert&gt;
  </code></pre>
  
  <p>Thanks for any help</p>