WF_APP_GLB_SETTINGS

Stores information about the global and app level access tokens.

Columns

Column Name Definition

ID

Function:
The unique ID for the access token.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

APP_NAME

Function:
The internal name of the global access token or the app associated with the app level access token.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CREATED_BY

Function:
The user who created the access token.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_DATE

Function:
The date the access token was created.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DATA_TYPE

Function:
A string with the literal name of an external system, such as SharePoint, Salesforce, Database, or Active Directory, with which the access token connects.
Values:
  • Yammer
  • Database
  • SharePoint
  • WCF Service
  • Web Service
  • REST Service
  • Salesforce
  • Box
  • OneDrive
  • Twitter
  • Dropbox
  • GoogleDrive
  • MSDynamicsCRM
  • DocuSign
  • NetSuite
  • ActiveDirectory
  • WindowsAzureActiveDirectory
  • ExchangeServer
  • Sertifi
  • BingMaps
  • GoogleMaps
  • SAP
  • AnonymousAccess
  • PayPal
  • AgilePointNX
  • DotNetProxy
  • ZohoCRM
  • Slack
  • Amazon
  • OneDriveForBusiness
  • Twilio
  • SFTP
  • FTP
  • MSOnline
  • AzureIoT
  • PowerBI
  • MicrosoftCognitiveServices
  • AzureMachineLearning
  • Zendesk
  • Bitly
  • WordPress
  • Trello
  • Mongodb
  • Zoom
  • LinkedIn
  • Jira
  • BOTIntegration
  • MicrosoftTeams
  • ODataService
  • UIPath
  • AdobeSign
  • BluePrism
  • EthereumBlockchain
  • ServiceNow
  • OAuth2
  • CDS
  • AutomationAnywhere
  • Snowflake
  • HubSpot
  • Okta
  • GoogleAI
  • GitHub
  • Asana
  • PowerShell
  • MailChimp
  • SendGrid
  • PostgreSQL
  • AzureServiceBus
  • AbbyyVantage
  • Stripe
  • LocalStorage
  • AzureFunction
  • OpenAI
  • ElasticSearch
  • AmazonRedshift
  • Kafka
  • gRPCService
  • Monday
  • Neo4j
  • Mindee
  • NVIDIANIM
  • Agentforce
  • GeminiAI
  • LangGraph
  • N8N
  • CrewAI
  • Memgraph
  • Databricks
  • Anthropic
Data Type:
varchar
Size:
128
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

DESCRIPTION

Function:
A free text description for the access token.
Data Type:
nvarchar
Size:
1023
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ENCRYPTED

Function:
Stores the access token information in the AgilePoint workflow database as encrypted data.
Values:
  • Yes - Encryption is enabled.
  • No - Encryption is disabled.
Data Type:
varchar
Size:
3
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

EXPIRATION_DATE

Function:
The expiration date for the access token.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

EXPIRATION_EMAIL_ADDRESS

Function:
The email address to which the access token expired notification is sent.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

KEY

Function:
A free text unique name of the access token.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_BY

Function:
The user who last updated, or modified, the access token.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_DATE

Function:
The date the access token was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

RENEW_RATE

Function:
The rate at which the access token is renewed.
Values:
  • 0 - Disabled
  • 1 - Every 15 minutes
  • 2 - Every 30 minutes
  • 3 - Every hour
  • 13 - Every 5 minutes
  • 14 - Every 10 minutes
Data Type:
Int
Size:
4
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

RESCHEDULED

Function:
The execution status of the access token.
Values:
  • Yes - The access token is executed.
  • No - The access token is not executed.
Data Type:
varchar
Size:
3
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

VALUE

Function:
Stores the configuration data associated with the access token.
Values:
An encrypted string that represents the access token credentials.
Data Type:
ntext
Size:
Not applicable.
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
NoneNot applicable