I am new to Boomi. I wish to run a SQL statement and store the return value in Dynamic Process property . But, seem like the value in the Dynamic Process property is empty. Can someone help me. Thanks in advance.
Are you using the statement in a Set Properties Shape?
Are you sure the statement returns a value? Shouldn't there be a where clause, or does the table only contain one row?
Thanks for responding. Yes, the table only has one row. I manage to get it working now. The error is because I have a trailing space in my dynamic process property name.
Retrieving data ...