Access Sage X3 data from external applications through Web services

By | October 20, 2012

One of the most effective ways of integrating Sage X3 with external applications like E-commerce portals, data feeds etc is Web Services.

Web services enable Sage Enterprise Management to operate with third-party applications by making X3 objects available over the Internet and/or integrating data from external web services into Sage ERP X3 processes.

In this blog, we will take a nickel ride to see how Web services can be configured and utilized to access Sage X3 data.

Following are the prerequisites for deployment of Sage X3 Web services:

  1. Install Web Server to host the Web services.
  2. Publish the folder to be accessed.
  3. License to allow Web service connection.
  4. Setup web service pools using Console.

Now, let’s see create a simple web service to access Sales Order details:

  1. Go to “Development -> Processes -> Processes -> Web services”.
  2. Assign a publication name – ORDER.
  3. Now select the Object option and assign the object for Sales Oder i.e. SOH.
  4. Click on ‘Create’ button and finally click on ‘Publication’.

Note: Check the mapping tab to see the SO fields that will be exposed through Web service.

That’s it, the Sales Order object is now available through web services. Now let us test this web service:
The web service can be tested through external applications developed in .Net, Java or PHP. However, the best tool to test web services is the Sage Web Server’s  WebService Tester.

To read the Order, put in the Publication name for ‘Public Identifier’ and the Sales order number in the first key box and click ‘Read’. You would get the result in green in the reply section.

Similarly, you can create, modify, delete and access a lot of actions (allowed by the object).

Isn’t it interesting? Stay tuned for more blogs on web services as we have only scratched the surface.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.