0

My background is in Ethereum, where it is easy to get the full list of owners for a particular token (e.g. USDC) using The Graph or a node (by filtering Transfer events).

How can I do this with an SPL token?

1 Answer 1

1

I'm not sure you can

This is supposed to do the job :

let filters = {filters: [{memcmp:{

bytes: 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
offset: 0,
}}]};

let result = await connectionMainnet.getParsedProgramAccounts(TOKEN_PROGRAM_ID, filters);

BUT, you will probably get an error like "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA excluded from account secondary indexes" (that's what i'm getting from quicknode). Token program id is one of the program that has the largest set of accounts, hence, some (a lot ?) rpcs disabled it for this rpc method.

FYI, EPjF... = USDC

TOKEN_PROGRAM_ID is the publicKey object of the token program id (you can import it from @solana/spl-token)

You can check doc here : https://solana-labs.github.io/solana-web3.js/classes/Connection.html#getParsedProgramAccounts

Also, there is another method available, getLargestAccounts (https://solana-labs.github.io/solana-web3.js/classes/Connection.html#getLargestAccounts), and, as its name implies, it will not return ALL accounts, just the largest ones.

In any case, getting all USDC token accounts must be like thousands of accounts...

also, might be interested with this topic: Error: failed to get accounts owned by program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA excluded from account secondary indexes; this RPC (it's about the said error above)

The only solution i can see is by parsing all transactions linked to usdc, but that must be a heavy work since there must be millions of transactions... not even sure you can get them all.

2
  • Thanks for your answer. I've found this method in the meantime: getProgramAccounts. Would this work? (I'm very, very new to Solana) Sep 18, 2023 at 9:54
  • getProgramAccounts and getParsedProgramAccounts are almost the same, getParsedProgramAccounts just send back a parsed result (readable without any intervention), so my answer applies the same way with getProgramAccounts
    – Effe2
    Sep 18, 2023 at 13:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.