RangerMSP API Support

RangerMSP API Integration in the Jupiter Server has the following RangerMSP API calls mapping to WCF service methods. All methods are supported in Developer Mode, however not all will return/produce data when Developer Mode is active.
To integrate with RangerMSP, Jupiter Server uses the RangerMSP C# API described here http://www.rangermsp.com/wiki/CSharp_API.
Some additional methods have also been created in Jupiter Server to simplify common API requests.

WCF SOAP and WCF REST are both supported for all the methods below.

When calling WCF SOAP methods use the http[s]://hostname:port/RangerMSP service endpoint.
When calling WCF REST methods use the http[s]://hostname:port/RangerMSP_REST service endpoint.

All REST methods are GET methods and only accept and return JSON.

SQL Action RangerMSP Table Jupiter Server WCF service methods Developer Mode Support Developer Mode Response Examples
SELECT Accounts SelectAccount(Select Select) Yes Dev data Ex-01
INSERT Accounts InsertAccount(AccountRecord Record) Yes Dev data Ex-01
UPDATE Accounts UpdateAccount(AccountRecord Record) Yes No data
DELETE Accounts DeleteAccount(string RecordID) Yes No data
SELECT Asset SelectAsset(Select Select) Yes Dev data Ex-01
INSERT Asset InsertAsset(AssetRecord Record) Yes Dev data
UPDATE Asset UpdateAsset(AssetRecord Record) Yes No data
DELETE Asset DeleteAsset(string RecordID) Yes No data
SELECT Calendar SelectCalendar(Select Select) Yes No data
INSERT Calendar InsertCalendar(CalendarRecord Record) Yes No data
UPDATE Calendar UpdateCalendar(CalendarRecord Record) Yes No data
DELETE Calendar DeleteCalendar(string RecordID) Yes No data
SELECT Charge SelectCharge(Select Select) Yes No data
INSERT Charge InsertCharge(ChargeRecord Record) Yes No data Ex-01
UPDATE Charge UpdateCharge(ChargeRecord Record) Yes No data
DELETE Charge DeleteCharge(string RecordID) Yes No data
SELECT Contact SelectContact(Select Select) Yes Dev data
INSERT Contact InsertContact(ContactRecord Record) Yes Dev data
UPDATE Contact UpdateContact(ContactRecord Record) Yes No data
DELETE Contact DeleteContact(string RecordID) Yes No data
SELECT Contract SelectContract(Select Select) Yes No data
SELECT Document SelectDocument(Select Select) Yes No data
INSERT Document InsertDocument(DocumentRecord Record) Yes No data
UPDATE Document UpdateDocument(DocumentRecord Record) Yes No data
DELETE Document DeleteDocument(string RecordID) Yes No data
SELECT HistoryNote SelectHistoryNote(Select Select) Yes No data
INSERT HistoryNote InsertHistoryNote(HistoryNoteRecord Record) Yes No data
UPDATE HistoryNote UpdateHistoryNote(HistoryNoteRecord Record) Yes No data
DELETE HistoryNote DeleteHistoryNote(string RecordID) Yes No data
SELECT Item SelectItem(Select Select) Yes No data
INSERT Item InsertItem(ItemRecord Record) Yes No data
UPDATE Item UpdateItem(ItemRecord Record) Yes No data
DELETE Item DeleteItem(string RecordID) Yes No data
SELECT KnowledgeBaseArticle SelectKnowledgeBaseArticle(Select Select) Yes No data
INSERT KnowledgeBaseArticle InsertKnowledgeBaseArticle(KnowledgeBaseArticleRecord Record) Yes No data
UPDATE KnowledgeBaseArticle UpdateKnowledgeBaseArticle(KnowledgeBaseArticleRecord Record) Yes No data
DELETE KnowledgeBaseArticle DeleteKnowledgeBaseArticle(string RecordID) Yes No data
SELECT Opportunity SelectOpportunity(Select Select) Yes No data
INSERT Opportunity InsertOpportunity(OpportunityRecord Record) Yes No data
UPDATE Opportunity UpdateOpportunity(OpportunityRecord Record) Yes No data
DELETE Opportunity DeleteOpportunity(string RecordID) Yes No data
SELECT Quote SelectQuote(Select Select) Yes No data
INSERT Quote InsertQuote(QuoteRecord Record) Yes No data
UPDATE Quote UpdateQuote(QuoteRecord Record) Yes No data
DELETE Quote DeleteQuote(string RecordID) Yes No data
SELECT QuoteLine SelectQuoteLine(Select Select) Yes No data
INSERT QuoteLine InsertQuoteLine(QuoteLineRecord Record) Yes No data
UPDATE QuoteLine UpdateQuoteLine(QuoteLineRecord Record) Yes No data
DELETE QuoteLine DeleteQuoteLine(string RecordID) Yes No data
SELECT Task SelectTask(Select Select) Yes No data
INSERT Task InsertTask(TaskRecord Record) Yes No data
UPDATE Task UpdateTask(TaskRecord Record) Yes No data
DELETE Task DeleteTask(string RecordID) Yes No data
SELECT Ticket SelectTicket(Select Select) Yes Dev data Ex-01
INSERT Ticket InsertTicket(TicketRecord Record) Yes Dev data Ex-01
UPDATE Ticket UpdateTicket(TicketRecord Record) Yes Dev data
DELETE Ticket DeleteTicket(string RecordID) Yes No data
Data Source Jupiter Server WCF service methods Developer Mode Support Developer Mode Response Examples
Online Yes Dev data
Jupiter Server config GetAssetTypes Yes Dev data
Jupiter Server config GetCustomerTypes Yes Dev data
Tickets GetTicketOpenCount Yes Dev data
Jupiter Defaults GetTicketPriorityValues Yes Dev data
Jupiter Defaults GetTicketTypes Yes Dev data