How to get all the nft id from full_node ?

[LCG22]

I want to do it

[LCG22]

When I query the NFT IDs from the coin_record of the full node, I use the code:

coin_records = session.query(CoinRecord).filter(CoinRecord.puzzle_hash == LAUNCHER_PUZZLE_HASH).limit(1000).all()

The return includes some NFT IDs and others that are not NFT IDs. When I use the wallet to query these IDs to get NFT info, it shows the result:
"Failed to get NFT info: {'error': 'The coin is not a NFT.', 'success': False}"

So, how can I get only NFT IDs from coin_record?

[BrandtH22]

Hey, there is no direct method of querying all nft ids from the block records. One could use the singleton launcher puzzle (it sounds like this is what you are doing) then determine which singletons are nfts from there. Or one could use one of the third party services that works to help with more advanced block record requests like this:
https://mojonode.com/explorer?q=select%20date_trunc(%27week%27,%20spent_at)%20as%20%22datetime%22,%0A%20%20%20count(*)%20filter%20(where%20puzzle-%3E%3E%27m%27%20in%20(%2724e044101e57b3d8c908b8a38ad57848afd29d3eecc439dba45f4412df4954fd%27,%20%277faa3253bfddd1e0decb0906b2dc6247bbc4cf608f58345d173adb63e8b47c9f%27))%0A%20%20%20%20%20%20%20%20%20%20as%0A%20%20%20%20%20%20%20%20%20%20%20%20%22singleton%22,%0A%20%20%20count(*)%20filter%20(where%20puzzle-%3E%3E%27m%27%20=%20%27adb656e0211e2ab4f42069a4c5efc80dc907e7062be08bf1628c8e5b6d94d25b%27)%20as%20%22p2%20singleton%22,%0A%20%20%20count(*)%20filter%20(where%20puzzle-%3E%3E%27m%27%20=%20%2737bef360ee858133b69d595a906dc45d01af50379dad515eb9518abb7c1d2a7a%27)%20as%20%22CAT2%22,%0A%20%20%20count(*)%20filter%20(where%20puzzle-%3E%3E%27m%27%20=%20%2772dec062874cd4d3aab892a0906688a1ae412b0109982e1797a170add88bdcdc%27)%20as%20%22CAT1%22,%0A%20%20%20count(*)%20filter%20(where%20puzzle-%3E%3E%27m%27%20=%20%277a32d2d9571d3436791c0ad3d7fcfdb9c43ace2b0f0ff13f98d29f0cc093f445%27)%20as%20%22nft%20did%20launcher%22,%0A%20%20%20--count(*)%20filter%20(where%20puzzle-%3E%27a%27-%3E%27%27%20=%20%277a32d2d9571d3436791c0ad3d7fcfdb9c43ace2b0f0ff13f98d29f0cc093f445%27)%20as%20%22nft%20did%20launcher%22,%0A%20%20count(*)%20filter%20(where%20puzzle_hash%20in%20(%27%5Cxcfbfdeed5c4ca2de3d0bf520b9cb4bb7743a359bd2e6a188d19ce7dffc21d3e7%27,%20%0A%20%20%27%5Cxbae24162efbd568f89bc7a340798a6118df0189eb9e3f8697bcea27af99f8f79%27))%20as%20%22offer%22,%0A%20%20count(*)%20filter%20(where%20puzzle-%3E%27a%27-%3E1-%3E%27a%27-%3E%3E0%20=%20%27a04d9f57764f54a43e4030befb4d80026e870519aaa66334aef8304f5d0393c2%27%0A%20%20%20%20%20%20)%20as%20%22NFT1%22%0A%20%20%20from%20chia.coin_records%20where%20spent_at%20%3E%20%272022-11-01%27%0A%20%20group%20by%20%22datetime%22%20order%20by%20%22datetime%22