Sign In
Create your first automation in just a few minutes.Try Studio Web →
Call Orchestrator API from SQL Server
by Incepto
2
Connector
101
Summary
Summary
SQL Functions that will help you call/ Query Orchestrator API from SQL Server.
Overview
Overview
- 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
Features
Features
- Get, send information between SQL Server and UiPath Orchestrator.
- Have a real-time Dispatcher.
Additional Information
Additional Information
Dependencies
SQL Execute Access
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.0Updated
August 26, 2021Works with
Studio: 18.4.1 - 22.10
Certification
Silver Certified
Application
Support
UiPath Community Support
Similar Listings
