We need to programmatically create queue items in Orchestrator from a process which is not a robot. There appear to be two options to do this:
- Send a POST request to the Orchestrator API
- Insert a record directly into the QueueItems table
Are there any downsides or things to account for if the manual option (inserting the record directly) is taken? Or, asked another way, does sending the POST request do anything more than add a record to this table, such as touching other tables or adding the new queue item to some internal state tracking system?
For our particular use case, manipulating the QueueItems table directly, likely as a stored procedure, is much simpler than using the API and would be preferred by our developers.