I have issues with updating stringcollection type

[GangadharMFord]

Hi, I'm using PowerShell script to create and update my custom Microsoft Search graph connector. And I'm having issues while updating string collection value type. And getting Schme malformed error message.

In schema defined as:
@{
name = "tags"
type = "StringCollection"
isQueryable = "true"
isSearchable = "true"
isRetrievable = "true"
}
@{
name = "categories"
type = "StringCollection"
isQueryable = "true"
isSearchable = "true"
isRetrievable = "true"
}
And in PowerShell script, with $item value :
$categoryPaths = if ($.categoryPaths -eq $null) { @() } else { @($.categoryPaths | ForEach-Object { $_.fullPath }) }
$categoryPathsFormatted = '["' + ($categoryPaths -join '","') + '"]'

    $tags = if ($_.tags -eq $null) { @() } else { @($_.tags) }
    $tagsFormatted = '["' + ($tags -join '","') + '"]'    

$item = @{
        id = $index
        properties = @{
            '[email protected]'    = 'Collection(String)'  
            categories                 = $categoryPathsFormatted 
             
            '[email protected]'          = 'Collection(String)'
            tags                       = $tagsFormatted     
        }
        content = @{
            value = $_.title
            type  = 'text'
        }
        acl = @(
            @{
                accessType = "grant"
                type       = "user"
                value      = "<<GUID>>"
            }
        )
        activities = @(@{
            "@odata.type" = "#microsoft.graph.externalConnectors.externalActivity"
            type          = "created"
            startDateTime = "2024-09-25T07:10:46.261Z"
            performedBy   = @{
                type = "user"
                id   = $externalConnection.userId
            }
        })
    }

Still getting error and my input values for Categeries and tags are in below format:
tags : {EnterpriseSearch, Search, Enterprise Search, Testing}
categoryPaths : {@{categoryId=e918e06f-8400-44fc-922b-XXXXXXX; name=Testing+; fullPath=Testing+; restricted=False},
@{categoryId=7dfd8441-bbc0-4497-a3fc-XXXXXXXX; name=Test Category; fullPath=Test Category; restricted=False}}

And Getting the error is:
Set-MgExternalConnectionItem_Set:
Line |
66 | Set-MgExternalConnectionItem -ExternalConnectionId $exter …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The request is malformed or incorrect.

Status: 400 (BadRequest)
ErrorCode: InvalidRequest
Date: 2024-11-09T15:16:36

Body:
{
"error": {
"code": "InvalidRequest",
"message": "The request is malformed or incorrect.",
"innerError": {
"code": "DeserializationError",
"message": "One or more errors occurred. (One or more errors occurred. (A property 'categories' which only has property annotations in the payload but no property value is an open property. In OData, open property must be represented as a property with value.))",
"date": "2024-11-09T15:16:36",
"request-id": "ad78d5ef-ca2b-4ecd-b347-29d495685653",
"client-request-id": "3cdd722e-afd2-4aa0-8578-bc89b9400eeb"
}
}
}
Any help or suggestions please?

[waldekmastykarz]

Have you looked at how the request that's actually going over the wire looks like? It could help you understand what's wrong.