REST Connector Query: ImportAccountEntJSON Template

[Sivagami]

Hi Team,

I have an application where I have API's below:

1) ListGroups

2) ListGroupMembersByGroupID

I don't have a list users calls to pull all the users in the application. I can pull the list of groups and by passing the groupid in the groupmembers url, I can get the group members.

Do we have a ImportAccountEntJSON template for this case?

-Siva

[sagars]

Hello @Sivagami ,

If the accounts list is coming as part of your "ListGroup" call then we can do the users import as well. If not then we do not support to iterate the user import using groupmember API call.

Below is the sample of pulling user details in list group API.

{
"accountParams": {},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Group": {
"entTypeOrder": 0,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "http://abc.com",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "role-id~#~char",
"entitlement_value": "role-name~#~char",
"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"listField": "users",
"idPath": "id",
"keyField": "accountID",
"importAsAccount": true,
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "username~#~char"
}
}
}
}
},
"acctEntParams": {
"processingType": "entToAcctMapping"
}
}
Regards,
Sagar Srikantaiah

[Sivagami]

Thanks much @sagars for the insights. 

In my case, I have one list group call that will provide the list of all groups (groupname, groupid, etc.,) and then the group members call, I need to pass the group id retried from the list group call. Is there a way to achieve the requirement?

I know we could have used ${id} in URL's if I had list users call. But in this case I don't have such API from the target application that gives me the list of all users in the application.

[sagars]

Hello @Sivagami ,

As user coming from get groups call we could have stored in below config . I do not think we can achieve your usecase by using just group member call as we need corresponding user id available for reference. Check with target app admin if they can have better user api calls.

"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char"

Regards,
Sagar Srikantaiah