Hi Sahil,
Thanks for the response . It helped us to resolve the "processing query" error. But we are facing another issue now,
An account can have multiple permission Sets assigned to it. But with the above JSON we could see only 1 permission set is getting mapped to the account.
The path for Permission Set in the response Payload for the permission set mapping is x.records[n].PermissionSet.Id, where n is the no of permission Sets assigned to the particular account(1 less than the number, as the index starts from zero).
Please suggest us the necessary changes in the JSON, in order to map all the permission sets.
Please find the attached JSON
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"successResponses": {
"statusCode": [
200
]
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "**********************",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "records",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "AssigneeId~#~char",
"name": "Assignee.Username~#~char",
"displayName": "Assignee.Name~#~char",
"customproperty2": "Assignee.LastName~#~char",
"customproperty1": "Assignee.FirstName~#~char",
"customproperty3": "Assignee.Login_ID__c~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "**********************"
}
}
}
},
"acctEntMappings": {
"Profile": {
"listPath": "",
"idPath": "ProfileId",
"keyField": "entitlementID"
},
"Role": {
"listPath": "",
"idPath": "UserRoleId",
"keyField": "entitlementID"
},
"PermissionSet": {
"listPath": "",
"idPath": "PermissionSet.Id",
"keyField": "entitlementID"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Profile": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "****************",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "records",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"displayName": "Name~#~char",
"description": "description~#~char",
"customproperty2": "UserLicenseId~#~char"
},
"disableDeletedEntitlements": false
}
}
},
"Role": {
"entTypeOrder": 1,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "***************",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "records",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"displayName": "Name~#~char",
"customproperty1": "ParentRoleId~#~char",
"description": "RollupDescription~#~char",
"customproperty3": "DeveloperName~#~char"
},
"disableDeletedEntitlements": false
}
}
},
"PermissionSet": {
"entTypeOrder": 2,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "*********",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "records",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"displayName": "Name~#~char",
"description": "Label~#~char"
},
"disableDeletedEntitlements": false
}
}
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}