...
If you need consume from js:
Then use the method GNL_APMCrewListViews to call the view and add any parameters
For example Return all Requirements for General Manager on the vessel with IMO nr 123456789
function ConsumeSQLViewViaAPI() {
var request = new Object();
request.Authentication_Token = "…";
request.View = " vProfilePositionRequirements";
request.Filter = "WHERE Position='General Manager' AND IMO='123456789'";
request.Pagination = false;
request.RowsByPage = "";
request.Page = "";
$.ajax({
url: "http://localhost/AIWS/AdonisIntegrationWebService.svc/GNL_APMCrewListViews",
data: '{"request":' + JSON.stringify(request) + '}',
type: 'POST',
dataType: 'json',
contentType: "application/json; charset=utf-8",
async: true,
success: function (data) {
},
error: function (xhr, textStatus, error) {
console.log(error.toString());
}
});
}