Incepto is an Australian company helping organisations to improve business processes through Intelligent Automation. We are enthusiastic and passionate about digital transformation and we believe in “Automation That Makes Sense”, meaning that not everything that can be automated should be automated. We have implemented Intelligent Automation solutions in organisations across different industries, enhancing business productivity, reducing operational risks, improving customer experiences and decreasing cost.

We offer expertise in RPA and AI technologies combined with our business knowledge to help organisations digitally transform and optimise their business operations. Our unique RPA Maturity Model provides the necessary guidance no matter the current stage of your automation journey.

We partner with trusted leaders in their fields to deliver robust, reliable, sustainable and cost-effective automation solutions.

c5ccab0c-e6bb-4dcc-a5d7-16ec7744c4fb.jpg

59c7ce80-b58b-4eeb-93e0-8345519612d1.png

RPA Developer

e852e051-2525-4bc7-a30d-62d94ed11459.zip

*   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.**

  

**Function** _**Call\_GetPostAPI**_

Calls a GET/ POST API and returns a response.

More about Orchestrator API:

https://docs.uipath.com/orchestrator/reference/about-odata-and-references

https://docs.uipath.com/orchestrator/reference/api-references

https://postman.uipath.rocks/

  

**Function** _**Get\_JSON\_Value**_

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

SQL Functions that will help you call/ Query Orchestrator API from SQL Server.

4c2d4e34-5573-4d75-8a95-64c0a3daba53.jpg

d1bf4bbb-11f2-4d9d-8c7e-59fc0f5f6291.png

21141c97-a3c0-4d02-9dcb-421e2c288872.jpg

d7b2c9f7-1a23-448a-84e9-5a55ae2ea9f4.jpg

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version	Release Date	Download Link
1.0.0	September 6, 2021
Function Call_GetPostAPI - Calls API Function Get_JSON_Value - Parse json (response from API) and return required value Example

Call Orchestrator API from SQL Server