Sorry my question was;

Yes sorry. I am creating a configuration tool for integration and need to store cameras user defined events and their associated data etc. In SQL.

I then have a service which checks certain criteria and then needs to trigger camera recording and user events etc from the data in the sql configurations

​ Cant seem to pass the correct info to the trigger/control command.

Maybe storing the data incorrectly?

It is not recommended (not supported) to use the SQL configuration database directly, if this is what you are doing, please use the APIs in the MIP SDK instead.

Use TriggerCommand

https://doc.developer.milestonesys.com/html/index.html?base=miphelp/class_video_o_s_1_1_platform_1_1_messaging_1_1_message_id_1_1_control.html&tree=tree_search.html?search=triggercommand

You can see this used in the Configuration Access sample

https://doc.developer.milestonesys.com/html/index.html?base=samples/configaccess_sample.html&tree=tree_2.html