Json data not rendering my html grid table

Question

I can't able to render my html grid table in angular using json data that is from mysql database.Please someone help me.

Output of the angular code

    export class UserlistComponent implements OnInit {

  users: Observable<User[]>;

  constructor(private _service:NgserviceService, private _route:Router) { }

  ngOnInit() {
    this.reloadData();
  }

  reloadData(){
    this.users = this._service.getUserList();
  }
}

It seems you have there array of arrays, not array of object therefore let user is array not object — Armen Stepanyan
– Armen Stepanyan, Commented Aug 31, 2020 at 7:20
make sure your collection 'users' is observable and check for errors in the browser console — Mujassir Nasir
– Mujassir Nasir, Commented Aug 31, 2020 at 7:21
my users is observable only and my browser console doens't throwing any errors @MujassirNasir — sathish kumar
– sathish kumar, Commented Aug 31, 2020 at 7:25

MoxxiManagarm · Accepted Answer · 2020-08-31 07:35:34Z

1

It seems you receive an array and not an object. You could simply map the received data and keep the rest.

reloadData() {
    this.users = this._service.getUserList().pipe(
      map(arrayUsers => arrayUsers.map(arrayUser => ({
        id: arrayUser[0],
        email: arrayUser[1],
        firstname: arrayUser[2],
        lastname: arrayUser[3],
      })))
    );
  }

answered Aug 31, 2020 at 7:35

MoxxiManagarm

9,2214 gold badges20 silver badges51 bronze badges

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

Comments

Mujassir Nasir · Accepted Answer · 2020-08-31 07:32:53Z

0

Your output seems to be CSV kind (array of an array) not the JSON. So, you need to use {{user[1]}} for email instead of {{user.email}} and {{user[2]}} for firstname instead of {{user.firstname}}

answered Aug 31, 2020 at 7:32

Mujassir Nasir

1,7304 gold badges32 silver badges52 bronze badges

Collectives™ on Stack Overflow

Json data not rendering my html grid table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related