• Library Record Creation - Sage 2017 R2 - SOAP /WEBSERVICES - Question

    All, Thanks for taking the time to read this. I have an issue with creating a library record via web services. AIM : Create a library Record -> Populate fields with data. Sample Code: ewarebase[] CRMBase = new ewarebase[1];//Allows reference…
  • SData2 Query won't work with startindex at anything other than 1

    I have an SData2 query that works fine for the first page of the pagination, but gives me a bad request for any query where startindex doesn't equal 1. The query is: opportunity?where=oppo_mydatefield%20ge%20@2016-09-01@%20and%20oppo_mydatefield%20le…
  • Query options available in GET APIs

    HI, I would like to understand if SDATA 2.0 GET API support any query options which would help me in getting selected records. Thanks, BrajMohan
  • Issues on Updating Lead AssignedId field on Workflow Progress screen, and run SQL query from Sage CRM properly

    I wrote a SQL query to evenly distribute leads to the user. The query runs perfectly on SQL Server, but not Sage CRM 7.1SP2. Any feedback is welcome! Thanks! The query is below. Here is what I did ,and got the SQL errors. The expected result is when…
  • Updating emaillink

    I have a list of email addresses that were uploaded against the wrong Person records and am trying to run a query updating the emaillink ELink_RecordID column with the correct person IDs, but the query fails consistently. Any idea why the update fails…
  • Escalations returning "Functionality Not Available, please consult your system administrator"

    We have an escalation referencing a secondary entity that posts a notification on screen when certain field requirements are met. Clicking the notification though brings up the "Functionality Not Available, please consult your system administrator" error…