I am using Nintex forms to grab some data from a remote SQL server for a dropdown field.
The SQl query ran fine but I wanted to change this to use a stored procedure.
When I test run the stored procedure in Nintex Forms i get an error shown in the screenshot below:
The thing is, when I run this in SQL, I get the expected results (a list of customers).
I am thinking that the value for the @CUSTTABLECUBEPARTITION ids not being passed for some reason.
I have tried altering the stored procedure so that it only needs one paramaeter (@DATAAREAID) and the same problem comes up:
Anyone know what may be going on here and how to get the value to pass from Nintex/Sharepoint to the stored procedure?
Solved! Go to Solution.
Ok Solved this one. I removed the "@" before the parameter name in the SQL Request configuration. Instead of typing "@DATAAREAID", I used "DATAAREAID". Working as expected now.