Did you ever require to add a queue item directly from SQL?
Did you ever think the Dispatcher process can be replaced entirely by SQL Trigger?
Did you ever wish for a way to synchronize Asset values with SQL data?
To all above and similar queries, the answer is YES.
This package includes functions that help you call Orchestrator API from SQL Server.
Calls a GET/ POST API and returns a response.
More about Orchestrator API:
Parses JSON response from API and retrieves required value.
If your database has a compatibility level of 130 or more then OpenJSON is a better alternative.
To View/ Change compatibility level of SQL: https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database
About OpenJSON: https://docs.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql