Import Data into ServiceNow

[tindiz]

I want to Import Data into ServiceNow using excel file.

What should I put on the excel file on the vendor field so when I import it into Service Now it will come up as checked?

[Aman Kumar S]

Hi @tindiz 

If you are using import set and transform maps, you can simply create a field map between source and target field and use script in the field map: Assuming you are passing yes and no in the excel

if (source.your_field_name == 'yes') {

answer = true;

else {

answer = false;

}

[tindiz]

So in the excel file I should put it like this -

And then the script should be like this -

if (source.vendor == 'yes') {

answer = true;

else {

answer = false;

}

[Dr Atul G- LNG · Accepted solution]

Put True as the value in the Vendor column in the excel sheet.

https://youtu.be/otIhgOrwvKE