What is List Action :
List Action is a part of the Integration Procedure that allows merging, sorting, and modifying multiple lists of items.
Major Properties of List Action:
List Merge
Sort List
Modify List
List Merge :
"Merging lists" in an integration procedure refers to the process of combining two or more separate lists into a single, unified list. This can be useful in integration procedures when you need to combine data from multiple sources into a single.
In MERGE LIST ORDER value fields we have to mention the list name based on in which order we want to display it in response.
If the JSON does not contain parent nodes.
If the JSON is passed from other Actions like DataRaptor.
MERGE FIELDS:
Without Advanced Merge: If we want to merge a list based on a particular field like “id”.
As a response, we can see that based on the “id” list got merged.
With using Advanced Merge.
Using Advanced merge we can group lists based on certain requirements and can merge them.
For Ex: we have 2 lists of Accounts and Contact where Account:id == Contact:AccountId so we can group the list based on this condition and along with these 2 fields other fields present in the list node also will merge simultaneously.
Preview:
Using Advanced merge we can group lists based on multiple conditions.
For Ex: we have 2 lists of Accounts and Contact where Account:id == Contact:AccountId AND Account:Name == Contact:LastName so we can group the list based on this condition and along with these 2 fields other fields present in the list node also will merge simultaneously.
Preview:
2. Sort List :
"Sorting a list" in an integration procedure refers to the process of rearranging the items in a list structure in a specific order, such as alphabetical, numerical, or date order.
Sorting a list can be useful in integration procedures to ensure that the data being integrated is organized and consistent.
The default will display the response as ASCENDING order.
Preview:
3. Modify List :
“Modifying a list” in an integration procedure would refer to the process of making changes to a list structure within the context of an integration procedure.
This could involve operations such as updating or replacing existing items in the list, adding new items to the list, or removing items from the list.
This process should be handled with proper data validation to ensure the integrity of the data.
Example 1: Merging List with few fields.
In Input Parameters, we have to pass the new Dynamic Output Field with fields based on requirements where fields should be comma separated.
Example 2: Merging List with Filter List Formula
In Input Parameters, we have to pass the new Dynamic Output Field with fields based on requirements where fields should be comma separated.
Example 3: Creating a new field and updating the existing field in the list.
In response, we can observe that “NameWithId” is newly created and “LastName” is modified.
Example 4: The List Action merges multiple lists by matching values of specified list item JSON nodes. A basic merge matches node names exactly. An advanced merge matches nodes that have different names and/or reside at different levels in the incoming lists.
We will take two DRs and will try to merge using ListAction.
We have to keep one field common in both the DRs as based on that field only “ListAction‘ will do the merge operations
Created an Ip and added two DR extract
4. Added one listAction in the IP
5. In the ListAction added all the required configurations as below.
6. Here we are merging based on “LinkedFacilityId”, this node is common in both the DRs.
References:
Comentarios