Hi,
We have a procedure of changing the name of ServiceNow accounts from lets say abc.efg@company.com to ToArchive.abc.efg@company.com in a use case. But, after an account import, there is another duplicate account getting created with the new ToArchive name, although it has the same accountid. Need ideas to get the ToArchive account mapped to the correct account during import.
The ImportAccountEntJSON is
{
"showLogs": true,
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"successResponses": {
"statusCode": [
200,
201
]
},
"unsuccessResponses": {
"statusCode": [
400,
401,
404,
405,
500
]
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://domain.service-now.com/api/now/table/sys_user?sysparm_limit=100",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "result",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"acctLabels": {
"customproperty1": "PersonnelNumber"
},
"colsToPropsMap": {
"accountID": "sys_id~#~char",
"name": "email~#~char",
"CUSTOMPROPERTY7": "user_name~#~char",
"CUSTOMPROPERTY2": "last_name~#~char",
"customproperty3": "name~#~char",
"CUSTOMPROPERTY4": "first_name~#~char",
"status": "active~#~char",
"CUSTOMPROPERTY5": "u_employee_legacy_number~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.split(';')?.size()==5?headers?.Link?.split(';')[2]?.replace('rel=\"prev\",<', '')?.replace('>','')?.trim():headers?.Link?.split(';')?.size()==4 && headers?.Link?.split(';')[2].contains('rel=\"next\",<')?headers?.Link?.split(';')[1]?.replace('rel=\"first\",<', '')?.replace('>','')?.trim():null}"
}
}
}
}
},
"entitlementParams": {},
"acctEntParams": {}
}
[This post has been edited by a Moderator to remove sensitive information.]
