When extracting data from SharePoint, Matillion only return a users ID (2 digits) which appears to be a user reference connected only to a particular site. What would be the recommended method to also extract user data (name & email address) that is associated with list items?
I have seen reference to Python scripts though wondering if anyone in the community has accomplished this
thanks
Turned out to be an easy solution, performing the advanced setting within the SharePoint connector and using an SQL expression join the relevant list with the Users table in SharePoint. Example attached
Hi @matthew.bates
Glad to learn you were able to resolve that and thanks for sharing how you did it with the wider community!
If you need anything else, please do not hesitate to post!
Kind regards, Joe