I have a SmartObject that uses a sql server broker instance to display data from a table. I am trying to figure out how to map the results of the SmartObect's list method to an xml field. When I try to use a SmartObject Event in the Return Mapping screen all I get is 2 fields(ID, Number) which I can map to a data or xml field. However, when I try to access the field later in the workflow it only contains the last row of the database table.
I thought that since the list method can return a datatable it would normally map to an xml field.
What am I doing wrong?
thanks,
Luis