VBA SOAP Remote Filter with Requirement_Retrieve function

Tuesday, January 26, 2016 3:11:30 PM
Hi,

I am trying to filter the response with the AuthorId and it seems that the filter doesn't work. I'm using many other spirateam Import/export functions and they are all working. Is there somtething different I should do?

    "<soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"">" & _
            "<soap:Body>" & _
            "<Requirement_Retrieve xmlns=""http://www.inflectra.com/SpiraTest/Services/v4.0/"">" & _
            "<remoteFilters>" & _
            "<RemoteFilter>" & _
            "<PropertyName>" & "AuthorId" & "</PropertyName>" & _
            "<StringValue>" & "14" & "</StringValue>" & _
            "</RemoteFilter>" & _
            "</remoteFilters>" & _
            "<startingRow>" & 1 & "</startingRow>" & _
            "<numberOfRows>" & 9999 & "</numberOfRows>" & _
            "</Requirement_Retrieve>" & _
            "</soap:Body>" & _
            "</soap:Envelope>"



1 Replies
Friday, January 29, 2016 7:29:21 PM
Avatar
re: danyCB on Tuesday, January 26, 2016 3:11:30 PM
Hi Dany

Thanks for asking the question,

I believe the problem is that you are filtering using the 'StringValue' attribute, I would use the 'IntValue' instead:

    "<RemoteFilter>" & _
            "<PropertyName>" & "AuthorId" & "</PropertyName>" & _
            "<IntValue>" & "14" & "</IntValue>" & _
            "</RemoteFilter>" & _

Regards
Sarah
Statistics
  • Started: Tuesday, January 26, 2016 3:11:30 PM
  • Last Reply: Friday, January 29, 2016 7:29:22 PM
  • Replies: 1
  • Views: 280