A Question About Production Flow

[Colbytech]

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

[akirby]

Most likely, yes - it's that simple.

[Colbytech]

2 hours ago, akirby said:

Most likely, yes - it's that simple.

Awesome, thanks so much for confirming.

[Colbytech]

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...

[Colbytech]

Tried to find out what the Passing Arrival status is with no luck.  Does anyone know?

 

[fuzzymoomoo]

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 

[Colbytech]

1 hour ago, fuzzymoomoo said:

It's still on a train 

Awesome, thanks so much.

 

Patience is soooo hard...

[Colbytech]

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.