CommitCRM API Support

CommitCRM API Integration in the Jupiter Server has the following CommitCRM API calls mapping to WCF service methods

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