MarketplaceStudioConnectorCall Orchestrator API from SQL Server

Create your first automation in just a few minutes.Try Studio Web

Call Orchestrator API from SQL Server

Call Orchestrator API from SQL Server

by Incepto

2

Connector

Downloads

101

back button
back button
carouselImage0
next button
next button

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

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

Additional Information

Additional Information

Dependencies

SQL Execute Access

Publisher

Incepto

Visit publisher's page

Trusted Source

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.0

Updated

August 26, 2021

Works with

Studio: 18.4.1 - 22.10

Certification

Silver Certified

Application

UiPath Orchestrator

Support

UiPath Community Support