Hello-
I have been struggling to figure out a solution to this question; but I'm sure for you guys, this will be easy.
Let's say I have a CSV file that looks like this:
Names Expressions Accounts
Row 1: Name1 Exp1 Acct1
Row 2: Name2 Exp2 Acct2
Row 3: Name3 Exp3 Acct3
What I would like to do is loop the data into an Invoke-WebRequest POST command, like this:
foreach ($row in $CSV-file) {
$Body= @"
{
"name" : "$Row.Names.Value",
"Expression" : "$Row.Expressions.Value",
"account" : "$Row.Accounts.Value",
"static-field" : "staticvalue",
}
"@
Invoke-WebRequest -Uri $Url-ContentType "application/json" -Method POST -Headers $Headers -Body $Body
}
This would mean that the above $Body gets looped 3 times, one for each row:
$Body= @"
{
"name" : "Names1",
"Expression" : "Exp1",
"account" : "Acct1",
"static-field" : "staticvalue",
}
"@
Invoke-WebRequest -Uri $Url-ContentType "application/json" -Method POST -Headers $Headers -Body $Body
}
$Body= @"
{
"name" : "Names2",
"Expression" : "Exp2",
"account" : "Acct2",
"static-field" : "staticvalue",
}
"@
Invoke-WebRequest -Uri $Url-ContentType "application/json" -Method POST -Headers $Headers -Body $Body
}
Etc.
What is the best way to do something like this?
