CommitCRM API Support

CommitCRM API Integration in the Jupiter Server has the following CommitCRM API calls mapping to WCF service methods. All methods are supported in Developer Mode, however none yet return any data when Developer Mode is active.

SQL Action CommitCRM Table Jupiter Server WCF service methods Developer Mode Support Developer Mode Response Examples
SELECT Accounts SelectAccount(Select Select) Yes No data Ex-01
INSERT Accounts InsertAccount(AccountRecord Record) Yes No 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