SAP PI message mapping of list of values
In SAP PI 7.4 I'm experiencing some difficulties in trying to map something in a message mapping which would seem quite straightforward.
Input is something like this.
<Employee>
<ExternalIdList>
<ExternalId>aaa</ExternalId>
<ExternalId>bbb</ExternalId>
<ExternalId>ccc</ExternalId>
</ExternalIdList>
</Employee>
I need this to map to something of the following structure
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>bbb</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>ccc</ExternalId>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
When trying to map, I'd do this as follows:
Employee -> NewObject
ExternalIdList -> ExternalEmployeeList
ExternalId -> ExternalEmployee
ExternalId -> ExternalId
When testing the mapping, 3 ExternalEmployee nodes are made, but only the first contains the value 'aaa' in the ExternalId. The other 2 ExternalEmployees don't get an ExternalId:
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee/>
<ExternalEmployee/>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
I've already tried quite some node functions or changed the context, but nothing seems to be working. What is the recommended solution for this?
Maybe add a XSLT mapping beforehand to insert a level between the ExternalIdList and the ExternalId in the input message? It seems like a lot of fuzz for this.
Thanks in advance, every tip in the right direction is welcome!
mapping sap esb netweaver
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
add a comment |
In SAP PI 7.4 I'm experiencing some difficulties in trying to map something in a message mapping which would seem quite straightforward.
Input is something like this.
<Employee>
<ExternalIdList>
<ExternalId>aaa</ExternalId>
<ExternalId>bbb</ExternalId>
<ExternalId>ccc</ExternalId>
</ExternalIdList>
</Employee>
I need this to map to something of the following structure
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>bbb</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>ccc</ExternalId>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
When trying to map, I'd do this as follows:
Employee -> NewObject
ExternalIdList -> ExternalEmployeeList
ExternalId -> ExternalEmployee
ExternalId -> ExternalId
When testing the mapping, 3 ExternalEmployee nodes are made, but only the first contains the value 'aaa' in the ExternalId. The other 2 ExternalEmployees don't get an ExternalId:
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee/>
<ExternalEmployee/>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
I've already tried quite some node functions or changed the context, but nothing seems to be working. What is the recommended solution for this?
Maybe add a XSLT mapping beforehand to insert a level between the ExternalIdList and the ExternalId in the input message? It seems like a lot of fuzz for this.
Thanks in advance, every tip in the right direction is welcome!
mapping sap esb netweaver
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
add a comment |
In SAP PI 7.4 I'm experiencing some difficulties in trying to map something in a message mapping which would seem quite straightforward.
Input is something like this.
<Employee>
<ExternalIdList>
<ExternalId>aaa</ExternalId>
<ExternalId>bbb</ExternalId>
<ExternalId>ccc</ExternalId>
</ExternalIdList>
</Employee>
I need this to map to something of the following structure
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>bbb</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>ccc</ExternalId>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
When trying to map, I'd do this as follows:
Employee -> NewObject
ExternalIdList -> ExternalEmployeeList
ExternalId -> ExternalEmployee
ExternalId -> ExternalId
When testing the mapping, 3 ExternalEmployee nodes are made, but only the first contains the value 'aaa' in the ExternalId. The other 2 ExternalEmployees don't get an ExternalId:
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee/>
<ExternalEmployee/>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
I've already tried quite some node functions or changed the context, but nothing seems to be working. What is the recommended solution for this?
Maybe add a XSLT mapping beforehand to insert a level between the ExternalIdList and the ExternalId in the input message? It seems like a lot of fuzz for this.
Thanks in advance, every tip in the right direction is welcome!
mapping sap esb netweaver
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
In SAP PI 7.4 I'm experiencing some difficulties in trying to map something in a message mapping which would seem quite straightforward.
Input is something like this.
<Employee>
<ExternalIdList>
<ExternalId>aaa</ExternalId>
<ExternalId>bbb</ExternalId>
<ExternalId>ccc</ExternalId>
</ExternalIdList>
</Employee>
I need this to map to something of the following structure
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>bbb</ExternalId>
</ExternalEmployee>
<ExternalEmployee>
<ExternalId>ccc</ExternalId>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
When trying to map, I'd do this as follows:
Employee -> NewObject
ExternalIdList -> ExternalEmployeeList
ExternalId -> ExternalEmployee
ExternalId -> ExternalId
When testing the mapping, 3 ExternalEmployee nodes are made, but only the first contains the value 'aaa' in the ExternalId. The other 2 ExternalEmployees don't get an ExternalId:
<Newobject>
<ExternalEmployeeList>
<ExternalEmployee>
<ExternalId>aaa</ExternalId>
</ExternalEmployee>
<ExternalEmployee/>
<ExternalEmployee/>
</ExternalEmployee>
</ExternalEmployeeList>
</Newobject>
I've already tried quite some node functions or changed the context, but nothing seems to be working. What is the recommended solution for this?
Maybe add a XSLT mapping beforehand to insert a level between the ExternalIdList and the ExternalId in the input message? It seems like a lot of fuzz for this.
Thanks in advance, every tip in the right direction is welcome!
mapping sap esb netweaver
mapping sap esb netweaver
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
asked Nov 21 '18 at 13:23
Aza dudeAza dude
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
the problem should be a missing context change in tag ExternalId.
try to fix the mapping in the following way:
ExternalEmployee (target) = ExternalEmployee
ExternalId (target) = splitByValue(ExternalId)
configure splitByValue choosing "Each Value" option
Also be sure that target ExternalEmployee have 1..unbounded occurrence !
This is the result
Best regards!
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413012%2fsap-pi-message-mapping-of-list-of-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
the problem should be a missing context change in tag ExternalId.
try to fix the mapping in the following way:
ExternalEmployee (target) = ExternalEmployee
ExternalId (target) = splitByValue(ExternalId)
configure splitByValue choosing "Each Value" option
Also be sure that target ExternalEmployee have 1..unbounded occurrence !
This is the result
Best regards!
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
add a comment |
the problem should be a missing context change in tag ExternalId.
try to fix the mapping in the following way:
ExternalEmployee (target) = ExternalEmployee
ExternalId (target) = splitByValue(ExternalId)
configure splitByValue choosing "Each Value" option
Also be sure that target ExternalEmployee have 1..unbounded occurrence !
This is the result
Best regards!
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
add a comment |
the problem should be a missing context change in tag ExternalId.
try to fix the mapping in the following way:
ExternalEmployee (target) = ExternalEmployee
ExternalId (target) = splitByValue(ExternalId)
configure splitByValue choosing "Each Value" option
Also be sure that target ExternalEmployee have 1..unbounded occurrence !
This is the result
Best regards!
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
the problem should be a missing context change in tag ExternalId.
try to fix the mapping in the following way:
ExternalEmployee (target) = ExternalEmployee
ExternalId (target) = splitByValue(ExternalId)
configure splitByValue choosing "Each Value" option
Also be sure that target ExternalEmployee have 1..unbounded occurrence !
This is the result
Best regards!
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
answered Feb 22 at 16:39
manuel_bmanuel_b
1138
1138
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413012%2fsap-pi-message-mapping-of-list-of-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
