問題描述
我使用以下代碼成功查詢了一個服務 從這里
"username", "password" => "password");$listName = "{2882F083-8890-4ADA-A1FC-39ED1D63D825}";$rowLimit = '150';$wsdl = "http://localhost:89/list.wsdl";$soapClient = new SoapClient($wsdl, $authParams);$params = array('listName' => $listName, 'rowLimit' => $rowLimit);$rawXMLresponse = null;嘗試{$rawXMLresponse = $soapClient->GetListItems($params)->GetListItemsResult->any;}趕上(SoapFault $fault){echo '故障代碼:'.$fault->faultcode;echo '故障字符串:'.$fault->faultstring;}echo ''.$rawXMLresponse .'</pre>';$dom = 新的 DOMDocument();$dom->loadXML($rawXMLresponse);$results = $dom->getElementsByTagNameNS("#RowsetSchema", "*");foreach($results 作為 $result){echo $result->getAttribute("ows_LinkTitle")."<br/>";echo $result->getAttribute("ows_Body")."<br/>";}未設置($soapClient);?>
但是屬性 ows_Body 沒有顯示,可能是因為沒有在 $rawXMLresponse 中獲取該屬性.我如何在響應中得到它?如果 GetListItems 需要額外的查詢參數,我該如何格式化?
下面是從 rawXMLresponse 返回的內容
<pre><listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A2802F-100xml="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"><rs:data ItemCount="3"><z:row ows_Attachments="0" ows_LinkTitle="低溫和水母" ows_Modified="2010-08-03 09:43:56" ows_Notice_x0020_Type="日歷" ows_MetaInfo="1;#" ows__ModerationStatus="0" ows__Level="1" ows_Title="Hypothermia and Jellyfish" "owshidows_IDversion="1="2" ows_UniqueId="1;#{B90ECA8C-6FBB-476D-BF67-A05B07268591}" ows_FSObjType="1;#0" ows_Created_x0020_Date="1;#2010-07:38591"092010-07-29 09:38:52" ows_FileLeafRef="1;#1_.000" ows_FileRef="1;#Lists/kk3/1_.000"/><z:row ows_Attachments="0" ows_LinkTitle=《獵蛇》 ows_Modified="2010-08-03 09:43:42" ows_Notice_x0020_Type="Public" ows_MetaInfo="2;#" ows__ModerationStatus="0" ows__Level="1" ows_Title="The Hunting"Snark" ows_ID="2" ows_owshidenversion="2" ows_UniqueId="2;#{F070D967-97F1-40DF-803B-EF50424D205B}" ows_FSObjType="2;#0" ows_Created_x0020_Date="2;#2010-07"-29"2010-07-29 09:39:57" ows_FileLeafRef="2;#2_.000" ows_FileRef="2;#Lists/kk3/2_.000"/><z:row ows_Attachments="0" ows_LinkTitle="永遠不要低估自己" ows_Modified="2010-08-03 09:43:29" ows_Notice_x0020_Type="Public" ows_MetaInfo="3;#" ows__ModerationStatus="0" ows__Level="1" ows_TitleID="永遠不要低估_="3" ows_owshiddenversion="3" ows_UniqueId="3;#{4DBEC63E-E25F-4580-B5D8-590C584A6E95}" ows_FSObjType="3;#0" ows_Created_x0020_Date2:-09:-03;32" ows_Created="2010-07-29 09:40:32" ows_FileLeafRef="3;#3_.000" ows_FileRef="3;#Lists/kk3/3_.000"/></rs:data></listitems></pre>
嘗試將 ViewFields
參數添加到您的查詢中.這允許您指定在查詢中返回哪些字段以及以什么順序返回.
viewFields 是 GetListItems
元素的子元素:
<視圖字段><FieldRef Name="LinkTitle"/><FieldRef Name="Body"/></ViewFields></viewFields>
根據您提供的示例,我猜測您要查找的列名稱;您可能需要根據 SharePoint 在內部實際調用這些列的內容進行調整.
ows_
前綴被添加到列名中,因此除非從結果 XML 中檢索,否則您不會以該格式處理它們.
I successfully query a service with the following code from here
<?php
$authParams = array("login" => "username", "password" => "password");
$listName = "{2882F083-8890-4ADA-A1FC-39ED1D63D825}";
$rowLimit = '150';
$wsdl = "http://localhost:89/list.wsdl";
$soapClient = new SoapClient($wsdl, $authParams);
$params = array('listName' => $listName, 'rowLimit' => $rowLimit);
$rawXMLresponse = null;
try{
$rawXMLresponse = $soapClient->GetListItems($params)->GetListItemsResult->any;
}
catch(SoapFault $fault){
echo 'Fault code: '.$fault->faultcode;
echo 'Fault string: '.$fault->faultstring;
}
echo '<pre>' . $rawXMLresponse . '</pre>';
$dom = new DOMDocument();
$dom->loadXML($rawXMLresponse);
$results = $dom->getElementsByTagNameNS("#RowsetSchema", "*");
foreach($results as $result){
echo $result->getAttribute("ows_LinkTitle")."<br/>";
echo $result->getAttribute("ows_Body")."<br/>";
}
unset($soapClient);
?>
However the attribute ows_Body doesnt display, probably because the atribute is not fetched in the $rawXMLresponse. How do I get that in the response? If the GetListItems requires an extra query paramater how do I format that?
below is what is returned from the rawXMLresponse
<pre><listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"><rs:data ItemCount="3"><z:row ows_Attachments="0" ows_LinkTitle="Hypothermia and Jellyfish" ows_Modified="2010-08-03 09:43:56" ows_Notice_x0020_Type="Calendar" ows_MetaInfo="1;#" ows__ModerationStatus="0" ows__Level="1" ows_Title="Hypothermia and Jellyfish" ows_ID="1" ows_owshiddenversion="2" ows_UniqueId="1;#{B90ECA8C-6FBB-476D-BF67-A05B07268591}" ows_FSObjType="1;#0" ows_Created_x0020_Date="1;#2010-07-29 09:38:52" ows_Created="2010-07-29 09:38:52" ows_FileLeafRef="1;#1_.000" ows_FileRef="1;#Lists/kk3/1_.000"/><z:row ows_Attachments="0" ows_LinkTitle="The Hunting of the Snark" ows_Modified="2010-08-03 09:43:42" ows_Notice_x0020_Type="Public" ows_MetaInfo="2;#" ows__ModerationStatus="0" ows__Level="1" ows_Title="The Hunting of the Snark" ows_ID="2" ows_owshiddenversion="2" ows_UniqueId="2;#{F070D967-97F1-40DF-803B-EF50424D205B}" ows_FSObjType="2;#0" ows_Created_x0020_Date="2;#2010-07-29 09:39:57" ows_Created="2010-07-29 09:39:57" ows_FileLeafRef="2;#2_.000" ows_FileRef="2;#Lists/kk3/2_.000"/><z:row ows_Attachments="0" ows_LinkTitle="Never undersell yourself" ows_Modified="2010-08-03 09:43:29" ows_Notice_x0020_Type="Public" ows_MetaInfo="3;#" ows__ModerationStatus="0" ows__Level="1" ows_Title="Never undersell yourself" ows_ID="3" ows_owshiddenversion="3" ows_UniqueId="3;#{4DBEC63E-E25F-4580-B5D8-590C584A6E95}" ows_FSObjType="3;#0" ows_Created_x0020_Date="3;#2010-07-29 09:40:32" ows_Created="2010-07-29 09:40:32" ows_FileLeafRef="3;#3_.000" ows_FileRef="3;#Lists/kk3/3_.000"/></rs:data></listitems></pre>
Try adding a ViewFields
parameter to your query. This allows you to specify which fields to return in the query and in what order.
viewFields is a child of the GetListItems
element:
<viewFields>
<ViewFields>
<FieldRef Name="LinkTitle" />
<FieldRef Name="Body" />
</ViewFields>
</viewFields>
Based on the example you gave, I'm guessing at the column names you'd be after; you may need to adjust to whatever SharePoint is actually calling those columns internally.
The ows_
prefix is added to the column name, so you wouldn't address them in that format except when retrieving from the result XML.
這篇關于Soapclient 查詢 Sharepoint Web 服務的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網!