I had something similar happening a long time ago when I was handling bank transactions. What I ended up doing at the time was inserting a repeat of the api data, then a query to search for an id field returned by the bank, and adding a condition for length and if returned, ignore the record.
It was also suggested to use an index, but I don't believe I ever tested that.