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

}