Hi Team
I am trying to import accounts and entitlements for Oracle fusion application using multi call import for REST connector. I am using below json for the import.
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://AAAA/hcmRestApi/scim/Users?startIndex=1&count=500 ",
"httpContentType": "application/json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}"
}
},
"listField": "Resources",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"name": "userName~#~char",
"accountID": "id~#~char",
"displayname": "displayName~#~char",
"customproperty1": "name.givenName~#~char",
"customproperty2": "name.familyName~#~char",
"customproperty3": "emails.value~#~char",
"customproperty11": "active~#~bool",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char",
"status": "active~#~char",
"created_on": "meta.created~#~date",
"updatedate": "meta.lastModified~#~date"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response.completeResponseMap.itemsPerPage<500?null:'https://AAAAA/hcmRestApi/scim/Users?startIndex='+Math.addExact(response.completeResponseMap.itemsPerPage,response.completeResponseMap.startIndex)+'&count='+response.completeResponseMap.itemsPerPage }"
}
}
},
"call2": {
"callOrder": 1,
"stageNumber": 3,
"http": {
"url": "https://AAAAA/hcmRestApi/resources/xx.xx.xx.xx/userAccounts/${account.accountID }",
"httpContentType": "application/vnd.oracle.adf.resourceitem+json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}"
}
},
"inputParams": {
"dependentCall": true
},
"listField": "items",
"keyField": "accountID",
"nextApiKeyField": "accountID",
"colsToPropsMap": {
"accountID": "GUID~#~char",
"name": "Username~#~char",
"customproperty4": "PersonId~#~char"
}
},
"call3": {
"callOrder": 2,
"stageNumber": 6,
"http": {
"url": "https://AAAAA/hcmRestApi/resources/xx.xx.xx.xx/emps?q=PersonId=${account.customproperty4 }",
"httpContentType": "application/vnd.oracle.adf.resourceitem+json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}"
}
},
"inputParams": {
"dependentCall": true
},
"listField": "items",
"keyField": "customproperty4",
"nextApiKeyField": "customproperty4",
"colsToPropsMap": {
"name": "UserName~#~char",
"customproperty4": "PersonId~#~char",
"customproperty6": "#CONST#${response['links'][0].href.substring(response['links'][0].href.indexOf('emps') + 5)}~#~char"
}
}
},
"acctEntMappings": {
"Roles": {
"listPath": "roles",
"idPath": "id",
"keyField": "entitlementID"
}
}
},
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"Roles": {
"entTypeOrder": 0,
"call": {
"call1": {
"connection": "acctAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://AAAAA/hcmRestApi/scim/Roles?startIndex=1&count=500 ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "Resources",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"displayName": "displayName~#~char",
"customproperty1": "id~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response.completeResponseMap.itemsPerPage<500?null:'https://AAAAA/hcmRestApi/scim/Roles?startIndex='+Math.addExact(response.completeResponseMap.itemsPerPage,response.completeResponseMap.startIndex)+'&count='+response.completeResponseMap.itemsPerPage }"
}
},
"disableDeletedEntitlements": true
}
}
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}
The accounts were imported from the 1st call but the other 2 calls are not able to import any other information on the accounts.
When I tried the import for one user using hardcoded values it created 3 accounts for that user, none of them had accountID.
Let me know if I am missing anything in the import json.
Thanks,
Bhushan
[This message has been edited by moderator to mask sensitive information]
