WSS 2.0 Web Service - GetListsItems() Resolving GUIDS to column names.<font size=2> <p>Hello,</p> <p> </p> <p> </p> <p>We are storing Infopath documents in a WSS 2.0 SharePoint Form Library and and having trouble retrieving the Promoted properties of the infopath document. When publishing the infopath documents using the publication wizard some Form data is used as column data. </p> <p>We are attempting to access the the infopath form data via the Share point web service - GetListItems() method </p> <p> </p> <p>Using the Following Code:</p></font><font face=Sylfaen size=2> <p>wss2.</font><font face=Sylfaen color="#2b91af" size=2>Lists</font><font face=Sylfaen size=2> listService;</p> <p>listService = </font><font face=Sylfaen color="#0000ff" size=2>new</font><font face=Sylfaen size=2> wss2.</font><font face=Sylfaen color="#2b91af" size=2>Lists</font><font face=Sylfaen size=2>();</p> <p>listService.Credentials = </font><font face=Sylfaen color="#0000ff" size=2>new</font><font face=Sylfaen size=2> </font><font face=Sylfaen color="#2b91af" size=2>NetworkCredential</font><font face=Sylfaen size=2>(Username, Password, Domain);</p></font><font face=Sylfaen color="#2b91af" size=2> <p>XmlNode</font><font face=Sylfaen size=2> node = listService.GetListItems(</font><font face=Sylfaen color="#a31515" size=2>&quot;CAD Score Card Survey&quot;</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#a31515" size=2>&quot;{E73D034A-9A99-4B7A-9912-AAF13ACCF63C}&quot;</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#0000ff" size=2>null</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#0000ff" size=2>null</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#2b91af" size=2>String</font><font face=Sylfaen size=2>.Empty, </font><font face=Sylfaen color="#0000ff" size=2>null</font><font face=Sylfaen size=2>);</p></font><font face=Sylfaen color="#0000ff" size=2> <p>string</font><font face=Sylfaen size=2> inner = node.InnerXml;</p> <p>Yields the following results for the Promoted properties only.</p> <p>ows_ID=&quot;2&quot;</p> <p>ows_Title=&quot;Kentwood 23322.xml&quot;</p> <p>.</p> <p>.</p> <p>.</p> <p>ows_xd__x007b_0490A074_x002d_AF53_x002d_4F53_x002d_BDFE_x002d_30475788315B_x007d_=&quot;Kentwood Cat Clinic&quot;</p> <p>ows_xd__x007b_2B65B6DF_x002d_8BD7_x002d_431E_x002d_8427_x002d_54017995CDE8_x007d_=&quot;2008-05-29&quot;</p> <p>ows_xd__x007b_40964B65_x002d_2041_x002d_4EE1_x002d_887B_x002d_1A3D9B3A79D6_x007d_=&quot;0&quot;</p> <p>ows_xd__x007b_6D3A0163_x002d_7F64_x002d_4CF4_x002d_A4DC_x002d_EB3AEA5C8FC6_x007d_=&quot;CAD&quot;</p> <p>Can anyone explain how to resolve the GUIDs into friendly names? I've noticed that Access is able to resolve the the guids so I know it's possible</p> <p align=left> </p> <p align=left>Thanks,</p> <p align=left>Karl</p></font><font size=2> <p> </p></font>© 2009 Microsoft Corporation. All rights reserved.Thu, 02 Jul 2009 18:22:33 Z363af440-28fb-4e08-9ae4-105a1b564e58http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/363af440-28fb-4e08-9ae4-105a1b564e58#363af440-28fb-4e08-9ae4-105a1b564e58http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/363af440-28fb-4e08-9ae4-105a1b564e58#363af440-28fb-4e08-9ae4-105a1b564e58kfilipowskyhttp://social.msdn.microsoft.com/Profile/en-US/?user=kfilipowskyWSS 2.0 Web Service - GetListsItems() Resolving GUIDS to column names.<font size=2> <p>Hello,</p> <p> </p> <p> </p> <p>We are storing Infopath documents in a WSS 2.0 SharePoint Form Library and and having trouble retrieving the Promoted properties of the infopath document. When publishing the infopath documents using the publication wizard some Form data is used as column data. </p> <p>We are attempting to access the the infopath form data via the Share point web service - GetListItems() method </p> <p> </p> <p>Using the Following Code:</p></font><font face=Sylfaen size=2> <p>wss2.</font><font face=Sylfaen color="#2b91af" size=2>Lists</font><font face=Sylfaen size=2> listService;</p> <p>listService = </font><font face=Sylfaen color="#0000ff" size=2>new</font><font face=Sylfaen size=2> wss2.</font><font face=Sylfaen color="#2b91af" size=2>Lists</font><font face=Sylfaen size=2>();</p> <p>listService.Credentials = </font><font face=Sylfaen color="#0000ff" size=2>new</font><font face=Sylfaen size=2> </font><font face=Sylfaen color="#2b91af" size=2>NetworkCredential</font><font face=Sylfaen size=2>(Username, Password, Domain);</p></font><font face=Sylfaen color="#2b91af" size=2> <p>XmlNode</font><font face=Sylfaen size=2> node = listService.GetListItems(</font><font face=Sylfaen color="#a31515" size=2>&quot;CAD Score Card Survey&quot;</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#a31515" size=2>&quot;{E73D034A-9A99-4B7A-9912-AAF13ACCF63C}&quot;</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#0000ff" size=2>null</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#0000ff" size=2>null</font><font face=Sylfaen size=2>, </font><font face=Sylfaen color="#2b91af" size=2>String</font><font face=Sylfaen size=2>.Empty, </font><font face=Sylfaen color="#0000ff" size=2>null</font><font face=Sylfaen size=2>);</p></font><font face=Sylfaen color="#0000ff" size=2> <p>string</font><font face=Sylfaen size=2> inner = node.InnerXml;</p> <p>Yields the following results for the Promoted properties only.</p> <p>ows_ID=&quot;2&quot;</p> <p>ows_Title=&quot;Kentwood 23322.xml&quot;</p> <p>.</p> <p>.</p> <p>.</p> <p>ows_xd__x007b_0490A074_x002d_AF53_x002d_4F53_x002d_BDFE_x002d_30475788315B_x007d_=&quot;Kentwood Cat Clinic&quot;</p> <p>ows_xd__x007b_2B65B6DF_x002d_8BD7_x002d_431E_x002d_8427_x002d_54017995CDE8_x007d_=&quot;2008-05-29&quot;</p> <p>ows_xd__x007b_40964B65_x002d_2041_x002d_4EE1_x002d_887B_x002d_1A3D9B3A79D6_x007d_=&quot;0&quot;</p> <p>ows_xd__x007b_6D3A0163_x002d_7F64_x002d_4CF4_x002d_A4DC_x002d_EB3AEA5C8FC6_x007d_=&quot;CAD&quot;</p> <p>Can anyone explain how to resolve the GUIDs into friendly names? I've noticed that Access is able to resolve the the guids so I know it's possible</p> <p align=left> </p> <p align=left>Thanks,</p> <p align=left>Karl</p></font><font size=2> <p> </p></font>Thu, 03 Jul 2008 14:49:53 Z2008-07-03T14:49:53Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/363af440-28fb-4e08-9ae4-105a1b564e58#69e1bd44-b755-4daa-a817-0fed3527be9chttp://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/363af440-28fb-4e08-9ae4-105a1b564e58#69e1bd44-b755-4daa-a817-0fed3527be9cnpearson99http://social.msdn.microsoft.com/Profile/en-US/?user=npearson99WSS 2.0 Web Service - GetListsItems() Resolving GUIDS to column names.I have the exact same problem a year later.  Did you ever figure this out?Thu, 02 Jul 2009 17:21:44 Z2009-07-02T17:21:44Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/363af440-28fb-4e08-9ae4-105a1b564e58#1af695e1-d382-4a74-945d-8e410ed4ab0bhttp://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/363af440-28fb-4e08-9ae4-105a1b564e58#1af695e1-d382-4a74-945d-8e410ed4ab0bMike Walsh MVPhttp://social.msdn.microsoft.com/Profile/en-US/?user=Mike%20Walsh%20MVPWSS 2.0 Web Service - GetListsItems() Resolving GUIDS to column names.I don't really understand why InfoPath wasn't in the Title. <div><br/></div> <div>I'm now moving this to the InfoPath forum where it should probably have been all along.</div><hr class="sig">WSS FAQ sites: <a href="http://wssv2faq.mindsharp.com">http://wssv2faq.mindsharp.com</a> and <a href="http://wssv3faq.mindsharp.com">http://wssv3faq.mindsharp.com</a> <br/>Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) <a href="http://wssv3faq.mindsharp.com/Lists/v3 WSS FAQ/V Books.aspx">http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx</a>Thu, 02 Jul 2009 18:22:03 Z2009-07-02T18:22:03Z