select languageEnglish
toggle dropdown
MarketplaceListingsConnectorCall Orchestrator API from SQL Server

Call Orchestrator API from SQL Server

Bronze Certified

Connector

1 reviews

14

Version:

Call Orchestrator API from SQL Server

Bronze Certified

Connector

1 reviews

14

Version:1.0.0
Overview
1
ReviewsQuestions
1
Versions

Summary

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

carouselImage0

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

Benefits

  1. Get, send information between SQL Server and UiPath Orchestrator.
  2. Have a real-time Dispatcher.

Published: 06 Sep 2021 | Updated: 26 Aug 2021

Trusted Source

License

MIT

Runtime

.NET Core

Tags

UiPathAPI
SQL
SQLAPI

Compatibility

Studio: 2018.4.1+

Dependencies

SQL Execute Access

Support

UiPath Community Support

Similar Listings

Xebia - SQL Query Builder…

Custom Activity

SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable …

331

Bronze Certified

Supported by Publisher

Modex - Orchestrator Security Compliance …

Solution

Creating a tamper-resistant ecosystem for UiPath Orchestrator…

1

Power BI Jobs and Queues Dashboards…

Tool

Interactive Power BI dashboards on the topic of jobs and queues processes, using data from the Orchestrator SQL Server database…

5 reviews

857

Bronze Certified

CyberArk - Manage Orchestrator Credentials…

Connector

UiPath Orchestrator is a web application that orchestrates UiPath Robots that run repetitive business processes.…

1 reviews

23

Help

UiPath ForumContact UsFAQs

How To

Automation Ideas BoardBecome a PublisherPublish a Quality ListingCertify Your Listing
select languageEnglish
toggle dropdown
Terms & Conditions
Privacy Policy
Cookies Policy
linkedinfacebooktwitteryoutubeblogslack