Workato docs Return to Workato

SQL Server

  • Introduction
  • Product notifications
  • Concepts
  • Connecting apps
  • Building recipes
    • Triggers
      • Polling triggers
      • Real-time triggers
      • Scheduled triggers
      • Single triggers
      • Batch triggers
      • Since/from
      • Trigger conditions
    • Steps
      • Action step
      • Conditional step
      • Repeat step
      • Call recipe step
      • Stop step
      • Action with error handler step
    • Actions
      • Create action
      • Update action
      • Search action
      • Get action
      • Upsert action
      • Delete action
    • IF conditions
    • Data pills and mapping
      • Data types
      • Type conversion
      • Preview data
      • Fields mapping
      • Group data mapping
      • Data transformation
    • Recipe building best practices
    • Error handling best practices
    • Version management
  • Running recipes
    • Test, start and stop recipe
      • Test mode
      • Start recipe
      • Stop recipe
    • Jobs
      • Jobs report
      • Custom jobs report
      • Job status
      • Job details screen
      • Rerun jobs
    • Tasks
    • Rerun job
      • Cached trigger data
      • Job rerun history
      • Common scenarios for rerunning jobs
    • RecipeOps
      • Connection setup
      • New failed job trigger
      • Recipe stopped by Workato trigger
      • Get account details action
      • Get recipe details action
      • List jobs created by recipe action
      • List recipes action
      • Start recipe action
      • Stop recipe action
  • Troubleshooting
    • Error notification emails
    • Recipe design errors
      • Missing required fields
      • Formula errors
      • Invalid datapills
      • App connection errors
    • Recipe logic errors
      • Inaccurate step indentations
      • Inaccurate list management
      • Infinite looping
      • Unexpected trigger events
      • Missing trigger events
    • Job errors
      • Trigger errors
      • Formula errors
      • Missing required fields
      • Timeouts
      • Non-matching datatypes
      • 401 unauthorized
      • 403 forbidden
      • 404 not found
      • 422 unprocessable entity
      • 500 internal server error
    • Formula errors
    • Infinite loops
    • Deduplication
    • Rate limiting
  • Data types and formulas
    • Formula mode
      • Filter formulas by data type
      • Formula hints and syntax
      • Text mode VS formula mode
      • Ternary condition
    • String formulas
    • Number formulas
    • Date formulas
    • List formulas
    • Other formulas
    • Complex data types
  • Tools
  • Files and attachments
    • Read files
    • CSV contents
    • JSON contents
    • XML contents
    • Move files between apps
    • File streaming
    • Compress files
    • Encrypt & decrypt files
  • Batch processing
    • Batch triggers
    • Batch actions
    • Maximize data throughput
  • Teams and collaboration
    • Role-based access
    • Audit logs
    • Okta SSO
    • OneLogin SSO
    • Workato SSO settings
    • Logging into SAML-enabled team
    • SAML Just-In-Time provisioning
  • People Task by Workato
    • Administrators
      • Customize subdomain
      • Invite participants
    • Example recipe
    • Participants
      • Approver view
      • Approving tasks
  • Recipe development lifecycle
    • Packages
      • Exporting packages
      • Importing packages
      • Packages import behaviour
  • On-premises connectivity
    • Setup agent
    • Run agent
    • Upgrade agent
    • Profiles
    • On-premises connections
    • Password encryption
    • Proxy server
    • Extensions
  • Key features
    • Scheduler
    • Secondary connectors
    • Lookup tables
      • Setup
      • Add entry action
      • Lookup entry action
      • Search entry action
      • Lookup table formulas
      • Table limits
    • Message template
      • Variables
      • Sections
      • Comments
      • Partials
      • Using templates in recipes
    • Callable recipes
    • Account properties
    • Utility
    • Data masking
    • Single Sign-On (SSO)
    • List management
      • Example list setup
      • Use datapills from list without repeat step
      • Use datapills from list in input list
      • Use datapills from list with repeat step
      • Fixed & Dynamic lists
      • Common repeat step mistakes
      • List connector
    • Data retention
    • Job history replication
    • Common data model
    • API management
      • API tokens
      • API endpoints
  • Workbot for Slack
    • Slack vs Workbot
    • Workbot for Slack setup
    • Using Workbot for Slack
    • Workbot triggers
      • New message action
      • New command
      • New URL mention
    • Workbot actions
      • Post command reply
      • Post message
      • Post notifications
    • Workbot basics
      • Workbot basics: Commands
      • Workbot basics: Command reply
    • Workbot advanced topics
      • Using Dialogs with Workbot
      • Updating messages
      • Workbot message menus
      • Workbot buttons
      • Workbot personal connections
      • Workbot troubleshooting
      • Workbot slash commands
        • Configuring slash commands
        • Legacy slash commands
      • Custom Workbots
        • Custom Workbot vs Legacy slash commands
  • Workbot for MS Teams
    • Using Workbot for MS Teams
    • Workbot triggers
    • Workbot actions
    • Workbot buttons task modules & pick lists
  • API Management
    • API Collections and Endpoint Management
    • API Access Policies
    • Managing API Clients and Access Profiles
      • Access Tokens
    • Calling APIs
    • Security Best Practices for APIs
  • Connectors
    • Active Directory
      • Connection setup
      • Search entries
      • Add entry
      • Update entry
      • New entry trigger
      • New/updated entry trigger
      • Scheduled entry search trigger
    • ADP Workforce Now
      • Connection setup
      • Scheduled worker search
    • Analytics Cloud (Wave Analytics)
    • Amazon S3
      • Connection setup
    • AWS Lambda
      • Output schema definition
      • JSON output definition
      • Primitive output definition
    • Box
      • Connection setup
      • New file trigger
      • New CSV file trigger
      • Search files action
      • Download file action
      • Upload file action
    • DocuSign
      • Connection setup
    • Dropbox
      • Connection setup
      • New/updated file trigger
      • New/updated CSV trigger
      • Search files action
      • Upload file contents action
    • Freshdesk
      • Connection setup
    • Google Drive
      • Connection setup
      • New file or folder trigger
      • Create folder action
      • Download file action
      • Rename/move file or folder action
      • Search files or folders action
      • Upload file action
    • Google Sheets
      • Connection setup
      • New row trigger
      • New/updated row trigger
      • Add row action
      • Add rows in bulk action
      • Search rows action
      • Update row action
      • Search rows using query action
      • Update row using row ID action
    • Google Speech-to-Text
      • Connection setup
      • Convert short speech to text action
    • Google Text-to-Speech
      • Connection setup
      • Convert text to speech action
    • Google Translate
      • Connection setup
      • Translate text action
    • Google Vision
      • Connection setup
      • Read text from image
    • HTTP
    • JDBC
      • Connection setup
      • Select actions
      • Insert actions
      • Update actions
      • Delete actions
      • Run custom SQL action
      • New row trigger
      • Scheduled query trigger
    • Jira
      • Connection setup
      • Create issue action
      • Get issue action
      • Search issues action
      • Update issue action
      • Search assignable user action
      • Assign user to issue action
      • Download attachment action
      • Upload attachment action
      • Create comment action
      • Get issue comments action
      • Update comment action
      • Create user action
      • Get user details action
      • Using Jira real-time triggers
      • New/updated issue (real-time) trigger
      • New issue trigger
      • Updated issue trigger
      • New project trigger
      • New/updated comment (real-time) trigger
      • New/updated worklog (real-time) trigger
    • Java messaging service
      • Connection setup
      • New message trigger
      • Publish message action
    • Mapper by Workato
      • Connection setup
      • Map to object action
    • Microsoft Dynamics CRM
      • Cloud connection setup
      • On-premise connection setup
      • Cached picklist lookups
    • MySQL
      • Connection setup
      • Select actions
      • Insert actions
      • Update actions
      • Upsert actions
      • Delete actions
      • Run custom SQL action
      • New row trigger
      • New/updated row trigger
      • Scheduled query trigger
    • NetSuite
      • Connection setup
      • Classification record trigger
      • New record trigger
      • New/updated record trigger
      • New records batch trigger
      • New/updated records batch trigger
      • New saved search trigger
      • New/updated saved search trigger
      • Create record action
      • Create records in bulk action
      • Search standard records action
      • Search custom records action
      • Update record action
      • Update records in bulk action
      • Upsert records in bulk action
    • On-prem command-line scripts
      • Setup and connection
      • Execute command-line script action
    • On-prem files
      • Connection setup
      • New file trigger
      • New CSV file trigger
      • New CSV line trigger
      • New CSV lines trigger
      • Upload file action
      • Download file action
      • Move file action
      • Rename file action
      • List files in folder action
      • Append CSV line action
    • Oracle
      • Introduction
      • New row trigger
      • New/updated row trigger
      • Select actions
      • Insert actions
      • Update actions
      • Upsert actions
      • Delete actions
      • Run custom SQL action
      • Execute stored procedure
      • Best Practices
      • Use cases
      • Troubleshooting
    • Oracle EBS
      • Connection setup
    • Outlook
      • Connection setup
      • New email trigger
    • People Task by Workato
      • Admin setup
      • Recipe configuration
      • Task approvals
    • PostgreSQL
      • Connection setup
      • Select actions
      • Insert actions
      • Update actions
      • Delete actions
      • Run custom SQL action
      • New row trigger
      • New/updated row trigger
    • PubSub by Workato
      • Connection setup
      • Topics management
      • New message trigger
      • Publish message action
    • Quick Base
      • Connection setup
      • Bulk import from CSV action
    • QuickBooks Online
      • Connection setup
    • RecipeOps by Workato
      • Connection setup
      • New failed job trigger
      • Recipe stopped by Workato trigger
      • Get account details action
      • Get recipe details action
      • List jobs created by recipe action
      • List recipes action
      • Start recipe action
      • Stop recipe action
    • Redshift
      • Connection setup
      • Select actions
      • Insert actions
      • Update actions
      • Upsert actions
      • Delete actions
      • New row trigger
      • New/updated row trigger
    • SAP
      • Connection setup
      • New IDoc trigger
      • Send IDoc action
      • Check IDoc status action
      • Run RFC action
    • SharePoint
      • Connection setup
    • Salesforce
      • Connection setup
      • Real-time trigger setup
      • Object triggers
      • Handling attachments
      • Using SOQL
      • Bulk data imports
      • Batch create/update
    • ServiceNow
      • Connection setup
      • New record trigger
      • New/updated record trigger
      • Search records action
      • Create record actions
      • Update record actions
    • Slack
      • Triggers
        • New event trigger (real-time)
        • Button click (real-time)
      • Actions
        • Post message actions
        • Respond to button click actions
        • Invite user to channel actions
        • Invite user to group actions
        • Archive channel actions
        • Unarchive channel actions
        • Create channel actions
        • Set channel purpose actions
        • Set channel topic actions
      • Slack vs Workbot
      • Message buttons
      • Message threads
      • Custom OAuth profiles
    • Snowflake
      • Connection setup
      • Select actions
      • Insert actions
      • Update actions
      • Delete actions
      • Run custom SQL action
      • Bulk load from Amazon S3
      • New row trigger
      • New/updated row trigger
    • Splunk
    • SQL Server
      • Introduction
      • New row trigger
      • New/updated row trigger
      • Select actions
      • Insert actions
      • Update actions
      • Upsert actions
      • Delete actions
      • Run custom SQL action
      • Execute stored procedure
      • Best Practices
      • Use cases
      • Troubleshooting
    • SurveyMonkey
    • Workday
      • Connection setup
      • Get report
      • Scheduled report
      • Call operation
      • Report-as-a-Service
  • Developing connectors
    • Custom actions
    • HTTP vs SDK
    • HTTP connector V2
      • Connection setup
      • Example: Eventbrite OAuth2 connection
      • Webhook triggers
      • Example: New Eventbrite order
      • HTTP actions
    • HTTP connector V1 (deprecated)
      • OAuth2 connection setup (deprecated)
      • Example: Eventbrite OAuth2
      • Non-OAuth2 connection setup (deprecated)
      • Example: Jira basic auth
      • Webhook triggers
      • Example: New Eventbrite order
      • HTTP actions (deprecated)
      • Example: Get Eventbrite order
      • Example: Create Jira project
  • Connector SDK
    • Walk through
    • Authentication
      • Basic auth
      • OAuth 2.0
      • Custom auth
      • Test
    • Object definition
    • Toggle field
    • HTTP request
    • Error handling
    • Action
    • Trigger
      • Poll trigger
      • Dynamic webhook trigger
      • Static webhook trigger
    • Data format
      • JSON
      • XML
      • Form URL Encoded
      • Multipart Form
    • Methods
    • Reusable methods
    • Pick lists
    • Dependent pick lists
    • Configuration fields
    • Secure connection
    • Examples
  • Custom OAuth profiles
    • Slack & Workbot for Slack
  • Workato API
    • Adapter API
    • Connections API
    • Jobs API
    • Managed Users API
    • Recipes API
    • Users
  • Security
    • IP whitelists
  • Product Updates
  • Contact us

SQL Server

SQL Server documentation contains the following chapters:

  • Introduction
  • New row trigger
  • New/updated row trigger
  • Select actions
  • Insert actions
  • Upsert actions
  • Delete actions
  • Run custom SQL action
  • Execute stored procedure
  • Best practices
  • Use cases
  • Troubleshooting

results matching ""

    No results matching ""

    Didn’t find what you are looking for?
    Search our resource library View getting started guides, tutorials, training videos, webinars and FAQ Ask our community View questions and answers from other users and Workato experts. File a support ticket File a support ticket for critical issues that require a higher level of support.
    Privacy Terms (844) 469-6752 Workato 2017