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

Question

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

Answer 1

@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

Answer 2

@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 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