ShaleApps test

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