Avatar

Level 4

I must be missing something somewhere becuause I couldn't get it to work.  Here is the xml that I am getting back when I invoke the CFC from within Workbench.  This data is assigned to an XML type varialbe called 'xmlOutput'.  I then create a data connection in my form to the service I created in Workbench and bind the return data to a text field (with multiple lines).  When I bind the data I have the option to choose "document" or "element".  Element doesn't return anything, unless I am doing something wrong, so I have to choose Document. 

With the xmlOutput below I do get more than one subordinate returned.  I only showed one for simplicity.

------------Begin xmlOutput --------------  (Yes, I am getting all of these empty lines in my output)

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://livecycle" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <ns1:getSubordinatesResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
         <getSubordinatesReturn xsi:type="xsd:string"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<subordinates>

    <subordinate>
       
       
       
        <cost_center_code>123456</cost_center_code>
       
       
       
        <cost_center_description>Business</cost_center_description>
       
       
       
        <department_code>99</department_code>
       
       
       
        <department_description>Information Technology</department_description>
       
       
       
        <department_head_emp_id>987654</department_head_emp_id>
       
       
       
        <employee_id>456789</employee_id>
       
       
       
        <first_name>John</first_name>
       
       
       
        <full_name>Public, John</full_name>
       
       
       
        <hourly_rate>5.350</hourly_rate>
       
       
       
        <job_code>PMBAPP</job_code>
       
       
       
        <job_title>Business</job_title>
       
       
       
        <last_name>Public</last_name>
       
       
       
        <lives_in_state>AK</lives_in_state>
       
       
       
        <location_code>ANCH</location_code>
       
       
       
        <location_description>Anchorage</location_description>
       
       
       
        <network_user_id>JPublic</network_user_id>
       
       
       
        <pay_group_code>KMH</pay_group_code>
       
       
       
        <rate_type_code>S</rate_type_code>
       
       
       
        <reports_to>789123</reports_to>
       
       
       
        <territory_code/>
       
       
       
        <tier>1</tier>
       
    </subordinate>

</subordinates

------------End xmlOutput --------------  (Yes, I am getting all of these empty lines in my output)

I am really at a loss on how to get this data into my form.

Thanks,

John