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

Sheetal Shetty 26 Reputation points


I am using the Microsoft dynamics Audit API

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?


Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,526 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ravi Kanth Koppala 3,231 Reputation points Microsoft Employee

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


    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.


    0 comments No comments

  2. Shashi Shailaj 7,581 Reputation points Microsoft Employee

    @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 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
    0 comments No comments