API for Review Assistant

[kmd]

We want to receive email notifications every time when someone adds a review comment or changes the state of the review (accepted/rejected).

Is there an API for Review Assistant which we could use to write a utility which will achieve the above goal?

Of course, as we do have access the the database file of ReviewAssistant, we could extract the necessary information from there - but it would require some reverse engineering.

If there is no API available, could you at least provide me with the description of tables from ReviewAssistant database?

[Artem]

We are planning to add email notifications in a future version of Review Assistant. Unfortunately, Review Assistant has no public API now. You can create and describe your suggestion at our UserVoice

As to description of our database tables, their structure changes from version to version. In the last version you can use the following queries.

To get all reviews and their authors:

Code: Select all

SELECT r.RowId NumericId, r.Id ReviewID, r.Version, r.Title, u.FullName, u.Email FROM Reviews r
INNER JOIN Users u ON u.Id = r.AuthorId
WHERE r.Version > @Version or r.Id IN (
  SELECT ReviewId FROM Comments WHERE Version > @Version
)

To get all reviewers of a specified review:

Code: Select all

SELECT u.FullName, u.Email FROM Reviewers r
INNER JOIN Users u ON u.Id = r.UserId
WHERE r.ReviewId = @ReviewId

Note that Version is a field with continuous numbering, and its value is incremented on any change in the database. The Email field is currently unavailable for editing from the Review Assistant GUI, but it can contain values imported from Active Directory, and you can use it to determine which people should receive email notifications.