I'm trying to get a SDM property down down working using Data Objects in Service Catalog with the built in Service Management Content Pack. I've successfully sent data to service desk using the select component with manually defined options. However I would like to use a SQL data object instead. I have a working data object and set the report key on the select component of the form. However upon creating a requests and making a selection the option is not carried over to service desk. The ID for the select component is set to ca_sdm_prop_2, and the 2 is mapped to a property sequence number in service desk. As mentioned this works if i manually define the options.
I'm not really sure what's missing here, any ideas? Thanks!