topic Connecting to Windchill via XML using Business Objects(WeBI) in Windchill Customization

topic Connecting to Windchill via XML using Business Objects(WeBI) in Windchill Customization https://www.ptcusercommunity.com/t5/Windchill-Customization/Connecting-to-Windchill-via-XML-using-Business-Objects-WeBI/m-p/410732#M7678 <HTML><HEAD></HEAD><BODY>We run a query via XML that performs a project search and translates the results using XSL.We have the Query-Objects xml & xsd file on the server.The result is an XML that shows projects & attributes.The problem is in this output, the COLLECTION & INSTANCE is listed in a manner that Business Objects does not understand. When this is generated, Windchill adds the "wc:" in front of COLLECTION & INSTANCE. If we remove this, Business Objects can create the connection OK.Does anyone know if we can modify this output to remove the "wc:"?<?xml version="1.0" encoding="UTF-8"?><wc:COLLECTION xmlns:wc="<A class="jive-link-external-small" href="http://www.ptc.com/infoengine/1.0" rel="nofollow" target="_blank">http://www.ptc.com/infoengine/1.0</A>"> -<com.amcorrigid.AM_PROJECT STATUS="0" TYPE="Object" NAME="output"> <wc:INSTANCE> <AM_PROJ_SEGMENT>xxxxxxxxxxxx</AM_PROJ_SEGMENT> <AM_PROJ_DESCRIPTION>xxxxxxxxxx</AM_PROJ_DESCRIPTION> <AM_PROJ_NAME>xxxxxxxxxxxxxx</AM_PROJ_NAME> <AM_CREATED>01/04/2010</AM_CREATED> <AM_PROJ_TYPE>xxxxxxxxxxxxx</AM_PROJ_TYPE> <AM_PROJ_NUMBER>xxxxxxxxxxx</AM_PROJ_NUMBER> <AM_PROJ_STATE>COMPLETED</AM_PROJ_STATE> <obid>OR:wt.projmgmt.admin.Project2:336391:<A class="jive-link-email-small" href="mailto:590620213-1382658489836-1091773784-228-4-144-10@plm.amcorrigid.com" target="_blank">590620213-1382658489836-1091773784-228-4-144-10@plm.amcorrigid.com</A></obid> <class>WCTYPE|wt.projmgmt.admin.Project2|com.amcorrigid.AM_PROJECT</class> </wc:INSTANCE></BODY></HTML> Fri, 15 Mar 2024 15:06:56 GMT tgudobba 2024-03-15T15:06:56Z Connecting to Windchill via XML using Business Objects(WeBI) https://www.ptcusercommunity.com/t5/Windchill-Customization/Connecting-to-Windchill-via-XML-using-Business-Objects-WeBI/m-p/410732#M7678 We run a query via XML that performs a project search and translates the results using XSL.We have the Query-Objects xml & xsd file on the server.The result is an XML that shows projects & attributes.The problem is in this output, the COLLECTION & INSTANCE is listed in Fri, 15 Mar 2024 15:06:56 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/Connecting-to-Windchill-via-XML-using-Business-Objects-WeBI/m-p/410732#M7678 tgudobba 2024-03-15T15:06:56Z