Browse By Tags

  • Blog Post: 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.*,...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...