Display "Created By"- user id and department from user profile in list view using JSLink

Question

I want to display created by field's loginID and department in list view using JSlink in SP 2016. I observed that Author field gives only following fields: email ,id, title and sip .
I can use id and query userprofile using REST, JSOM but again user profiles directly give info only when LogIn_ID(domain\LoginID) is passed. This way its increasing my api calls. What would be the best way to do this? Don't want to use SSOM and workflow.

Answer 1

@Prajakta Patil ,

You can get the author field as below:

Or : /_api/web/lists/GetByTitle('xx')/items?$select=Author/Name,Author/Department&$expand=Author

Best Regards,
Baker Kong

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Finally I decided to use jquery data table as with JSlink export to excel will not export additional columns in excel.