Hi
I'm not sure if I'm using httpEnttoAcct correctly in my entitlement to account mapping. I've successfully imported Accounts and Entitlements using this JSON and I now need to pass each Group Name in httpParams to get the list of Group Members (this is how it works in Postman). Would ${id} be the correct way to do it?
So far what I've attempted has not done any mapping and I've not seen any error messages either so please can you take a look and see if there's anything obviously wrong with the JSON.
{
"accountParams":
{
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig":
{
"deleteLinks": true,
"statusColumn": "customproperty2",
"activeStatus": [
"true"] ,
"accountThresholdValue": 200,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": true
},
"call":
{
"call1":
{
"callOrder": 0,
"stageNumber": 0,
"http":
{
"url": "https://****.com/OneStreamApi/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0",
"httpHeaders":
{
"Authorization": "Bearer ${connection.token}",
"Accept": "application/json"
},
"httpParams": "{\"BaseWebServerUrl\": \"https://****.com/OneStreamWeb\",\"ApplicationName\": \"Dev\",\"WorkspaceName\": \"Default\",\"AdapterName\": \"REST_CALL\",\"ResultDataTableName\": \"RestAPIResults\",\"CustomSubstVarsAsCommaSeparatedPairs\": \"Method = Report, ReportName = Userlist\"}",
"httpContentType": "application/json",
"httpMethod": "POST"
},
"listField": "userList",
"keyField": "name",
"colsToPropsMap":
{
"accountID": "uniqueID~#~char",
"customproperty2": "isEnabled~#~bool",
"name": "email~#~char",
"displayname": "name~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"successResponses":
{
"statusCode": [200, 201]
},
"unsuccessResponses":
{
"statusCode": [400, 401, 404, 500]
}
}
}
},
"entitlementParams":
{
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes":
{
"Group":
{
"call":
{
"call1":
{
"callOrder": 0,
"stageNumber": 0,
"http":
{
"url": "https://****.com/OneStreamApi/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0",
"httpHeaders":
{
"Authorization": "Bearer ${connection.token}",
"Accept": "application/json"
},
"httpParams": "{\"BaseWebServerUrl\": \"https://****.com/****Web\",\"ApplicationName\": \"Dev\",\"WorkspaceName\": \"Default\",\"AdapterName\": \"REST_CALL\",\"ResultDataTableName\": \"RestAPIResults\",\"CustomSubstVarsAsCommaSeparatedPairs\": \"Method = Report, ReportName = Group\"}",
"httpContentType": "application/json",
"httpMethod": "POST"
},
"listField": "groupList",
"keyField": "entitlementID",
"colsToPropsMap":
{
"entitlementID": "uniqueID~#~char",
"entitlement_value": "name~#~char",
"description": "description~#~char",
"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"disableDeletedEntitlements": true
}}}}},
"acctEntParams": {
"connection": "acctAuth",
"entTypes": {
"Group": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"url": "https://****.com/****Api/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0",
"httpHeaders":
{
"Authorization": "Bearer ${connection.token}",
"Accept": "application/json"
},
"httpParams": "{\"BaseWebServerUrl\": \"https://****.com/****Web\",\"ApplicationName\": \"Dev\",\"WorkspaceName\": \"Default\",\"AdapterName\": \"REST_CALL\",\"ResultDataTableName\": \"RestAPIResults\",\"CustomSubstVarsAsCommaSeparatedPairs\": \"Method = Report, ReportName = GroupMembership, Groupname = ${id}\"}",
"httpContentType": "application/json",
"httpMethod": "POST"
},
"listField": "groupMembership",
"entKeyField": "entitlementID",
"acctKeyField": "name"
}
}
}
}
}
}
