ImportAccountEntJSON

[adriencosson]

Hello guys,

I've been working more on the Saviynt4Saviynt REST Connector for some improvements, but I would need your help on doing Account to Entitlements Mapping : 

Currently, the attached ImportAccountEntJSON works for importing users as accounts and SAVRoles as entitlements.
I have created two analytics, one for getting all SAV Roles and their data for Entitlement Import (analyticsid = 1470) : 

SELECT ROLEKEY, ROLENAME, ROLEDESCRIPTION, STATUSKEY, UPDATEDATE as 'UPDATE_DATE', UPDATEUSER AS 'UPDATE_USER', READONLY FROM savroles

 and a second one to get SAV Roles attached to users (analyticsid = 1471) : 

SELECT u.userkey, u.username, s.rolekey, s.rolename FROM users u left join user_savroles us on u.userkey=us.userkey left join savroles s on us.rolekey=s.rolekey WHERE us.rolekey is not null

For acctEntParams, I want to use the httpEntToAcct processing type, to retrieve the result from the second Analytics, and passing as parameter the ${id} in the httpParams as following : 

This works fine in Postman, as it will filter the entries per SAVRole key mentioned.

However, when I run the import in Saviynt, even if it throws the following logs showing the ${id} is retrieved, the report gets all results and it looks that httpParams is not taken into account : 

Calling Webservice Url - https://loreal-dev.saviyntcloud.com/ECM/api/v5/fetchControlDetailsES?analyticsid=1471 with httpParams - {"filtercriteria":{"rolekey":["8"]}}"

  Any help on this ? 

[rushikeshvartak]

id is only exposed in URL. you need to try something call1.response.id

[Vedanth_BK · Accepted solution]

Hi @adriencosson ,

Please change the httpMethod to  GETWITHBODY in the acctEntParams.For more information check the REST Connector Guide.

Thank you 
Vedanth B.K

[adriencosson]

Hi @Vedanth_BK ,

This configuration trick resolved my case, many thanks !