Audit api(/api/data/v9.0/audits) for Microsoft Dynamics online gives error when expand=userid parameter is used

Sheetal Shetty 26 Reputation points
2022-01-21T10:56:07.54+00:00

Hi,

I am using the Microsoft dynamics Audit API https://learn.microsoft.com/en-us/dynamics365/customer-engagement/web-api/audit?view=dynamics-ce-odata-9

When i use the userid property(listed under Single value navigation property) it does not work and gives this 400 error:

Request <instanceurl>/api/data/v9.0/audits?$expand=userid

{"error":{"code":"0x80040216","message":"Only inner join is supported for Audit query."}}

Can somebody help get a solution to this or suggest an alternative to fetch the useremail address for the audit entry created?

Thanks,
Sheetal

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
25,266 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ravi Kanth Koppala 2,756 Reputation points Microsoft Employee
    2022-01-21T11:14:31.923+00:00

    @Sheetal Shetty ,
    Microsoft Q&A doesn't support Dynamics. Please post your question in the Dynamics community - https://community.dynamics.com/

    ----------

    If this answers your query, do click “Accept the answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread.

    Thaks

  2. ShashiShailaj-MSFT 7,431 Reputation points Microsoft Employee
    2022-01-21T12:18:12.503+00:00

    @Sheetal Shetty ,

    Thank you for your query . Dynamics products are not supported on QnA forum at this point. I would suggest you to post the query on https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum for greater visibility to the right set of experts who can help in this case.

    Thank you .

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification