Error when calling a json webservice from jquery

Question

I have scoured Google looking for this same issue and I cannot seem to find any help. Any assistance is appreciated. I have created a webservice asmx in C#:

    [WebMethod]
    [ScriptMethod()]
    public ListObj GetList(string ListName)
    {
        SqlConnection DBConnection = new SqlConnection();
        DBConnection.ConnectionString = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ToString();
        SqlDataReader DBReader = null;
        SqlCommand query = new SqlCommand("SELECT Lists.Text, Lists.Value FROM Lists WHERE ListName = '" + ListName + "'", DBConnection);
        List<string> text_list = new List<string>();
        List<string> value_list = new List<string>();

        DBConnection.Open();
        DBReader = query.ExecuteReader();
        while (DBReader.Read())
        {
            text_list.Add(DBReader["Text"].ToString());
            value_list.Add(DBReader["Value"].ToString());
        }
        DBConnection.Close();

        return new ListObj(text_list, value_list);
    }

i am attempting to call that method using jquery:

      <script type="text/javascript">
        $(document).ready(function () {

            $("#JoeTest").click(function () {
              $.ajax({  
                  type: "POST",
                  url: "/Portals/0/DnnListService.asmx/GetList",
                  data: {ListName: 'TestList'},
                  contentType: "application/json; charset=utf-8",  
                  dataType: "json",  
                  success: function(msg) {  
                      alert("Success: " + msg);  
                  },
                  error: function (msg) {
                      alert("Failed: "+ msg.status + ": " + msg.statusText);
                  }  
              });   
            });

        }); 
    </script>

If I go directly to the asmx I can input my string and get the data back, no problem: http://screencast.com/t/JQmHYoz5c http://screencast.com/t/xDuMJe7v1A

However, the ajax call above is returning an error:

{"Message":"An attempt was made to call the method \u0027GetList\u0027 using a POST request, which is not allowed.","StackTrace":" at System.Web.Script.Services.RestHandler.GetRawParams(WebServiceMethodData methodData, HttpContext context)\r\n at System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)","ExceptionType":"System.InvalidOperationException"}

Any ideas on what the issue may be?

Joe · Accepted Answer · 2011-04-05 22:29:39Z

4

I figured it out!

Here is what I had to do. In the jQuery I needed this:

            $("#JoeTest").click(function () {
                $.ajax({  
                    type: "POST",
                    url: "/Portals/0/DnnListService.asmx/GetList",
                    data: '{ ListName: "TestList" }',
                    contentType: "application/json; charset=utf-8",  
                    dataType: "json",
                    success: function(msg) {  
                        alert("Success: " + msg);  
                    },
                    error: function (msg) {
                        alert("Failed: "+ msg.status + ": " + msg.statusText);
                    }  
                });   
            });

Notice the data and the type parameters. And in the C# I needed to change

[ScriptMethod()]

to

[ScriptMethod]

Thanks to @peanutbutter_lou for the solution!

answered Apr 5, 2011 at 22:29

Joe

1371 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

micahhoover Over a year ago

Worked for me ... the data parameter fixed it (although I'm not sure how to extract the msg parameter).

m0sa · Accepted Answer · 2011-04-05 21:32:32Z

2

Use:

          $.ajax({  
              type: "GET",
              ...
          });

You also have to pass the data in the correct json format. To verify the value of the data parameter you can use JSON Lint. Change it like this:

data: '{"parameter1" : 1, "parameter2": "string" }'

Note the use of double quotes. Also, by passing the data as a string you bypass the jQuery data serialization.

edited Apr 5, 2011 at 21:32

answered Apr 5, 2011 at 20:44

m0sa

11k4 gold badges48 silver badges92 bronze badges

9 Comments

Joe Over a year ago

this causes another error: {"Message":"Invalid JSON primitive: TestList."

tster Over a year ago

@Joe, also fix the data as I describe in my answer.

Joe Over a year ago

Ok, Now I am getting a different error: Message":"Invalid web service call, missing value for parameter: \u0027ListName\u0027."

tster Over a year ago

@Joe, Use firebug or chrome dev tools to look at the exact request being made.

m0sa Over a year ago

the JSON parameter names must have double quotes. I've updated the answer.

|

tster · Accepted Answer · 2011-04-05 20:46:54Z

1

I think you need to do this too:

        $("#JoeTest").click(function () {
          $.ajax({
              ...
              data: "{'ListName': 'TestList'}",
              ...
          });   
        });

I've always had to do that with jquery when calling ASP.NET web services.

answered Apr 5, 2011 at 20:46

tster

18.3k6 gold badges57 silver badges72 bronze badges

2 Comments

Joe Over a year ago

I have replaced the code you mentioned above and I am receiving the same error.

tster Over a year ago

@Joe, also change to type: "GET"

Community · Accepted Answer · 2017-05-23 12:26:51Z

0

Looks a bit like this question, me thinks:
Using JQuery to call a WebMethod

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Apr 5, 2011 at 20:45

T4NK3R

4,3733 gold badges25 silver badges26 bronze badges

1 Comment

Joe Over a year ago

I tried the above solution by adding data: "{'ListName':'TestList'}" and the error remained the same.

Collectives™ on Stack Overflow

Error when calling a json webservice from jquery

4 Answers 4

1 Comment

9 Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

9 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related