SyteLine ION API IDO Request Generator

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

$ionapiPath = 'C:\secure\syteline_backend.ionapi'
$suitePath  = 'CSI/IDORequestService'
$config     = 'TENANT_PRD_DEM'
$ido        = 'SLItems'
$props      = 'Item,Description,UM'
$filter     = "Item LIKE 'PN-%'"
$recordCap  = 200
$maxPages   = 50

# The .ionapi file is a secret: it holds the client secret and service account keys.
$c = Get-Content -Raw -Path $ionapiPath | ConvertFrom-Json

# OAuth2 password grant with the backend service account access and secret keys
$tokenUrl = $c.pu + $c.ot
$body = @{ grant_type = 'password'; username = $c.saak; password = $c.sask; client_id = $c.ci; client_secret = $c.cs }
$tok = Invoke-RestMethod -Method Post -Uri $tokenUrl -Body $body

$headers = @{
  Authorization            = 'Bearer ' + $tok.access_token
  'X-Infor-MongooseConfig' = $config
  Accept                   = 'application/json'
}

$base  = $c.iu.TrimEnd('/') + '/' + $c.ti + '/' + $suitePath.Trim('/') + '/ido/load/' + $ido
$query = '?properties=' + [uri]::EscapeDataString($props) + '&filter=' + [uri]::EscapeDataString($filter) + '&recordcap=' + $recordCap

$all  = @()
$resp = Invoke-RestMethod -Method Get -Uri ($base + $query) -Headers $headers
if (-not $resp.Success) { throw $resp.Message }
$all += $resp.Items
$page = 1

while ($resp.MoreRowsExist -and $page -lt $maxPages) {
  $next = $query + '&loadtype=NEXT&bookmark=' + [uri]::EscapeDataString($resp.Bookmark)
  $resp = Invoke-RestMethod -Method Get -Uri ($base + $next) -Headers $headers
  if (-not $resp.Success) { throw $resp.Message }
  $all += $resp.Items
  $page++
}

"Rows loaded: " + $all.Count
$all | Select-Object -First 20 | Format-Table -AutoSize

# Path to the same .ionapi file on the Linux or WSL host that runs this script
F='/secure/syteline_backend.ionapi'
PU=$(jq -r .pu "$F"); OT=$(jq -r .ot "$F")
IU=$(jq -r .iu "$F"); TI=$(jq -r .ti "$F")
CI=$(jq -r .ci "$F"); CS=$(jq -r .cs "$F")
SAAK=$(jq -r .saak "$F"); SASK=$(jq -r .sask "$F")

TOKEN=$(curl -s -X POST "$PU$OT" \
  --data-urlencode grant_type=password \
  --data-urlencode "username=$SAAK" \
  --data-urlencode "password=$SASK" \
  --data-urlencode "client_id=$CI" \
  --data-urlencode "client_secret=$CS" | jq -r .access_token)

curl -s -G "$IU/$TI/CSI/IDORequestService/ido/load/SLItems" \
  -H "Authorization: Bearer $TOKEN" \
  -H "X-Infor-MongooseConfig: TENANT_PRD_DEM" \
  -H "Accept: application/json" \
  --data-urlencode "properties=Item,Description,UM" \
  --data-urlencode "filter=Item LIKE 'PN-%'" \
  --data-urlencode "recordcap=200" | jq '.MoreRowsExist, .Bookmark, (.Items | length)'

# Next page: add --data-urlencode "loadtype=NEXT" --data-urlencode "bookmark=<Bookmark value>"