Trying to talk from Python to Sharepoint through SOAP.
One of the lists I am trying to query contains 'ID' as primary key field.
(Field){_RowOrdinal = "0"_FromBaseType = "TRUE"_DisplayName = "ID"_Name = "ID"_SourceID = "http://schemas.microsoft.com/sharepoint/v3"_ColName = "tp_ID"_StaticName = "ID"_PrimaryKey = "TRUE"_ReadOnly = "TRUE"_Type = "Counter"_ID = "{1d22ea11-1e32-424e-89ab-9fedbadb6ce1}"
},
We send the following request to query the list item with ID=77
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:ns0="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><ns1:GetListItems><ns1:listName>60e3f442-6faa-4b49-814d-2ce2ec88b8d5</ns1:listName><query><Query><Where><Eq><FieldRef Name="ID"/><Value Type="Counter">77</Value></Eq></Where></Query></query></ns1:GetListItems></SOAP-ENV:Body>
</SOAP-ENV:Envelope>
However Sharepoint returns all items from the list completely ignoring the query.
Any idea?