multiple calls in ImportAccountEntJSON

[sandeepgudipudi]

Hi i have requirement to import accounts from multiple calls

i have 2 api's

https://workbench.expel.io/api/v2/user_account_roles

https://workbench.expel.io/api/v2/user_account_roles/01185e4f4976b095b7f7/user_account

when i call the api it fetches the id with the roles that is associated with user_accounts, ie., id=combination of [roles+user_accounts]

1st call : https://workbench.expel.io/api/v2/user_account_roles

"data": [

        {

            "type": "user_account_roles",

            "id": "01185e4f4976b095b7f7",

            "attributes": {

                "role": "organization_admin",

                "created_at": "2024-07-08T05:38:32.825Z",

                "updated_at": "2024-07-08T05:38:32.825Z",

                "assignable": true,

                "active": true

            },

the above id is passed  in below api call to fetch user_accounts, here the id in response for user_accounts and id from above response are different

2nd call: https://workbench.expel.io/api/v2/user_account_roles/01185e4f4976b095b7f7/user_account

"data": [

        {

            "type": "user_accounts",

            "id": "7364d30b-94616c72",

            "attributes": {

                "display_name": "hello User",

                "email": "hellouser@abc.com",

                "first_name": "Hello",

                "last_name": "user",

                "locale": "en_US",

                "timezone": "UTC",

                "language": "en-us",

                "active": null,

                "created_at": "2024-05-18T06:09:54.077Z",

                "updated_at": "2024-05-18T06:12:24.724Z",

                "assignable": false,

                "invite_token_expires_at": null,

                "active_status": "LOCKED",

                "password_reset_token_expires_at": null,

                "homepage_preferences": {},

                "phone_number": null,

                "engagement_manager": false,

                "pagerduty_id": null,

                "default_filter": "ALL",

                "sfdc_id": "xxxxxxxxxxxxx",

                "show_highlighting": true,

                "show_new_nav": true,

                "notifications_enabled": true

            },

i looking for a solution for accountent imports

 1. Accounts should import from 2nd call only 

2. It should fetch the role name from first call entitlementparms that should be requestable

3. it should map the accounts and roles in accentparms

this is the json

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://workbench.expel.io/api/v2/user_account_roles",
"httpHeaders": {
"Authorization": "Bearer XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "data",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "id~#~char"
},
"disableDeletedAccounts": true
},
"call2": {
"callOrder": 1,
"stageNumber": 3,
"http": {
"url": "https://workbench.expel.io/api/v2/user_account_roles/${id}/user_account",
"httpHeaders": {
"Authorization": "Bearer XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
"Accept": "*/*"
},
"httpContentType": "application/vnd.api+json",
"httpMethod": "GET"
},
"inputParams": {
"dependentCall": true
},
"listField": "data",
"keyField": "accountID",
"nextApiKeyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "attributes.display_name~#~char",
"status": "attributes.active~#~char",
"accounttype": "type~#~char",
"customproperty1": "attributes.first_name~#~char",
"customproperty2": "attributes.last_name~#~char",
"customproperty3": "attributes.active~#~char",
"customproperty4": "attributes.last_active~#~char",
"customproperty5": "attributes.email~#~char",
"customproperty6": "attributes.active_status~#~char"
},
"pagination": {
"offset": {
"offsetParam": "page[offset]",
"batchParam": "page[limit]",
"batchSize": 28,
"currentOffset": 0,
"totalCountPath": "28"
}
}
}
}
},
"entitlementParams": {
"showResponse": true,
"processingType": "SequentialAndIterative",
"entTypes": {
"Roles": {
"entTypeOrder": 0,
"entTypeLabels": {},
"call": {
"call1": {
"connection": "acctAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "Bearer XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
},
"url": "https://workbench.expel.io/api/v2/user_account_roles",
"httpContentType": "application/json",
"httpMethod": "GET",
"successResponses": {
"statusCode": [
200,
204
]
}
},
"statusConfig": {
"active": "ACTIVE",
"inactive": "INACTIVE"
},
"listField": "data",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "attributes.role~#~char",
"description": "attributes.role~#~char",
"entitlement_value": "attributes.role~#~char"
}
}
}
}
}
},
"acctEntParams": {
"showResponse": true,
"entTypes": {
"Roles": {
"call": {
"call1": {
"connection": "acctAuth",
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"httpHeaders": {
"Authorization": "Bearer XXXXXXXXXXXXXXXXXXXXXXXXXXXXXx"
},
"url": "https://workbench.expel.io/api/v2/user_account_roles/${id}/user_account",
"httpContentType": "application/json",
"httpMethod": "GET",
"successResponses": {
"statusCode": [
200,
204
]
}
},
"statusConfig": {
"active": "ACTIVE",
"inactive": "INACTIVE"
},
"listField": "data",
"entKeyField": "entitlementID",
"acctIdPath": "id",
"acctKeyField": "accountID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"description": "attributes.role~#~char",
"entitlement_value": "attributes.role~#~char"
},
"pagination": {
"offset": {
"offsetParam": "page[offset]",
"batchParam": "page[limit]",
"batchSize": 28,
"currentOffset": 0,
"totalCountPath": "28"
}
}
}
}
}
}
}
}

Can you also help with the json to revoke access,create account and disable account json