unable to get some fields mapped to Azure

[Balakrishna_ABK]

I am trying to get user's data from Azure 

I am able to get some of the fields but some fields like city, state, company name is not populating in ServiceNow.

Do I need to grant any special permissions from Azure ?

[James Chun]

Hi @Balakrishna_ABK,

In the script, I don't see a part where it updates the 'city', did you remove it before taking the screenshot?

Are you sure the 'companyName' is the correct name of the column? I don't think I have seen this field on the [sys_user] table before.

Try running the script in the background script with a JSON input and if it does work, the issue likely to be access-related but if not, something's wrong with the code.

Cheers

[Balakrishna_ABK]

Hi @James Chun ,thanks for your reply, I am getting response however I am unable to get fetch data into servicenow 

[Sohail Khilji]

Hi @Balakrishna_ABK ,

FYI, Azure may not give you direct infomation like city string, state string you may need to get the whole address and parse the city and state from the address and use it in sys_user table. 

can you please share the json payload which you received from this get call ?

[Balakrishna_ABK]

Hi @Sohail Khilji , thanks for quick reply, below is response