Package metadata - Release notes

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:

Image_2019-11-21_17-22-56.png
Image_2019-11-21_17-23-45.png


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.
Image_2019-11-21_17-25-37.png