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 only 2 APIs when called will return/produce data when Developer Mode is active.

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	No data	Ex-01
INSERT	Asset	InsertAsset(AssetRecord Record)	Yes	No 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	No data
INSERT	Contact	InsertContact(ContactRecord Record)	Yes	No 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	No data	Ex-01
INSERT	Ticket	InsertTicket(TicketRecord Record)	Yes	No data	Ex-01
UPDATE	Ticket	UpdateTicket(TicketRecord Record)	Yes	No data
DELETE	Ticket	DeleteTicket(string RecordID)	Yes	No data