USP_DATAFORMTEMPLATE_VIEW_APICONFIGURATIONPAGEDATA

          CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APICONFIGURATIONPAGEDATA
          (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @CONFIGURATIONEXISTS bit = null output
          )
          as
            set nocount on;
            set @DATALOADED = 1

            if exists(select ID from dbo.APISUBSCRIPTIONKEY)
              begin 
                set @CONFIGURATIONEXISTS = 1
              end 
            else 
              begin
                set @CONFIGURATIONEXISTS = 0
              end

            return @CONFIGURATIONEXISTS;