Salesforce

How Do I Extract Specific Data from a Multi-Occurrence Compound? (Magic xpi 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

How Do I Extract Specific Data from a Multi-Occurrence Compound? (Magic xpi 3.x)

Use a variable to extract specific data from a multi-occurrence compound and filter it using conditioned mapping.

Sample Schema:

Sample XML Document:

  1. Define a variable that will hold the extracted data.

  2. Create a Data Mapper step.

  3. In the Source/Destination Management screen, define an XML Source type, based on the given schema.

  4. Define a Variable Destination type, and select the defined variable.


  5. In the Data Mapper screen define a single instance filter on the Source’s Person compound with a value of:

Filter Criteria is: Source/S3/Employees/Person/ID ='200'.

  1. Map the Source Name element to the Destination F.Name variable.

Based on the sample XML document, once the mappings have been executed, the value of the variable F.Name should be Alice.

Reference
Attachment 
Attachment