How can we fetch package metadata information from the Orchestrator database
This section describes the answer, or the steps required to solve a problem
The below approach is valid for 2019.X and above version:
The release notes are stored in the ReleaseNotes column of [dbo].[PackageDefinitions] a table in the orchestrator database. The package can be identified with identifiers and version columns. Refer the snippets below:
The below holds good for all version [tested in 2018.4.X and 2019.X versions]:
One can also call “odata/Processes/UiPath.Server.Configuration.OData.GetProcessVersions(processId=‘ReleaseNote’)” api to get the release notes. Here ProcessId is the name of the process one is looking for. Refer the below screenshot.