Hello Michael,
can you please show me the configuration of you input parameters? If you want to address fields from within a struct, you have to make sure that you name your input parameter “params”, you can of course alias it if you want / need to. After you’ve done so the field from within the struct should be recognized properly since your statement seems to use the correct notation for parameters, i.e. :parameterName:, already. Please also make sure to use the mode “execute” as well since you have at least one input parameter defined. If you need any further help while creating SQL connector calls you may also refer to our documentation.
Regards,
Armin
Update: I had a closer look at your error log and it seems you named the fields in your struct all with capital letters in the beginning of the words. However the naming of the fields in your struct need to match the column names of the table exactly. So I think you get the error since it expects to read the field “name” from the struct while in fact there’s only the field “Name” existing in the struct, please be aware of case-sensitivity here. Hope this helps