Populate table problem (BSC programming tutorial)

Moralis General
#1

Hello guys i have a quick qzestion regarding a table im trying to populate, following daniels video about BSC programming (full course).
this is the error im getting when i click the button that should populate the table (leaderboard)

Screen Shot 2021-11-30 at 10.57.14 AM
Screen Shot 2021-11-30 at 10.57.14 AM1294×466 65 KB

this is a part of the functions of the code

async function populate(){
      const name = await Moralis.Web3API.account.getTokenBalances({chain: chainToQuery}).then(buildLeaderboardTable);
    }

    function buildLeaderboardTable(data){
     document.getElementById("resultLeaderboard").innerHTML = 
      `<table class ="table table-dark table-striped" id="leaderboardTable">
      </table>`;
      const table = document.getElementById("leaderboardTable");
      const rowHeader = `<thead>
        <tr>
          <th>Rank</th>
          <th>Score</th>
          <th>Username</th>
          <th>Address</th>
          <th>Last Seen</th>
          </thead>`
      table.innerHTML += rowHeader

      for(let i = 0; i < data.length; i++){
        let row = 
        `<tr>
            <td>${data[i].name}</td>
            <td>${data[i].score}</td>
            <td>${data[i].username}</td>
            <td>${data[i].address}</td>
            <td>${data[i].lastseen}</td>
        </tr>`
        table.innerHTML +=row;
      }
    }

note that for testing purposes im just starting to get a token name in of my balances, down the line i want to populate it with other elements from the backend that will be fed into it from my game dapp. Anyhow - what am i missing exactly to avoid the error?

thank you!

#2

for this in order to make, without giving the address as parameter, you’ll have to be authenticated and when you are authenticated it will use the eth address of current user

#3

thank you for the response. the thing is the function populate(); is run upon the launch of the app like so:

function launchApp(){
if(!user!){
alert("not logged in")
}else {
console.log(user.get("ethAddress"));
populate ();
}```
#4

so it would work or what am i missing exactly? than you once again @cryptokid

#5

do you get there the ETH Address of current user?

what you get if you run directly in your browser console:

name = await Moralis.Web3API.account.getTokenBalances({chain: 'bsc'})
#6

from logs it looks like "chain":"binance testnet", was tried, and for address the entire user object

#7

Yes useradress is shown via console.log.
If i type in

name = await Moralis.Web3API.account.getTokenBalances({chain: 'bsc'})

in the browser it throws:

Screen Shot 2021-11-30 at 1.27.24 PM
Screen Shot 2021-11-30 at 1.27.24 PM1856×1334 370 KB

#8

@cryptokid it does throw it either with chain: "bsc" or chain: "bsc testnet"

#9

what if happens if you use:

name = await Moralis.Web3API.account.getTokenBalances({chain: ‘bsc testnet’, address: user.get(“ethAddress”)})

#10

unfortunately this
Screen Shot 2021-11-30 at 1.47.55 PM

#11

it may be because of quotes, you could delete those " and write new ones

#12

word. that was it!
so i changed it to this now but it still would not populate the table for some reason.

Screen Shot 2021-11-30 at 1.53.28 PM
Screen Shot 2021-11-30 at 1.53.28 PM1428×198 35.4 KB

#13

maybe you can call that buildLeaderboardTable function explicitly with the result of the function

#14

what do you mean with that, putting the buildLeaderboardTable function right into the populate function?

#15

I mean something like:

async function populate(){
      const name = await Moralis.Web3API.account.getTokenBalances({chain: chainToQuery}).then(buildLeaderboardTable);
    }

=>

async function populate(){
      const name = await Moralis.Web3API.account.getTokenBalances({chain: chainToQuery})
      buildLeaderboardTable(name);
    }
#16

thank you! this worked. i also had a mistake further up in the code that i didnt show in this thread. it had to do with the ID of a div as well.

Anyway bare with me for one moment: obviously i dont need tokenbalances for a leaderboard. What i would actually need is at least these 3 columns

Screen Shot 2021-11-30 at 2.33.46 PM
Screen Shot 2021-11-30 at 2.33.46 PM898×242 25.5 KB

address i think i can get right but how do i get individually added columns like score or username in this function? It is part of the leaderboard object in the moralis data base seen like so:
Screen Shot 2021-11-30 at 2.34.37 PM

Would it be something like
Moralis.Web3API.account.get(Leaderboard, score) or how do you do it?

Thank you so much

#17

you can write console.log(JSON.stringify(user)) to see what data you have there
you may have all you need in that user object

#18

hmm it just shows me some information but not really what im looking for.

is there an option for custom functions like to retrieve extended objects / columns and rows?

#19

you can query directly the User class to see what info you get that way

this is the general documentation for queries:
https://docs.moralis.io/moralis-server/database/queries#basic-queries

1 Like
#20

thanks @cryptokid im looking at the documentation right now. will get back to you if i need some more guidance.