Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Using Joins in Web Services
Imagine you need to retrieve information from CRM via the webservices interface; this query should combine data from multiple tables. In the COM API (ASP pages, self service, table level scripts etc) you could use the QueryObject to build the exact SQL you need. var mySQL = "SELECT Person.*,...
9 Jun 2009
Creating your own Import Scripts using the COM API
Please read the article " Some thoughts on Importing Data " as background. The previous article discussed the different programming techniques that can be used for importing data into Sage CRM. Web Services COM Based Mechanisms .NET API Direct Data Interaction The COM...
20 Aug 2010
CRM.AddContent() & Dummy Field Trick
I thought I had written about this trick before but it appears not! A customer needed a technique to allow a chart to be displayed at the top of the company screen. This is a bit like the PipeLineGraphic of the OpportunityList or CaseList system screens. The way this has been added is really...
28 May 2010
Creating Complex Screens using the COM based ASP API
I have blogged previously on creating Multi block screens based on a single record. A prime example of that would be where you need to design a page for a new entity that include both a detailbox and a webpicker. I would now like to consider a Complex screen where the ASP page offers the user the...
10 Feb 2009
Calling Workflow in an ASP Summary Page
This is article is based on a customer need to display workflow buttons in a an ASP page that handles company records. Below you can see that I have created a partial rebuild of the company summary screen. Since this example is based on the Company Summary screen there are a few steps that must...
1 Oct 2015
© The Sage Group plc 2019
All Rights Reserved