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 |
|---|
| None | Not applicable |