Difference between revisions of "ShaleApps test"
(Created page with "Run powershell ISE or VS code <code> $headers = @{"Authorization"="Bearer 7b727141-d4e9-8ed4-4160-10b9a020f609"} $filter = "623360-101520190-B40" $url = "https://api.shaleapp...") |
|||
| Line 1: | Line 1: | ||
Run powershell ISE or VS code | Run powershell ISE or VS code | ||
| − | < | + | <pre> |
| + | |||
$headers = @{"Authorization"="Bearer 7b727141-d4e9-8ed4-4160-10b9a020f609"} | $headers = @{"Authorization"="Bearer 7b727141-d4e9-8ed4-4160-10b9a020f609"} | ||
$filter = "623360-101520190-B40" | $filter = "623360-101520190-B40" | ||
| Line 27: | Line 28: | ||
} | } | ||
} | } | ||
| − | </ | + | </pre> |
Revision as of 15:49, 8 July 2020
Run powershell ISE or VS code
$headers = @{"Authorization"="Bearer 7b727141-d4e9-8ed4-4160-10b9a020f609"}
$filter = "623360-101520190-B40"
$url = "https://api.shaleapps.com/v1/orders?product=sandi&createdSince=2020-07-07T06:30:00.000000Z&pageLimit=100&page=1&salesOrderNumber=$($filter)"
$result = Invoke-RestMethod -Uri $url -Method GET -Headers $headers
For ($i=0; $i -lt $result.Count; $i++) {
$ticket = New-Object -TypeName psobject
$ticket | Add-Member -MemberType NoteProperty -Name BOL -Value $result[$i].bolNumber
$ticket | Add-Member -MemberType NoteProperty -Name Tag -Value $result[$i].salesOrderNumber
$ticket | Add-Member -MemberType NoteProperty -Name Status -Value $result[$i].logisticsStatus
if ($ticket.Status -ne "completed") {continue}
$ticket | Add-Member -MemberType NoteProperty -Name Mileage -Value $result[$i].billing.loadedMileage
For ($j=0; $j -lt $result[$i].tasks.Count; $j++) {
For ($k=0; $k -lt $result[$i].tasks[$j].subTasks.Count; $k++) {
if ($result[$i].tasks[$j].subTasks[$k].type -eq "pickup") {
$ticket | Add-Member -MemberType NoteProperty -Name LoadingFacility -Value $result[$i].tasks[$j].site.name
}
if ($result[$i].tasks[$j].subTasks[$k].type -ne "dropoff") {continue}
if ($result[$i].tasks[$j].subTasks[$k].payload.unitOfMeasure -ne "pounds") {continue}
if ($result[$i].tasks[$j].subTasks[$k].payload.type -ne "sand") {continue}
$ticket | Add-Member -MemberType NoteProperty -Name Amount -Value $result[$i].tasks[$j].subTasks[$k].payload.actualAmount
$ticket | Add-Member -MemberType NoteProperty -Name Proppant -Value $result[$i].tasks[$j].subTasks[$k].payload.name
Write-Host $ticket
}
}
}
