Get-FabricSqlDatabase does not process array of workspace correctly

[SQLDBAWithABeard]

Problem description

When passing an array to workspace object down the pipeline the function works correctly, however when passing the array as variable it does not

Verbose logs

PS > Get-FabricSQLDatabase -Workspace (Get-FabricWorkspace) -Verbose
VERBOSE: [2025-06-15 16:08:38] [Verbose] Validating token...
VERBOSE: [2025-06-15 16:08:38] [Verbose] Token validation completed.
MetadataError: Cannot convert the "System.Object[]" value of type "System.Object[]" to type "System.Guid".
VERBOSE: [2025-06-15 16:08:38] [Verbose] Target API Endpoint: https://api.fabric.microsoft.com/v1/workspaces//SqlDatabases
VERBOSE: Requested HTTP/1.1 GET with 0-byte payload
VERBOSE: Received HTTP/1.1 152-byte response of content type application/json
VERBOSE: Content encoding: utf-8
[2025-06-15 16:08:38] [Error] Unexpected response code: 400 from the API.
[2025-06-15 16:08:38] [Error] Error: Unable to process the operation due to an error in the request
[2025-06-15 16:08:38] [Error] Error Details:
[2025-06-15 16:08:38] [Error] Error Code: BadRequest

Module Version

pre-release FabricTools 0.30.0 alpha0276

Suggested solution

Use code examples and tests in #128

[NowinskiK]

however, when passing the array as variable, it does not

Because the functions were never designed to work in this way.
Example of good use with pipe:

Get-FabricWorkspace -WorkspaceName 'MsLearn-dev' | Get-FabricSQLDatabase

Hence, it's not a bug. It's a feature by design.
I'm not sure if we should prepare functions to be ready for array (Object[])