ACCOUNTEXISTSJSON

[frayang]

Hi all,

I am wondering how to use ACCOUNTEXISTSJSON ? Can we reference it in another JSON in the connector? Thanks

-Fran

[rushikeshvartak]

ACCOUNTEXISTSJSON is used to validate before creating new account , if ACCOUNTEXISTSJSON  return true then update Account json gets used else create account json

{"AccountExistQry":"select * from sys.server_principals where name='${accountName}'"}

Documentation - https://docs.saviyntcloud.com/bundle/Database-v24x/page/Content/Configuring-the-Integration-for-Impo...

[NM]

Hi @rushikeshvartak , it checks on target end of on saviynt side only?

[Saathvik]

@NM : It check on target. You are going to put a query to validate against target database

[NM]

@Saathvik So if it finds an account at the time of create account does it error out the task

[frayang]

Hi Rushikesh,

Thanks for the info.

You meant that Saviynt evaluates ACCOUNTEXISTSJSON  in DB connection while executing New Account tasks to provision to DB target, and once it returns true, a DB new account is created in Saviynt as manually provisioned?  Thanks

-Fran

[frayang]

{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '$(user.customproperty27)' "}

this configure threw errors while saving the connection. Any idea on this error?  what is wrong with my configuration? Thanks

-Fran

[rushikeshvartak]

{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '${user.customproperty27}' "}

{} was missing

[frayang]

I still have the same errors after changing to

{

{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '${user.customproperty27}' "}

}

[rushikeshvartak · Accepted solution]

{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '${user.customproperty27}'"}

[frayang]

yeah. That works. Thanks

[NM]

Hi @frayang , if an account exists on application end did the task got errored out .. or account was created in saviynt?