Yes. I have been successful in implementing this via the Flow Designer.
Requirements:
- OAuth connectivity to MS Exchange from ServiceNow & a valid token response
- Scope privileges - 'User.ReadWrite.All' (could perhaps get away with just read - go for RW first to be sure/safe)
- Integration Hub license
- Access to the following MS Graph API: https://docs.microsoft.com/en-us/graph/api/profilephoto-get?view=graph-rest-1.0
- Access to AD User Principle Name data from within your instance of SN.
Method:
- Flow Action which includes a REST step:
- Notice how we have check the box 'Save as Attachment'.
- Now look up the sys_attachment record using the REST response (which will be the sys_id of the attachment record):
- Create an attachment record output:
- Now within your Flow apply the sys_id of the attachment record to both the sys_user and Live Profile tables:
So, in summary:
- ServiceNow to MS Graph with the right level of access
- OAuth with valid token
- Flow Integration Hub
- Rest call - gets profile pic as attachment and gives you sys_id
- Look up attachment record
- Apply it to sys_user and live_profile tables
