We are running an AirDrop and want to check the unfunded Trustlines for our coin. Is there a quicker way to check rather than going one by one. All inputs appreciated.
Finding all unfundend trustlines for a token
You can use the Horizon API to get all the accounts (by pages) that have a Trustlines with your coin.
Like this: https://horizon.stellar.org/accounts/?asset=USDC%3AGA5ZSEJYB37JRC5AVCIA5MOP4RHTM335X2KGX3IHOJAPP5RE34K4KZVN
You then only need to filter the records by the amount they are holding (to separate unfunded accounts)
There you go, you got it working. I think that's one of the faster ways to get the accounts, with an script you will be able to basically get all the accounts in a matter of seconds
BUT HOW DO WE FIND A LIST OF UNFUNDED ACCOUNTS. AAT THE MOMENT WE ARE CHECKING EACH TRUSTLINE ONE BY ONE
As I said before, once you get the JSON from the Horizon API, you then only need to filter by those accounts with more than 0 in their balance. If you don't want to do it manually you need to code an script that consumes the response from the API, filter them and at the end it only gives you the public key of each account (maybe in a .txt file)
OH OK. IT IS TOO TECHNICAL FOR ME. I'LL STICK TO GOING 1 BY 1. THANK YOU FOR YOUR TIME. REALLY APPRECIATE IT.
Dude... we can hear you without the caps lock...
DevNullProd soory. wasn't intended to be loud.
5 days later
will you be able to do it for us. you can ontact me on asojan1@yahoo.co.uk
bkolobara changed the title to Finding all unfundend trustlines for a token .
6 days later
earrietadev Do you work privately would like to chat one to one if possible.
AsoJan Sure, I just sent you an email