In Sage X3, sometimes we need to expand the functionality of the core Sage X3 solution with the required customizations to reach the desired goal. These customized new products are known as Add-ons. WAS web service is an add-on, which comes with a number of extra features, other than the normal web services.
- Broadly, an interface is mainly used for “Generated access to Table” and “Generated access to view” type.
- It gives us the ability to sort the desired fields, which is not possible in the normal web services.
- The filter can be applied to the resulted columns of the web service.
- Here we get the total number of records.
To create a WAS web service, perform the following steps:
- Creation of Website:
The first step is to create a new website for the particular web service. To do so, navigate to:
DEVELOPMENT-> SAFE X3 WAS -> WEBSITES-> WEBSITES
NOTE: You can also use an existing website if required.
To select the desired website, navigate to:
DEVELOPMENT-> SAFE X3 WAS -> WEBSITES-> SELECT
- Creation of Interface.
- Create an interface, and enter the name in the Interface Code field.
- Choose the type of interface from the selection Interface type.
- Fill the Table Code field as per the interface type selected. Since we have used Generated access to Table in the above example, we have entered the table required in the Table Code field.
- In the SUB Program section, the Processing and Sub-program fields will automatically be populated based on the entries.
- Publication name field in the PUBLICATION section is editable, and this will be the name of your web server.
- On creation, the Generate access button gets enabled.
- The interface column now displays a list of the fields. These fields are based on the table fields entered by you earlier. You can choose the ones for which you want the outcome of the web services.
- Validate the interface
Go to the respective web service:
- Go to mapping tab, there we will find 10 new fields other than the ones we have selected in the Interface.
Fields with their descriptions are given below:
|AXPARCOD||AX_PAR||X3 context variable code|
|AXPARVAL||AX_PAR||X3 context variable value|
|AXWHRLFTBRK||AX_WHR||Level of opening brackets|
|AXWHRCOD||AX_WHR||Name of the selection criteria|
|AXWHRCODVAL||AX_WHR||Value of the selection criteria|
|AXWHRRGTBRK||AX_WHR||Level of closing brackets|
|AXWHRANDOR||AX_WHR||Sequence logical operator|
|AXORDCOD||AX_ORD||Name of the sort criteria|
|AXORDTYP||AX_ORD||Value of the sort criteria|
|FIELD1||RES||Fields for the recordings returned by the web service|
|FIELD2||RES||Fields for the recordings returned by the web service|
Now once we have done the creation, WAS web service is ready to be tested.
Hope this blog helps!
Greytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix has some unique solutions of Sage X3 integration with Sage CRM, Salesforce.com, and Magento eCommerce along with Sage X3 migration from Sage 50 US, Sage Pro, and QuickBooks. We also offer best-in-class Sage X3 customization and development services to Sage business partners, end users, and Sage PSG worldwide.
For more information on Sage X3 Integration and Services, please contact us at email@example.com. We will be glad to assist you.