Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Validthrough account attribute not getting populated when importing accounts from servicenow

PiyushRai
New Contributor
New Contributor

Validthrough attribute is not getting populated due to date format issue, when we tried to populate it in a customproperty we see the expected results.

The importent json is :

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty10",
"activeStatus": [
"true"
],
"deleteLinks": false,
"accountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"lockedStatusColumn": "customproperty15",
"lockedStatusMapping": {
"Locked": [
"true"
],
"Unlocked": [
"false"
]
}
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xyz.com",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpMethod": "GET"
},
"listField": "Resources",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "id~#~char",
"status": "active~#~char",
"name": "userName~#~char",
"displayname": "displayName~#~char",
"validthrough": "urn:ietf:params:scim:schemas:extension:servicenow:custom:2~dot#0:User.endDate~#~date",
"customproperty15": "urn:ietf:params:scim:schemas:extension:servicenow:custom:2~dot#0:User.lockedOut~#~char",
"customproperty2": "name.givenName~#~char",
"customproperty3": "name.familyName~#~char",
"customproperty4": "emails[0].value~#~char",
"customproperty5": "urn:ietf:params:scim:schemas:extension:servicenow:2~dot#0:User.manager.displayName~#~char",
"customproperty7": "urn:ietf:params:scim:schemas:extension:servicenow:2~dot#0:User.location.name~#~char",
"customproperty10": "active~#~char"
},
"pagination": {
"offset": {
"offsetParam": "startIndex",
"batchParam": "count",
"batchSize": 10,
"totalCountPath": "completeResponseMap.totalResults"
}
}
}
}
}
}

 

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

What is date format from. Api? Try setting global setting of dateformat in json in saviynt


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi @rushikeshvartak,

the date format is "endDate""1970-01-01T00:00:00Z" and we have tried setting a global setting for a dateformat but it didn't work.

 {
"globalSettings": {
"dateFormat": "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"
},