AnsweredAssumed Answered

How do I use a Data Processing shape to split a document at a complex type with attributes?

Question asked by BrianWhite9911 on Jan 3, 2014
Latest reply on Jan 5, 2018 by mmorthala189353
my XML:

     <listRel:Customer xmlns:listRel="urn:relationships_2012_1.lists.webservices.netsuite.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" internalId="70">
        <listRel:entityId>Superior Communications</listRel:entityId>
        <listRel:isPerson>false</listRel:isPerson>
        <listRel:companyName>Superior Communications</listRel:companyName>
        <listRel:entityStatus internalId="13">
           <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">CUSTOMER-Closed Won</platformCore:name>
        </listRel:entityStatus>
        <listRel:phone>(626) 388-1815</listRel:phone>
        <listRel:email>cwu@scp4me.com</listRel:email>
        <listRel:defaultAddress>Ava Cheung- Accts Payable041&lt;br&gt;Superior Communications&lt;br&gt;5027 Irwindale Avenue&lt;br&gt;Suite 900&lt;br&gt;Irwindale CA 91706</listRel:defaultAddress>
        <listRel:isInactive>false</listRel:isInactive>
        <listRel:dateCreated>2010-10-27T16:51:15.000-07:00</listRel:dateCreated>
        <listRel:emailPreference>_default</listRel:emailPreference>
        <listRel:subsidiary internalId="1">
           <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">AliphCom</platformCore:name>
        </listRel:subsidiary>
        <listRel:terms internalId="2">
           <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Net 30</platformCore:name>
        </listRel:terms>
        <listRel:creditLimit>8000000.0</listRel:creditLimit>
        <listRel:creditHoldOverride>_auto</listRel:creditHoldOverride>
        <listRel:balance>9561895.96</listRel:balance>
        <listRel:overdueBalance>9602542.67</listRel:overdueBalance>
        <listRel:daysOverdue>103</listRel:daysOverdue>
        <listRel:unbilledOrders>3.2956403731E8</listRel:unbilledOrders>
        <listRel:currency internalId="1">
           <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">USA</platformCore:name>
        </listRel:currency>
        <listRel:depositBalance>0.0</listRel:depositBalance>
        <listRel:shipComplete>false</listRel:shipComplete>
        <listRel:taxable>false</listRel:taxable>
        <listRel:aging>0.0</listRel:aging>
        <listRel:giveAccess>false</listRel:giveAccess>
        <listRel:accessRole internalId="14">
           <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Customer Center</platformCore:name>
        </listRel:accessRole>
        <listRel:receivablesAccount internalId="-10">
           <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Use System Preference</platformCore:name>
        </listRel:receivablesAccount>
        <listRel:lastModifiedDate>2013-07-11T10:30:38.000-07:00</listRel:lastModifiedDate>
        <listRel:stage>_customer</listRel:stage>
        <listRel:isBudgetApproved>false</listRel:isBudgetApproved>
        <listRel:salesTeamList>
           <listRel:salesTeam>
              <listRel:employee internalId="640">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Jenny Champa</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>20.0</listRel:contribution>
           </listRel:salesTeam>
           <listRel:salesTeam>
              <listRel:employee internalId="641">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Scott Albright</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>20.0</listRel:contribution>
           </listRel:salesTeam>
           <listRel:salesTeam>
              <listRel:employee internalId="642">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Billie Buck</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>20.0</listRel:contribution>
           </listRel:salesTeam>
           <listRel:salesTeam>
              <listRel:employee internalId="644">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Ryann Hannigan</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>20.0</listRel:contribution>
           </listRel:salesTeam>
           <listRel:salesTeam>
              <listRel:employee internalId="862">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Matt Rose</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>20.0</listRel:contribution>
           </listRel:salesTeam>
           <listRel:salesTeam>
              <listRel:employee internalId="1120">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Amy Westmorland</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>0.0</listRel:contribution>
           </listRel:salesTeam>
           <listRel:salesTeam>
              <listRel:employee internalId="1572">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Mike Laughlin</platformCore:name>
              </listRel:employee>
              <listRel:salesRole internalId="-2">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Sales Rep</platformCore:name>
              </listRel:salesRole>
              <listRel:isPrimary>false</listRel:isPrimary>
              <listRel:contribution>0.0</listRel:contribution>
           </listRel:salesTeam>
        </listRel:salesTeamList>
        <listRel:addressbookList>
           <listRel:addressbook>
              <listRel:defaultShipping>false</listRel:defaultShipping>
              <listRel:defaultBilling>true</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>5027 Irwindale Avenue</listRel:label>
              <listRel:attention>Ava Cheung- Accts Payable041</listRel:attention>
              <listRel:addressee>Superior Communications</listRel:addressee>
              <listRel:addr1>5027 Irwindale Avenue</listRel:addr1>
              <listRel:addr2>Suite 900</listRel:addr2>
              <listRel:city>Irwindale</listRel:city>
              <listRel:zip>91706</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>Ava Cheung- Accts Payable041&lt;br&gt;Superior Communications&lt;br&gt;5027 Irwindale Avenue&lt;br&gt;Suite 900&lt;br&gt;Irwindale CA 91706</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>38</listRel:internalId>
              <listRel:state>CA</listRel:state>
           </listRel:addressbook>
           <listRel:addressbook>
              <listRel:defaultShipping>false</listRel:defaultShipping>
              <listRel:defaultBilling>false</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>CA</listRel:label>
              <listRel:attention>Armando Jara</listRel:attention>
              <listRel:addressee>(626) 388-2669</listRel:addressee>
              <listRel:phone>(626) 388-2669</listRel:phone>
              <listRel:addr1>Superior Communications</listRel:addr1>
              <listRel:addr2>5082 4th Street</listRel:addr2>
              <listRel:city>Irwindale</listRel:city>
              <listRel:zip>91706</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>Armando Jara&lt;br&gt;(626) 388-2669&lt;br&gt;Superior Communications&lt;br&gt;5082 4th Street&lt;br&gt;Irwindale CA 91706</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>510</listRel:internalId>
              <listRel:state>CA</listRel:state>
           </listRel:addressbook>
           <listRel:addressbook>
              <listRel:defaultShipping>false</listRel:defaultShipping>
              <listRel:defaultBilling>false</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>TN</listRel:label>
              <listRel:attention>Receiving Dept</listRel:attention>
              <listRel:addressee>New Breed/ Verizon Wireles</listRel:addressee>
              <listRel:addr1>4895 Citation Dr</listRel:addr1>
              <listRel:addr2>STE 1</listRel:addr2>
              <listRel:city>Memphis</listRel:city>
              <listRel:zip>38118</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>Receiving Dept&lt;br&gt;New Breed/ Verizon Wireles&lt;br&gt;4895 Citation Dr&lt;br&gt;STE 1&lt;br&gt;Memphis TN 38118</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>735</listRel:internalId>
              <listRel:state>TN</listRel:state>
           </listRel:addressbook>
           <listRel:addressbook>
              <listRel:defaultShipping>false</listRel:defaultShipping>
              <listRel:defaultBilling>false</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>PA</listRel:label>
              <listRel:attention>Receiving Dept</listRel:attention>
              <listRel:addressee>CTDI Verizon Wireless</listRel:addressee>
              <listRel:addr1>200 Stewart Huston Dr</listRel:addr1>
              <listRel:city>Coatesville</listRel:city>
              <listRel:zip>19320</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>Receiving Dept&lt;br&gt;CTDI Verizon Wireless&lt;br&gt;200 Stewart Huston Dr&lt;br&gt;Coatesville PA 19320</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>736</listRel:internalId>
              <listRel:state>PA</listRel:state>
           </listRel:addressbook>
           <listRel:addressbook>
              <listRel:defaultShipping>false</listRel:defaultShipping>
              <listRel:defaultBilling>false</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>Fontana</listRel:label>
              <listRel:attention>Receiving Dept</listRel:attention>
              <listRel:addressee>New Breed Fontana Dymax</listRel:addressee>
              <listRel:addr1>13232 Valley Blvd</listRel:addr1>
              <listRel:city>Fontana</listRel:city>
              <listRel:zip>92335</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>Receiving Dept&lt;br&gt;New Breed Fontana Dymax&lt;br&gt;13232 Valley Blvd&lt;br&gt;Fontana CA 92335</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>737</listRel:internalId>
              <listRel:state>CA</listRel:state>
           </listRel:addressbook>
           <listRel:addressbook>
              <listRel:defaultShipping>true</listRel:defaultShipping>
              <listRel:defaultBilling>false</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>CA</listRel:label>
              <listRel:addressee>Receiving Department</listRel:addressee>
              <listRel:addr1>Superior Communications</listRel:addr1>
              <listRel:addr2>5082 4th Street</listRel:addr2>
              <listRel:city>Irwindale</listRel:city>
              <listRel:zip>91706</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>Receiving Department&lt;br&gt;Superior Communications&lt;br&gt;5082 4th Street&lt;br&gt;Irwindale CA 91706</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>983</listRel:internalId>
              <listRel:state>CA</listRel:state>
           </listRel:addressbook>
           <listRel:addressbook>
              <listRel:defaultShipping>false</listRel:defaultShipping>
              <listRel:defaultBilling>false</listRel:defaultBilling>
              <listRel:isResidential>false</listRel:isResidential>
              <listRel:label>Austin, TX</listRel:label>
              <listRel:attention>RECEIVING DEPT</listRel:attention>
              <listRel:addressee>Superior Communications</listRel:addressee>
              <listRel:addr1>1130 Rutherford Lane, Ste 150</listRel:addr1>
              <listRel:city>Austin</listRel:city>
              <listRel:zip>78753</listRel:zip>
              <listRel:country>_unitedStates</listRel:country>
              <listRel:addrText>RECEIVING DEPT&lt;br&gt;Superior Communications&lt;br&gt;1130 Rutherford Lane, Ste 150&lt;br&gt;Austin TX 78753</listRel:addrText>
              <listRel:override>false</listRel:override>
              <listRel:internalId>2002</listRel:internalId>
              <listRel:state>TX</listRel:state>
           </listRel:addressbook>
        </listRel:addressbookList>
        <listRel:contactRolesList>
           <listRel:contactRoles>
              <listRel:giveAccess>false</listRel:giveAccess>
              <listRel:contact internalId="1201">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Veronica Defoe</platformCore:name>
              </listRel:contact>
              <listRel:email>VDefoe@scp4me.com</listRel:email>
              <listRel:role internalId="14">
                 <platformCore:name xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com">Customer Center</platformCore:name>
              </listRel:role>
              <listRel:sendEmail>false</listRel:sendEmail>
           </listRel:contactRoles>
        </listRel:contactRolesList>
        <listRel:customFieldList>
           <platformCore:Customer_Part_Number_Label xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com" internalId="custentity_al_cust_part_number_lbl" xsi:type="platformCore:StringCustomFieldRef">
              <platformCore:value>Superior SKU Number</platformCore:value>
           </platformCore:Customer_Part_Number_Label>
           <platformCore:Customer_PO_Number_Label xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com" internalId="custentity_al_cust_po_num_lbl" xsi:type="platformCore:StringCustomFieldRef">
              <platformCore:value>Superior Purchase Order Number</platformCore:value>
           </platformCore:Customer_PO_Number_Label>
           <platformCore:Show_Manufacturer_Price_on_PS xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com" internalId="custentity_al_manu_price_on_ps" xsi:type="platformCore:BooleanCustomFieldRef">
              <platformCore:value>false</platformCore:value>
           </platformCore:Show_Manufacturer_Price_on_PS>
           <platformCore:Vendor_Part_Number_Label xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com" internalId="custentity_al_vendor_part_number_lbl" xsi:type="platformCore:StringCustomFieldRef">
              <platformCore:value>Jawbone Part Number</platformCore:value>
           </platformCore:Vendor_Part_Number_Label>
           <platformCore:Default_Destination xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com" internalId="custentity_default_destination" xsi:type="platformCore:StringCustomFieldRef">
              <platformCore:value>LAX</platformCore:value>
           </platformCore:Default_Destination>
           <platformCore:Show_Description_on_PS xmlns:platformCore="urn:core_2012_1.platform.webservices.netsuite.com" internalId="custentity_show_description_on_ps" xsi:type="platformCore:BooleanCustomFieldRef">
              <platformCore:value>false</platformCore:value>
           </platformCore:Show_Description_on_PS>
        </listRel:customFieldList>
     </listRel:Customer>


     I am trying to split the document at the <listRel:addressbook> and I don't see anything splitting. My guess is because it's a complex type but not sure...Shed any light here?

     thanks!

Outcomes