I have been using the JIRA Api to extract data and make a PowerBI report for our manager, when looking at the values and metrics they dont match the jira native report as the assignee field has a different value on the api return and the ticket management software.
I tried using the excel add-on to double check on this and the Excel one is accurate, so i took the field name from Excel(Assignee.displayName) and it keeps returning a different value on the API.
What i have noticed is that its returning the name of the person who last opened the ticket as assignee, and not the assigned person indicated in the platform.
