Colbytech Posted August 6, 2020 Share Posted August 6, 2020 (edited) New to the forum, hello everyone. I've ordered a 2020 F-150 and I've dug around the Internet and found the link to the API. I've got my VIN, pulled down the JSON file and I've been watching that because I don't want to my poor sales guy crazy. However, I've hit a status that he didn't know, and more searching led me here. The status is "Released to Body Company". Now, all the searches on this forum tend to be in the Vehicle Tracking section, and from what I have read, that infers that the truck has been sent somewhere (an upfitter, but I can't find an explanation for that term if it is an internal group or an external firm) for some additional work, or something like that. The only custom thing that I think is getting done is the spray-in bedliner, other than that it's a pretty standard order I thought. Is it as straightforward as that? Cheers Edited August 6, 2020 by Colbytech Quote Link to comment Share on other sites More sharing options...
akirby Posted August 6, 2020 Share Posted August 6, 2020 Most likely, yes - it's that simple. 1 Quote Link to comment Share on other sites More sharing options...
Colbytech Posted August 6, 2020 Author Share Posted August 6, 2020 2 hours ago, akirby said: Most likely, yes - it's that simple. Awesome, thanks so much for confirming. Quote Link to comment Share on other sites More sharing options...
Colbytech Posted August 11, 2020 Author Share Posted August 11, 2020 Getting closer, status just updated to Shipped Rail and primaryStatus is In Transit. I’m thinking there will be a lag as it comes across the border... Quote Link to comment Share on other sites More sharing options...
Colbytech Posted August 11, 2020 Author Share Posted August 11, 2020 Tried to find out what the Passing Arrival status is with no luck. Does anyone know? Quote Link to comment Share on other sites More sharing options...
fuzzymoomoo Posted August 12, 2020 Share Posted August 12, 2020 14 hours ago, Colbytech said: Tried to find out what the Passing Arrival status is with no luck. Does anyone know? It's still on a train 1 Quote Link to comment Share on other sites More sharing options...
Colbytech Posted August 12, 2020 Author Share Posted August 12, 2020 1 hour ago, fuzzymoomoo said: It's still on a train Awesome, thanks so much. Patience is soooo hard... Quote Link to comment Share on other sites More sharing options...
Colbytech Posted August 20, 2020 Author Share Posted August 20, 2020 So, my boredom has gotten the better of me (I'm currently recovering from some surgery), so I leveraged the AEMServices API, a bit of PowerShell and a scheduled task to send myself emails on how my truck is moving down the line... Here's the script I used (I used Outlook.com as the sening email because it's simple. If you don't use Outlook.com, you can either create a throwaway email in there, or change things to fit what you want): $To = "RecipientEmail@SomeDomain.com" #change this to the email address that you want the email to go to $From = "SenderEmail@outlook.com" #change this to the email address of the email account you are using to send the email $SMTPServer = "smtp.live.com" #this is the Outlook.com SMTP server. Change this if using another provider $Credential = Import-CliXml -Path "${env:\userprofile}\user.Cred" #this pulls in the stored credentials for the sending account (this may be why you want to use a throwaway account). Create the credential by running the following commands - $Credential = Get-Credential and then $Credential | Export-CliXml -Path "${env:\userprofile}\user.Cred" $request = "https://shop.ford.com/aemservices/shop/vot/api/customerorder/?partAttributes=BP2_.*&vin=XXXXXXXXXX" #put your VIN here $jsonresult = Invoke-WebRequest $request $data = $jsonresult | ConvertFrom-json $emailbody = "<h2>Here's the latest status of the truck!</h2><br><br>" $emailbody += "Truck Info: $($data.year) $($data.Make) $($data.Model) $($data.Trim)<br>" $emailbody += "Vin is $($data.VIN)<br><br>" $emailbody += "Order Date: $($data.receiptDate)<br>" $emailbody += "Build Date: $($data.productiondate) - Happy Birthday<br>" $emailbody += "Ship Date: $($data.shipmentDate)<br><br>" $emailbody += "Estimated days in transit: $($data.transitDate)<br>" $emailbody += "ETA Date: $($data.etaEndDate)<br><br><br>" $emailbody += "Delivered to Dealer Date: $($data.finalDeliveredDate)<br><br>" $emailbody += "Current Phase:<b> $($data.primaryStatus)</b><br>" $emailbody += "Current Status: <b>$($data.Status)</b>" Send-MailMessage -To $To -From $From -Subject "Truck Status is currently $($data.PrimaryStatus) - $($data.Status) as of $(Get-Date)" -BodyAsHTML -Body ($emailbody | Out-String) -SmtpServer $SMTPServer -Port "587" -UseSSL -Credential $credential I then set up a scheduled task to query every 12 hours (which is probably less often than I was refreshing my browser, and I get the email in my inbox. This is what it looks like (and the latest I received - woohoo): Not sure if this is of interest to anyone. Thanks to everyone who was patient and answered my questions. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.