Hook up API Truck Vin and Info

I would like to make a spreadsheet or app that will produce a report if I enter in any of the following:

Identify a company by imputing one of the following:

Vin, MC Number, DOT Number, Lic Plate number, company name, email, etc



I have the API connection to the get the information.



Once the name of the company is found:

I like to pull any other information such as Vin, Lic Plate number, email, phone, address, etc that is the same as



in otherwords

I put a vin number in. i get that truck is found with Terry Trucking



Terry Trucking has 5 vins associated with 3 other companies, ABC trucking, DEF Trucking, and sad boy trucking.



Besides that ABC trucking have the same phone number

and DEF trucking use the same address.



the API can be found here

https://data.transportation.gov/Trucking-and-Motorcoaches/Inspections-Per-Unit/wt8s-2hbx/about_data?referrer=grok.com



https://data.transportation.gov/Trucking-and-Motorcoaches/SMS-Input-Motor-Carrier-Census-Information/kjg3-diqy/about_data



https://data.transportation.gov/Trucking-and-Motorcoaches/Vehicle-Inspection-File/fx4q-ay7w/about_data