Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Blackline - Roles and products mapping problem

Shilpa_B
New Contributor II
New Contributor II

Hi Team,

We are referring the Blackline Integration guide to configure Blackline app.

https://forums.saviynt.com/t5/community-sourced-integrations/blackline-integration-guide/ta-p/32755

Here, the Roles - products import API is not importing productid and the productId mapping is missing. But productId is required for Add and Remove AccessJSONs'.

Please let us know if anyone has insight on blackline integration.

9 REPLIES 9

SB
Saviynt Employee
Saviynt Employee

Can you share the Import JSON you are using. 


Regards,
Sahil

 

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

SB
Saviynt Employee
Saviynt Employee

The above JSON seems to be correct. I do see there are multiple Entitlement types we are importing. So is the issue only happening with "Roles and Products". And are these getting imported and just missing the required value or are they not getting imported at all.


Regards,
Sahil

Shilpa_B
New Contributor II
New Contributor II

Other entitlements are getting imported. The problem is with Roles and Products import API.

1. AccountEntImport JSON - "Roles and Products"  the url is importing only roles but we need information on productids also

"url": "@@HOST_URL@@/v1/roles",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",                
"entitlement_value": "name~#~char"   
}

2. Add and Remove AccessJSONs' expecting customproperty1 value but for Import role-products, this mapping is missing.

"url": "@@HOST_URL@@/v1/users/${account.accountID}/roles-products",
"httpMethod": "POST",
"httpHeaders": {
"Authorization": "${access_token}",
"Content-Type": "application/json"
},
"httpContentType": "application/json",
"httpParams": "[{\"roleId\": ${entitlementValue.customproperty2},\"productId\": \"${entitlementValue.customproperty1}\"}]",

 

Thanks,

Shilpa

 

SB
Saviynt Employee
Saviynt Employee

are you getting this information in postman? Can you run the call in postman and share the response highlighting the field which display the role-product id value.


Regards,
Sahil

Shilpa_B
New Contributor II
New Contributor II

Below screenshot displays the List all the roles and products assigned to an account. However, we do not have API to import all roles-products from target.

Shilpa_B_0-1687858548684.png

khalidakhter
Saviynt Employee
Saviynt Employee

Hi @Shilpa_B 

You can import the product ID and save it in the UUID property but can be used only in Remove Access JSON only using ${account_entitlements.uuid} binding. Also, I do not think you will be able to achieve the same in the Add Access JSON. Can you try importing product ID using file-based import?

Attaching a sample for storing UUID in acctEntParams:

"Roles and Products": {
        "call": {
          "call1": {
            "callOrder": 0,
            "stageNumber": 0,
            "processingType": "httpAcctToEnt",
            "http": {
              "httpHeaders": {
                "Authorization": "${access_token}"
              },
              "url": "https://SBUS.api.blackline.com/v1/users/${id}/roles-products",
              "httpContentType": "application/json",
              "httpMethod": "GET"
            },
            "listField": "items",
            "entKeyField": "entitlement_value",
            "entIdPath": "role.name",
            "acctKeyField": "accountID",
            "colsToPropsMap": {
              "uuid": "product.id~#~char"
            }
          }
        }
      }

Hi @khalidakhter,

I tried above json for productids for account, but it didn't import productids. The reason could be every role can be associated with one or many products. please refer the below screenshot.

Shilpa_B_1-1687966825394.png

In current system the role products selection and mapping is as below. (Account, Match, Task, Enhanced Reporting are products)

Shilpa_B_2-1687966955811.png

khalidakhter
Saviynt Employee
Saviynt Employee

@Shilpa_B 

In the case mentioned above, It seems difficult to store product IDs during the import/provisioning, and can't be achieved.