- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
Total Likes