Browse By Tags

  • Portuguese Legislation - New certificate for transport document communication via web service

    The new certificate for transport document communication via web service is now available. This replaces the certificate that expired on 23/07/2020. To obtain this update, please log a case with your local Sage X3 support team. It is available for…

  • Max try reached on AOWSIMPORT SOAP call

    I've been using other SOAP WS to read/modify/create data with no problem, but if I use the AOWSIMPORT SOAP WS I get the error "Max try reached", this is happening for every I_MODIMP that I specify. What is causing this error?

  • SIH Soap webservice call

    Hi Im doing a soap webservice call to object SIH that i published. Im entering the price (GROPRI)in the line of the sales invoice, but the webservice is defaulting the price to zero. I have no price lists and when i go to the saved invoice and check the…

  • SAGE X3 v7 - Exploitation des données via excel

    Bonjour à tous, Depuis quelques temps, je bosse sur un moyen d'exploiter certaines données de notre ERP via excel. L'idée serait de mettre en place une sorte de portail de données à la demande (sans passé par un outil de BI) afin de pouvoir ressortir…

  • How to create IC Internal Usage entry from an external system?

    I'm building a business application to manage inventory requisitions. The application is a lightweight web interface used mainly by our internal employees to submit an inventory requisition. The requisitions will pass through a workflow of activities…

  • Invoice PDF via Web Service

    Has anybody ever generated a .pdf of an invoice, or other document in X3, using web services? I have a request to make invoice copies available to an external source, and I want to try to do it somehow using web services.

  • Je n'arrive pas à ajouter le WSDL de mon environnement dans SOAPUI.

    Bonjour, J'essaie d'ajouter le WSDL de mon environnement X3 à Soapui pour tester les interfaces qui s'y trouvent. J'ai obtenu l'URL du WSDL en suivant ces étapes: https://www.sagecity.com/fr/enterprise-management-sage-x3-france/f/enterprise-management…

  • Date/Time fields, User Preferences and SOAP Web Services

    In this example, I want to explore how Sage CRM's SOAP web services interact with dates and times. The background for this article is the experience that a user may have within the main interface. As we can see in the image below this user has opted…

  • Embedding Sage CRM Screens (ASP & .NET extensions) in External Applications

    This article has been written for partners who need to be able to call Sage CRM screens in the context of external applications. This is not such a strange idea as there are several partners who have created add-ons to MS Office or to other desktop products…

  • Dropdown field settings in SOAP Web Services

    In Sage CRM you can control whether dropdown fields are handled as enumerators or as strings in code. This is an important setting of which to be aware when creating your code. I started a project this week and failed to realise that I had changed…

  • Working with Default Company Addresses

    If you need to list company default/main addresses you can link from the Company to the Address table. You don't need to link to the address_link table. The address link table is used to keep details about the alternative addresses that might be stored…

  • Insert an Opportunity using AddRecord using SOAP Web Services

    I have covered inserting a record using the Add() methid in the article " Add Case Example using Web Service Interface ". Below is some example code that shows how to insert a record using the AddRecord() method of the SOAP webservices. WebService…

  • A Trick to expose an External Table through Sage CRM's SOAP Web Services.

    Sage CRM has the ability to link to external databases. Once an external database table is linked to Sage CRM the External Access settings of the linked table can be changed to allow both SData and Web Services access. I have discussed in previous articles…

  • Sage CRM 2021: Invoking Workflow from Self Service and Web Service (SOAP) Based Applications

    One of the challenges that a developer will face when working with Self Service or with an external Application using the SOAP Web Services interface is that workflow is not fully covered by the APIs. Self Service and Workflow Self Service uses the…

  • Security and the SData Gadget and ReadOnly SData provider

    For an introduction to SData REST based web services then please see the article " Accessing SData Provider " Another example of how SData is used in Sage CRM's Interactive Dashboard feature can be found here: " An SData Example — the Sage CRM Interactive…

  • V12 : Constitution URL pour webservices avec représentation

    Bonjour, Je suis en V12 LP19 et j'essaie de tester les Webservices en utilisant POSTMAN. J'arrive à avoir un retour en utilisant l'URL ">serveur_X3:8124/.../storageVolumes('55c1dfc3-3dd4-4877-a941-d00529909bf9') Par contre si je souhaite utiliser…

  • Web Services Consumed inside Node.JS framework

    I am aware Sage CRM Web Service SOAP API can be called in any language , my current knowledge is restricted to .Net & PHP, any available sample code any partner has written using Node.JS , there is a whole array of applications that can be integrated…

  • Getting "Query failed to run successfully" while executing QueryId

    Hi, I am using Sage CRM 2014 R2.4 Trial(CLoud) for testing purpose, so that we can have idea weather it fits our requirements or not. While executing QueryId object I am getting " Query failed to run successfully" . Here is the input which we are…

  • Error saving EmaiLink record on 7.2 web service

    Hi, We are trying to create a record in the Email table (and of course, the EmailLink table) on a newly upgraded 7.2 (upgraded from 7.0 to 7.1SP2 to 7.2g). We identified the bug where the 'EmailLink' table does not have the 'Bord_WebServicesTable…

  • SageCRM Dev. Team - Please fix the inconsistencies in the data dictionary.

    Who knows, this could be miraculously fixed in 7.3 (a project which we just about to undertake). a. Aside from some fields in the Users table, EVERY single other field in the CRM database should have an entry in custom_edits...this include the meta_data…

  • How to enable view for Web Service (7.1)

    Hi, When I tried to execute web service XML for a custom view, the fiddler returned "Request Failed. Entity '<ViewName>' is not Web Service enabled." How can I enable custom view for web service?

  • soapUI

    Hi, One of our customer needs to use soapUI to communicate with SageCRM webservices. Do you have any sample for us ? TIA ! Regards, Stephen

  • WebService call using javascript

    I have a requirement to make some webservice calls from an html page. I've been trying to mimic Jeff's example found here https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2010/04/13/grabbing-serverside-information-using…

  • Updating leads via web services

    I'm trying to update some records via web services. I have some input data which consists of a list of email addresses in a spreadsheet. I need to go through that list 1 by 1 and for each email address return all the matching leads. Once I have my list…

  • Import datetime fields with webservices

    Hi everyone, We are experiencing difficulties when we're importing CSV file into an custom entity. String, double and integer types are imported but we can't figure out the string format for the datetime type ! Can somebody help us ? TIA !

*Community Hub is the new name for Sage City