Get-MgReportEmailActivityUserDetail : Expression expected at position 5 in 'date==2022-03-06'

[mjgerena]

Get-MgReportEmailActivityUserDetail -Date '2022-03-06' -OutFile "D:\Export\LicensingReport\EmailActivityUserDetail$today.csv"
Get-MgReportEmailActivityUserDetail : Expression expected at position 5 in 'date==2022-03-06'.
At line:1 char:1

• Get-MgReportEmailActivityUserDetail -Date '2022-03-06' -OutFile "D:\E ...

•   + CategoryInfo          : InvalidOperation: ({ Date = 3/6/2022 12:00:00 AM }:<>f__AnonymousType16`1) [Get-MgReportEmailActivityUserDetail_Get2], RestException`1
    + FullyQualifiedErrorId : BadRequest,Microsoft.Graph.PowerShell.Cmdlets.GetMgReportEmailActivityUserDetail_Get2
  
  
  

Get-MgReportEmailActivityUserDetail : Cannot process argument transformation on parameter 'Date'. Cannot convert value "date==2022-03-06" to type "System.DateTime". Error: "The string was not recognized as a valid DateTime. There is an unknown word
starting at index 0."
At line:1 char:43

• Get-MgReportEmailActivityUserDetail -Date 'date==2022-03-06' -OutFile ...

•                                       ~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidData: (:) [Get-MgReportEmailActivityUserDetail], ParameterBindingArgumentTransformationException
  • FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-MgReportEmailActivityUserDetail

[RomainBenat]

Hi,
No updates on this issue ? Still experiencing it on version 1.11.1 and 1.15.0 :

Exception on both version :
Expression expected at position 5 in 'date==2022-10-12'.

Command on 1.15.0 :
Get-MgReportEmailActivityUserDetail -Date (get-date).AddDays(-27) -OutFile "test.csv"

CategoryInfo on 1.15.0 :
C:\Program Files\WindowsPowerShell\Modules\Microsoft.graph.Reports\1.15.0\exports\v1.0\ProxyCmdletDefinitions.ps1 : line 1796

[mjgerena]

Yes, same issue Get-MgReportEmailActivityUserDetail -Date (get-date).AddDays(-27) -OutFile "test.csv" Get-MgReportEmailActivityUserDetail : Expression expected at position 5 in 'date==2022-10-13'. At line:1 char:1 + Get-MgReportEmailActivityUserDetail -Date (get-date).AddDays(-27) -Ou ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: ({ Date = 10/13/2022 4:20:18 PM }:<>f__AnonymousType19`1) [Get-MgReportEmailActivityUserDetail_Get], RestException`1 + FullyQualifiedErrorId : BadRequest,Microsoft.Graph.PowerShell.Cmdlets.GetMgReportEmailActivityUserDetail_Get ***@***.*** From: Romain | McDo ***@***.***> Sent: Tuesday, November 8, 2022 6:09 AM To: microsoftgraph/msgraph-sdk-powershell ***@***.***> Cc: Shah, Maria J ***@***.***>; Author ***@***.***> Subject: [External]-Re: [microsoftgraph/msgraph-sdk-powershell] Get-MgReportEmailActivityUserDetail : Expression expected at position 5 in 'date==2022-03-06' (Issue #1486) CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Hi, No updates on this issue ? Still experiencing it on version 1.11.1 and 1.15.0 : Exception on both version : Expression expected at position 5 in 'date==2022-10-12'. Command on 1.15.0 : Get-MgReportEmailActivityUserDetail -Date (get-date).AddDays(-27) -OutFile "test.csv" CategoryInfo on 1.15.0 : C:\Program Files\WindowsPowerShell\Modules\Microsoft.graph.Reports\1.15.0\exports\v1.0\ProxyCmdletDefinitions.ps1 : line 1796 — Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/microsoftgraph/msgraph-sdk-powershell/issues/1486*issuecomment-1307033374__;Iw!!HQT58KVg!41TLf3juwdyVkWnZMcXw5sqTuHtzMwjjcGzkDlVwogNewEUu_qRiLUsTQ9IEzpjFO5gPt8JgLy3gzgSWkf-I$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AZXTY4PN5VRQF6ZL45Y4O4TWHIYFRANCNFSM6AAAAAAQDHXOCE__;!!HQT58KVg!41TLf3juwdyVkWnZMcXw5sqTuHtzMwjjcGzkDlVwogNewEUu_qRiLUsTQ9IEzpjFO5gPt8JgLy3gzvV7EnJi$>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

…

________________________________ DISCLAIMER & CONFIDENTIALITY NOTICE: This email neither constitutes an agreement to conduct transactions by electronic means nor creates any legally binding contract or enforceable obligation in the absence of a fully signed written contract. The information contained in this email and any attachments may be confidential, legally privileged and/or exempt from disclosure under applicable law. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. Any inadvertent or accidental disclosure of confidential, legally privileged and/or exempt information contained in this email does not constitute a knowing waiver of any rights regarding such information or materials. If you have received this communication in error, please reply to the sender and destroy all copies of the message (including any attachments).

[timayabi2020]

@mjgerena @McDoMaster after investigations, we found out that there is an issue with how the request is being constructed. The issue has been logged on our code generator repository

Meanwhile, you can try out this command Invoke-MgGraphRequest -OutputType HttpResponseMessage -Uri "https://graph.microsoft.com/v1.0/Reports/microsoft.graph.getEmailActivityUserDetail(date=2022-10-13)" -OutPutFile alternative.txt as an alternative

[peombwa]

@timayabi2020, let's look at using a directive that targets source-file-csharp to temporarily fix the issue in v2 as we wait for AutoREST team to fix the bug in their code generator at Azure/autorest.powershell#1025.

[peombwa]

Fixed by #2021