HTTP Get or Post returns empty JSON array

Question

when I call my API Webservice its returns an empty array.

In my Header request, i have only a jwt token for authenticating

In Angular:

getSheets(): Observable<Sheet[]> {
return this.http.get(this.config.apiUrl + '/api/SheetsRelationAPI', this.jwt())
  .map(this.extractData)
  .do(data => console.log('SheetsData:', data))  // debug
  .catch(this.handleError);

In Asp.net MVC 5:

[HostAuthentication("bearer")]
[System.Web.Http.Authorize]
public class SheetsRelationAPIController : ApiController
{
    private GSheetsContext db = new GSheetsContext();

    // GET: api/SheetsRelation

    [ResponseType(typeof(SheetsRelationView))]
    public IQueryable<SheetsRelationView> GetSheetsRelation()
    {

        var claims = (User.Identity as System.Security.Claims.ClaimsIdentity).Claims;
        var username = "";
        foreach (var claim in claims)
            if (claim.Type.ToString() == "sub")
            {
                username = claim.Value.ToString();
            }
        //var tasks = from tsk in db.SheetsRelation.Include(s => s.SheetsContent.id  )
        //select tsk;

        var sheetsRelation = db.SheetsRelationView.Where(jt => jt.Username == username);




        return sheetsRelation;
    }
}

UPDATE 1:

It seems it's worked in PostMan and I have a JSON in response But in Angular, i haven't any JSON in response.

The claims seem to be emtpy. Have you debugged the controller to see what is going on? — Hinrich
– Hinrich, Commented Jul 10, 2017 at 13:16
i think this.http.get(this.config.apiUrl + '/api/SheetsRelationAPI', this.jwt()) should be this.http.get(this.config.apiUrl + '/api/SheetsRelationAPI', { headers: yourHeaders }. You have not specified what header you are sending in a key value pair. — Ekansh Rastogi
– Ekansh Rastogi, Commented Jul 10, 2017 at 13:22
@Hinrich The claims isn't empty, we test it with Postman and it successfully returns a JSON — Adnan
– Adnan, Commented Jul 11, 2017 at 4:37
@EkanshRastogi let me try your code , jwt() is a method that returns headers but I'm going to extract it and set it manually to see the result — Adnan
– Adnan, Commented Jul 11, 2017 at 4:40

Steve Land · Accepted Answer · 2017-07-10 13:21:47Z

1

Three things you may wish to try -

Not related to this issue, but I always decorate my APIs with the specific http method, to ensure there isnt any confusion on my part - [HttpGet] in this case.
Refactor your API class so that it doesnt have direct dependencies on GSheetsContext and User.Identity (make yourself an injectable service to handle that, so that you can mock the behavior.)
Unit test the controller method with mocked dependencies, so that you can be sure that your controller is behaving as it is expected to.

Edit, if that sounds like too much work

Comment out your existing controller logic and put a stub method there that just returns something like return db.SheetsRelationView.Create()

If that works, then you know your issue is not with your API, and is in the logic. Then refer back to steps 2 & 3 above ;)

answered Jul 10, 2017 at 13:21

Steve Land

4,8622 gold badges20 silver badges39 bronze badges

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

3 Comments

Adnan Over a year ago

I notice that if I calling the API outside of asp.net MVC Website domain, it works fine, but if I call it in the same domain like my angular project. it returns an empty JSON

Steve Land Over a year ago

Sounds like your claims are not being populated when calling from angular. Try adding logging in the method if you aren't able to debug it.

Steve Land Over a year ago

You could also consider returning Unauthorized() if there is no value found for your username claim.

Collectives™ on Stack Overflow

HTTP Get or Post returns empty JSON array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related