Public/Invoke-JuribaAPIImportDepartmentFeedDataTable.ps1
|
function Invoke-JuribaAPIImportDepartmentFeedDataTable{ <# .Synopsis Loops a correctly formatted data table inserting all of the rows it contains. .Description Takes a System.Data.Datatable object with the columns required for the DwAPI user. Inserts these users one at a time. .Parameter Instance The URI to the Dashworks instance being examined. .Parameter APIKey The APIKey for a user with access to the required resources. .Parameter FeedName The name of the feed to be searched for and used. .Parameter ImportId The id of the user feed to be used. .Parameter DWDataTable [System.Data.DataTable] Data table containing the fields required to insert data into the DW user API. .Outputs Output type [string] Text confirming the number of rows to be inserted. #> [OutputType([string])] Param ( [parameter(Mandatory=$True)] [string]$Instance, [Parameter(Mandatory=$True)] [System.Data.DataTable]$DWDepartmentDataTable, [Parameter(Mandatory=$True)] [string]$APIKey, [parameter(Mandatory=$False)] [string]$FeedName = $null, [parameter(Mandatory=$False)] [string]$ImportId ) if (-not $ImportId) { if (-not $FeedName) { return 'Department feed not found by name or ID' } try{ $ImportId = (Get-JuribaImportDepartmentFeed -Instance $Instance -ApiKey $APIKey -Name $FeedName).id } catch { write-error "User feed lookup returned no results" exit 1 } if (-not $ImportId) { return 'Department feed not found by name or ID' } else { $Deleteheaders = @{ "X-API-KEY" = "$APIKey" } $Deleteuri = "{0}/apiv2/imports/departments/{1}/items" -f $Instance, $ImportId Invoke-RestMethod -Headers $Deleteheaders -Uri $Deleteuri -Method DELETE | out-null Write-Debug ("INFO: Deleted records for ImportID $ImportID, $Feedname") } } $Postheaders = @{ "content-type" = "application/json" "X-API-KEY" = "$APIKey" } $uri = "{0}/apiv2/imports/departments/{1}/items" -f $Instance, $ImportId $DWDepartmentDataTable | Foreach-Object -Parallel { $Row = $_ #Write-Progress -Activity Uploading -Status "Writing User Feed Object $RowCount" -PercentComplete (100 * ($RowCount / $Using:DWUserDataTable.Rows.Count)) $Body = $null $Body = $Row | Select-Object * -ExcludeProperty ItemArray, Table, RowError, RowState, HasErrors | ConvertTo-Json # Replace non-printable characters $Body = $Body -creplace '\P{IsBasicLatin}' try{ Invoke-RestMethod -Headers $Using:Postheaders -Uri $Using:uri -Method Post -Body ([System.Text.Encoding]::UTF8.GetBytes($Body)) -AllowInsecureRedirect | out-null }catch{ write-output "Error row sysid $($row.uniqueIdentifier) : $body" } #$RowCount++ } -ThrottleLimit 25 Return ("{0} departments sent" -f $DWDepartmentDataTable.Rows.Count) } |