USP_FENXT_GET_KEYS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ENVIRONMENTID	nvarchar(50)	INOUT
@FEDESIGNATIONSOURCE	bit	INOUT
@REFRESHTOKEN	nvarchar(50)	INOUT

Definition

Copy



            create procedure dbo.USP_FENXT_GET_KEYS
            (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @ENVIRONMENTID nvarchar(50) = null output,
            @FEDESIGNATIONSOURCE bit = null output,
            @REFRESHTOKEN nvarchar(50) = null output
            )
            as
            set nocount on;

                exec dbo.USP_GET_KEY_ACCESS;
                set @DATALOADED = 1;

                select
                    @ENVIRONMENTID = FENXTTOKEN.ENVIRONMENTID,
                    @FEDESIGNATIONSOURCE = FENXTINTEGRATION.FEDESIGNATIONSOURCE,
                    @REFRESHTOKEN = coalesce(convert(nvarchar(256), DecryptByKey(FENXTTOKEN.REFRESHTOKEN)),'')
                from dbo.FENXTINTEGRATION inner join dbo.FENXTTOKEN on FENXTINTEGRATION.ENVIRONMENTID = FENXTTOKEN.ENVIRONMENTID
                where FENXTINTEGRATION.PDACCOUNTSYSTEMID = @ID;

                close symmetric key sym_BBInfinity;
            return 0;