Powershell Syntax issue using LINQ

spiceuser-ih3sy · 2021-06-02T13:29:04.000Z

I am trying to write some code that will update a contact list using EWS API.
I grab the list of users using ADSI searcher, then I pull the current contacts from a mailbox using EWS API.

Next I use LINQ to compare the differences. I see if there are users that need to be imported as well as any users that need to be deleted because they no longer exist.

Here is my code (see Below)

Everything works above, but the trouble I am running in to no is the balues that are stored in $NeedsToBeAdded and $NeedsToBeDeleted I need to do stuff with. Th issue is, that these values only hold the user email address, and I need to process an import using the contact ID.

So then I try do a foreach-object {} loop and something like this: (See Below)

(Keep in mind I use Get as the method just for output), once it works, I would change the method to Delete to process the delete.
Now the code above I use should be able to get me that contacts ID info based on the output and value(s) stored in $NeedsToBeDeleted, however for some reason it prints out several users that don’t even match that filter.

For example if I want to filter out with using a user ID like billy bob. I changed a couple of values, but this is the layout of the contact Output when I output everything without any filtering.

I hope this makes sense and hopefully someone can assist me please. Thank you.

id                   : someLongID
createdDateTime      : 2021-06-02T02:54:47Z
lastModifiedDateTime : 2021-06-02T02:55:11Z
changeKey            : changeKEY
categories           : {}
parentFolderId       : parentfolderID
birthday             : 
fileAs               : Bob, Billy
displayName          : Billy Bob
givenName            : Billy
initials             : B.B.
middleName           : 
nickName             : 
surname              : Bob
title                : 
yomiGivenName        : 
yomiSurname          : 
yomiCompanyName      : 
generation           : 
imAddresses          : {}
jobTitle             : 
companyName          : 
department           : 
officeLocation       : 
profession           : 
businessHomePage     : 
assistantName        : 
manager              : 
homePhones           : {}
mobilePhone          : 
businessPhones       : {}
spouseName           : 
personalNotes        : 
children             : {}
emailAddresses       : {@{name=Billy Bob (bbob@domain.com); address=bbob@domain.com}}
homeAddress          : 
businessAddress      : 
otherAddress         :

#Get Users

$objSearcher=[adsisearcher]""
$objSearcher.Sort.PropertyName = "sn"
$objSearcher.Filter = "(&(extensionAttribute2=DynamicDistro)(|(mobile=*)(telephonenumber=*)))"
$colProplist = "extensionattribute2","initials","mobile","telephonenumber","GivenName","sn","DisplayName","Company","title","mail","department","photo","samaccountname"
foreach ($i in $colPropList){$objSearcher.PropertiesToLoad.Add($i) | out-null }
$Users = $objSearcher.FindAll()

#Get Contacts

$Contacts = Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/users/$UPN/contactFolders/$folderId/contacts?`$top=999" -Headers $headers -Method Get

#Create 2 variables

#Store User Emails
$A = $($Users.properties.mail)
#Store Contact Emails
$B = $($Contacts.value.emailAddresses::address)

<#
Check differences Between the 2
See if there are any "new" users that need to be added
See if there are any users that need to be deleted because they no longer exist in Add
#>

#Displays what accounts we need to import
$NeedsToBeAdded = [string[]]([Linq.Enumerable]::Except([object[]]$a, [object[]]$b))

#Displays what acocunts we need to delete because they no longer exist
$NeedsToBeDeleted = [string[]]([Linq.Enumerable]::Except([object[]]$b, [object[]]$a))

Neally · 2021-06-02T13:32:34.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

spiceuser-ih3sy · 2021-06-02T15:49:59.000Z

Sorry, for missing that, but when I do that it inserts it at the very end so it’s out of sync. I’ll see what I can do. Is there a way to do it in embedded code tags like

spiceuser-ih3sy · 2021-06-02T18:12:10.000Z

I would just like to add if I do something like this, it returns a bunch of contacts, not just the one specific to the email address input. However if I print out the variable “$NeedToAdd” it prints the correct email address, so I’m not sure why it’s not letting me add it as a variable in the filter.

Here is the code bit:

#Displays what accounts we need to import
$NeedsToBeAdded = [string[]]([Linq.Enumerable]::Except([object[]]$a, [object[]]$b))

#Displays what acocunts we need to delete because they no longer exist
$NeedsToBeDeleted = [string[]]([Linq.Enumerable]::Except([object[]]$b, [object[]]$a))

#(Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/users/$UPN/contactFolders/$folderId/contacts?`$top=999&$filter=emailAddresses/any(a:a/address eq 'bbob@domain.com')&$count=true" -Headers $headers -Method Get).value

if($NULL -ne $NeedsToBeDeleted)
{
    foreach($NeedToDelete in $NeedsToBeDeleted)
    {
        #(Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/users/$UPN/contactFolders/$folderId/contacts?`$top=1&$filter=emailAddresses/any(a:a/address eq '$($NeedToDelete)')&$count=true" -Headers $headers -Method Get).value
    }
}

if($NULL -ne $NeedsToBeAdded)
{
    foreach($NeedToAdd in $NeedsToBeAdded)
    {
        (Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/users/$UPN/contactFolders/$folderId/contacts?&$filter=emailAddresses/any(a:a/address eq '$NeedToAdd')&$count=true" -Headers $headers -Method Get).value
        Pause
    }
}