OpenALPR Tool - Save and Query CSV Exports
- Thread starter Gymratz
- Start date
tech101
Known around here
Thank you so much for emailing them. Looking forward for this. Thank you @DLONG2
In the meanwhile I am trying to see how can we manually enter some of the vin data ? Any one has figured this out yet. I was poking around to even edit the autocheck.com url to my own domain name and poulate data by clicking plate forensics so far I have failed to get it to work, but I think the issue is the json format..
WTF does that mean LOL, another form letter? We do not care about vehicle history reports.
Frustrating but not surprising.
DLONG2
Known around here
- May 17, 2017
- 772
- 461
I found the year/make/model data most useful in doing a sort-by on the Body field, so that the apparent delivery trucks ("Walk-in Van", "Commercial Chassis", "Conventional Cab Truck", etc) can be grouped together. At that point I would tag any new FedEx/AMZN/UPS/etc. as "Delivery" in order to ignore them later.
tech101
Known around here
So I guess for those with programming skills much better than me...
With the original format of https://www.autocheck.com/consumer-api/meta/v1/summary/plate/%PLATENUMBER/state/ST - we now get the error message
If I type in this new format: https://www.autocheck.com/vehiclehistory/?siteID=5170&plate=PLATENUMBER&state=ST
So if I do this for example: AutoCheck.com
This comes up on the webpage:
So we do not get the VIN, but we get the year, make, model - is there any way that this could be pulled from the webpage?
OR, is the API command above still possible, and we just need to find the right combination if they changed it?
OR do we all start reaching out to them and each asking for the ability to get this as a hobbyist?
With the original format of https://www.autocheck.com/consumer-api/meta/v1/summary/plate/%PLATENUMBER/state/ST - we now get the error message
If I type in this new format: https://www.autocheck.com/vehiclehistory/?siteID=5170&plate=PLATENUMBER&state=ST
So if I do this for example: AutoCheck.com
This comes up on the webpage:
So we do not get the VIN, but we get the year, make, model - is there any way that this could be pulled from the webpage?
OR, is the API command above still possible, and we just need to find the right combination if they changed it?
OR do we all start reaching out to them and each asking for the ability to get this as a hobbyist?
DLONG2
Known around here
- May 17, 2017
- 772
- 461
I as an HTML amateur was looking briefly at the website yesterday, and analysing the cookies which the website produces, and couldn't see how to extract the string from the webpage. The returned data is embedded in a series of .js javascript files. While the data is present on the page, one would have to use the mouse and the context menu to manually copy it. The VIN and engine type was data which while I had also been collecting it, only the year/make/model and body fields were being used in my app's queries.
tech101
Known around here
In the meanwhile I am still gonna try to work things out with a programmer from fiverr at-least hopefully he can work out a manual way to add it.. Hopefully either @DLONG2 or @Gymratz can find some solution to automation of this. By the way Yeah I have no issues paying autocheck if they can provide us what we need. May be ask them how much for same kind of data which earlier we were able to get with API key even if they give some bizzare numbers We all can get together and pitch in.. But first we need to know the number or if its even possible anymore lol
tech101
Known around here
What my understanding on that is was this... Website was spitting those info out in Json format ..
which use to look something like this ..
The the software use to pull it out.. Now I have already try to alter domain and do exactly same format for plate forensic to see if I can at-least add this per vehicle this way by feeding it in that format so far I have been un-sucesfull my guess is that is becaose of that json format which I have no idea off..
which use to look something like this ..
code "0"
vin "XXXXXXXXXXXXXX5"
year "2014"
make "Honda"
model "Civic"
countryOfAssembly "Alliston, Ontario, Canada"
body "COUPE 2-DR"
vehicleClass "EX Coupe CVT"
recordCount 9
score 73
scoreRangeLow 53
scoreRangeHigh 71
buybackAssurance "ONE_YEAR"
lemonRecord false
accidentRecord false
floodRecord false
singleOwner true
engine "2.3L L4 SOHC 16V"
status "SUCCESS"
The the software use to pull it out.. Now I have already try to alter domain and do exactly same format for plate forensic to see if I can at-least add this per vehicle this way by feeding it in that format so far I have been un-sucesfull my guess is that is becaose of that json format which I have no idea off..
I found this that might be a different way to go about seeing if they will work with us than the Contact us form on autocheck?
developer.experian.com
Auto AccuSelect API Docs | Experian Global Developer
developer.experian.com
DLONG2
Known around here
- May 17, 2017
- 772
- 461
In some regard, if there was a particular plate we needed to look at then we could always come to their website to acquire it. Adding to the database is an easy matter, but GymRatz's coding is different from mine, and he is much better at SQL statements than I am.
Two ways come to mind to do this. One is to allow editing within the DatagridView. Another way is to build a separate form to input the needed data, and have "Save" and "Cancel" buttons on the new form, along with textboxes for year/make/model/body/etc. A SQL insert statement would add the record into the table where VIN data is stored. Accessing the new input form could be via an "Add VIN" button, making the new form appear.
Two ways come to mind to do this. One is to allow editing within the DatagridView. Another way is to build a separate form to input the needed data, and have "Save" and "Cancel" buttons on the new form, along with textboxes for year/make/model/body/etc. A SQL insert statement would add the record into the table where VIN data is stored. Accessing the new input form could be via an "Add VIN" button, making the new form appear.
tech101
Known around here
Wow, I think that is ecactly what we need. How much will this API registered accounts are ? ??? @DLONG2 say even if we can all get one account and share ?I found this that might be a different way to go about seeing if they will work with us than the Contact us form on autocheck?
Auto AccuSelect API Docs | Experian Global Developer
DLONG2
Known around here
- May 17, 2017
- 772
- 461
Still looking, but this might fit the bill. I signed up with an account. There's no discussion of payment plans . . yet.
After signing up, the next step is to create an app. There's a lot of different datasets, but I selected the AutoCheck AccuSelect Sandbox.
After the app is created (and they allow 15 apps) I was given a client ID and a client secret.
Now I am able to use the account, at least in this 'sandbox' environment. Their immediate example is in curl, which I do not know.
After signing up, the next step is to create an app. There's a lot of different datasets, but I selected the AutoCheck AccuSelect Sandbox.
After the app is created (and they allow 15 apps) I was given a client ID and a client secret.
Now I am able to use the account, at least in this 'sandbox' environment. Their immediate example is in curl, which I do not know.
DLONG2
Known around here
- May 17, 2017
- 772
- 461
@DLONG2 - as always, thanks for helping us all figure this out!
Do you think 100 API calls per day is a good number? I guess it depends on each persons situation - a dead-end subdivision would be different than a main road.
I assume that the OpenALPR Tool only sends the request for a new plate and if the plate is already in our system, it just pulls from that?
It looks like down at the bottom is the "code" for to input plate and state?
Fingers crossed that just by setting up your account, it allows it to be used free, but I doubt it LOL.
Do you think 100 API calls per day is a good number? I guess it depends on each persons situation - a dead-end subdivision would be different than a main road.
I assume that the OpenALPR Tool only sends the request for a new plate and if the plate is already in our system, it just pulls from that?
It looks like down at the bottom is the "code" for to input plate and state?
Fingers crossed that just by setting up your account, it allows it to be used free, but I doubt it LOL.
And then what about when I come across a site like this:
rapidapi.com
And it looks like only charged if getting a report? Is this an old website and won't work now with the new captcha change or is there a way to make this work?
Or this one is free for 10/month?
rapidapi.com
Or another that is free for 10/month
Or if someone could figure out how to extrapolate out just the VIN, this could allow a script/routine to be written to decipher the VIN:
Vini
Lookup history of USA vehicles by VIN number from famous providers for the single price. Available reports: Carfax, Autocheck, Copart (auction photo report)
rapidapi.com
And it looks like only charged if getting a report? Is this an old website and won't work now with the new captcha change or is there a way to make this work?
Or this one is free for 10/month?
US License Plate to VIN
Search our US license plate database and lookup VIN by license plate and state. Start your trial with our free BASIC plan!
rapidapi.com
Or another that is free for 10/month
Or if someone could figure out how to extrapolate out just the VIN, this could allow a script/routine to be written to decipher the VIN:
Vehicle API
vpic.nhtsa.dot.gov