AnsweredAssumed Answered

How can I map single database row to a single XML document but with one CSV database column to split to multiple repeating XML key pairs

Question asked by lee.greatorex805562 on Feb 28, 2017
Latest reply on Mar 14, 2017 by Adam Arrowsmith

Hi Boomi  folk

I have the below problem

 

This is a simplified version of my Database row

 

KeyInfo1Groups
1blurb1Group1,Group2

 

I'd like to Ideally map this in a single pass to XML Similar to below

There maybe upto 100 CSV groups (5 characters each) in the groups column

these are strictly controlled to not contain any CSV chars

 

<?xml version='1.0' encoding='UTF-8'?>
<Document>
<Key>1</Key>
<Info1>blurb1</Info1>
<Groups>
    <Group>
        <Name>Group1</Name>
    </Group>
    <Group>
        <Name>Group2</Name>
    </Group>
</Groups>
</Document>

 

I'm still on the trial version of boomi but working on an integration heading towards UAT (sound familiar ?)

I've had a good search through his forum but not really find exactly this issue

so maybe I'm just approaching it from a too simplistic angle.

 

I did try passing in a pre <> tagged groups field from SQL but the < kept getting escaped out (&lt;)  as that looked promising in the source but the boomi target XML mapping auto escaped it.

 

I'm open to Groovy scripting , splitting documents

but mainly the most efficient way to handle this little issue.

 

Many thanks for your time and input

Outcomes