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 |