Need to retrieve a record based on column data

Hi all.
So I am making a custom WP site using AirTables as the core information hub. I have a page of products for sale. These links are made by pulling the record.get(‘URL’) of the product look. Works great! Now once they click on that link they go to the /products/record.get(‘URL’)
in my example it is /products/aviation
It is at this point I need to retrieve the entire record for product aviation. From the documentation it looks like I can’t retrieve unless I have the record id. At this point is my only option to loop through that products table again and run an if statement when I hit the record.get(‘URL’)==aircraft? Seems like alot of trouble to find the id. I can’t bring it over as a queryString on the incoming URL because I need that URL to work WITHOUT that queryString. Any thoughts?
New to it but love the API so far!