VBA SOAP Remote Filter with Requirement_Retrieve function

Tuesday, January 26, 2016
Avatar
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=""https://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
Avatar
inflectra.sarahx
re: danyCB Tuesday, January 26, 2016
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

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Tuesday, January 26, 2016
  • Last Reply: Friday, January 29, 2016
  • Replies: 1
  • Views: 1531