xDI - How To - Components and Technologies

How to order records when loading a table
If you want to load a target table in an order, either ascending or descending, you can achieve this functionality by following the steps outlined below.  ...
Fri, 30 May, 2025 at 2:45 PM
[Excel] Define data types on Excel data source
By default, loading data from Excel only handles strings. To handle date, number, etc. in a mapping with an Excel spreadsheet as source, the following f...
Mon, 27 Jun, 2022 at 1:56 PM
Configuring HTTP Access Logs in xDI
Need It may be useful to generate access logs for web services exposed by xDI. The access logs format is typically including information such as client IP ...
Tue, 19 Nov, 2024 at 5:03 PM
File - Adding End Character CR+LF
The aim of this article is to explain how to add the CR+LF characters (end of line) at the end of a file, generated by Stambia. First, the File metadata...
Fri, 11 Feb, 2022 at 1:20 PM
File - Automatically Delete Useless Files
This article explains how to create a process, which will delete unnecessary files, so as not to overload the folders. This example shows how to delete xml...
Fri, 11 Feb, 2022 at 1:22 PM
File - Retrieve The Line Number in a Flat File
You may have a flat file and want to get, for each line of this file, the line number. Steps to get the line number To get the line number of each l...
Fri, 11 Feb, 2022 at 1:21 PM
File - Unload Data to Multiple Files
Below example shows how to group output records in multiple files based on a value from the source data. We have a table with customers and we want t...
Fri, 11 Feb, 2022 at 1:20 PM
HOW TO EXPOSE A WEBSERVICE WITH JSON STRCUTURE IN INPUT/OUTPUT
It is a common practice to have a Web Service that accepts input data in JSON format, makes the necessary transformations/verifications and returns output i...
Wed, 8 Feb, 2023 at 3:00 PM
How to use Session Variables to know if an Action Step is completed
When working with processes, especially when a process is also used as a sub-process within another, it's crucial to have a reliable way to determine if...
Wed, 11 Jun, 2025 at 12:27 PM
How To: Convert MS-SQL Query Results to XML Elements Using RAW Mode
Need You need to transform each row from a SQL query result into an XML element, typically with a generic <row> identifier, and understand how to ap...
Tue, 27 Jan, 2026 at 2:50 PM