Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
7 subscribers
Views
1786 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am using webservicequery function to get list of all Cities (
vineeta6579
over 10 years ago
I am using webservicequery function to get list of all Cities (
www.webservicex.net/globalweather.asmx
. I am getting below error while testing.
"Server was unable to process request. ---> System.Data.SqlClient.SqlException: Procedure or function 'getWCity' expects parameter '@CountryName', which was not supplied. "
Attached:webservice Query code.
...
webservice.txt
OriginalPostID-110005
OriginalPostID-110005
Discussion posts and replies are publicly visible
Parents
0
Aleksi White
Appian Employee
over 10 years ago
The result you are seeing is expected, there is nothing wrong with your webservicequery in this case. I tested all the other operations for that port and they work fine. However GetXmlData does not work because it returns an XML node, which in this case likely contains unsupported types. I see the following error in my server.log when performing this operation:
The XSD could not be imported because it contains the unsupported construct: mixed content for complex types. No types have been imported.
This matches up with one of the expected errors in our documentation on importing XSDs:
forum.appian.com/.../Defining_a_Custom_Data_Type
Under the section "Possible Errors When Importing"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Aleksi White
Appian Employee
over 10 years ago
The result you are seeing is expected, there is nothing wrong with your webservicequery in this case. I tested all the other operations for that port and they work fine. However GetXmlData does not work because it returns an XML node, which in this case likely contains unsupported types. I see the following error in my server.log when performing this operation:
The XSD could not be imported because it contains the unsupported construct: mixed content for complex types. No types have been imported.
This matches up with one of the expected errors in our documentation on importing XSDs:
forum.appian.com/.../Defining_a_Custom_Data_Type
Under the section "Possible Errors When Importing"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data