Map Accounts information to Entitlement customproperty for REST

[Sachin]

Hello Team,

We have REST based application for which we need Accounts information to be added in Entitlement customproperty 

for Example:

Accounts.customproperty1 has value "abc" we want this value to also be mapped to in entitlement customproperty1 value "abc"

Please suggest how can achieve this in ImportAccountEnt JSON

Thanks 

Sachin

[rushikeshvartak]

Does API provide that information. if yes then you can achieve using JSON

[Sachin]

@rushikeshvartak  Yes both api are storing same value in customproperty4 , can you please suggest actEntMapping for it.

I was trying with below actEntMapping but it is not working.

"acctEntMappings": {
"group": {
"listPath": "",
"entIdPath": "customproperty4",
"entKeyField": "entitlementID",
"acctKeyField" : "accountID",
"acctIdPath" : "customproperty4"
}
}

[stalluri]

Try passing 
"acctIdPath" : "accountID". // what every you pass in the accountParms (acctIdPath)

[Sachin]

@stalluri Thanks, i will try it.

[NM]

Hi @Sachin , can you share your importaccountentjson 

[Sachin]

Hi @NM  Below is the importAccountEnt JSON:
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"includeExistingInActiveAccounts": true,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "url",
"httpHeaders": {
"Authorization": "bearer abcdef",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "data",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "account_id~#~char",
"name": "email~#~char",
"displayName": "name~#~char",
"status": "account_status~#~char",
"accounttype": "account_type~#~char",
"customproperty1": "links.self~#~char",
"customproperty2": "access_billable~#~char",
"customproperty3": "product_access.workspaceAri[0]~#~char",
"customproperty4" : "product_access.siteId[0]~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"offset": {
"offsetParam": "startAt",
"batchParam": "maxResults",
"batchSize": 100,
"totalCountPath": 100000
}
}
}
},
"acctEntMappings": {
"group1": {
"listPath": "",
"entIdPath": "entitlementID",
"entKeyField": "customproperty4",
"acctKeyField" : "customproperty3",
"acctIdPath" : "accountID"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"group1": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "url",
"httpHeaders": {
"Authorization": "Bearer abcde",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "POST"
},
"listField": "data",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "attributes.hostUrl~#~char",
"entitlement_value": "attributes.hostUrl~#~char",
"customproperty1": "attributes.name~#~char",
"customproperty2": "attributes.typeKey~#~char",
"customproperty3": "attributes.hostUrl~#~char",
"customproperty4": "id~#~char"
},
"pagination": {
"offset": {
"offsetParam": "startAt",
"batchParam": "maxResults",
"batchSize": 25,
"totalCountPath": 100
}
}
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"group1": {
"call": {
"call1": {
"processingType": "acctToEntMapping",
"http": {}
}
}
}
}
}
}

[NM]

@Sachin accentmapping format doesn't look right ..check developer handbook for reference.

[rushikeshvartak]

Please share postman screenshot and curl command [Refer https://codingnconcepts.com/postman/how-to-generate-curl-command-from-postman/ ]



⚠️‼️‼️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.‼️‼️⚠️

[stalluri]

@Sachin 
acctEntMappings": {
"group1": {
"listPath": "",
"entIdPath": "entitlementID",
"entKeyField": "",       //Pass the value you are getting from api. example "attributes.hostUrl"
"acctKeyField" : "",   //Pass the value you are getting from api. example "account_id"
"acctIdPath" : "accountID"
}
}