Updating Database field filtering by API results

I have my Bubble data base set up with Product #s, On hand quantities, and Prices. I am connecting to an inventory system via API and returning Product #s, On hand quantities and Prices. Is there a way to use the returned API data ( specifically product #) as a filter to find and update prices and quantities?

Any help would be greatly appreciated !