• Get started
        • Get support
        • Support cases
        • App Builder support
        • Harmony organization ID
        • Jitterbit version
        • Region
      • BMC support
        • Get training
          • Introduction to Jitterbit iPaaS
          • Introduction to Jitterbit Integration Studio
          • Introduction to scripting in Integration Studio
          • Advanced transformation mappings in Integration Studio
          • API creation and management
          • Introduction to Design Studio
          • Introduction to scripting in Design Studio
          • Advanced transformation mappings in Design Studio
          • API creation and management
          • Connecting to Salesforce
          • Introduction to App Builder 4
          • Introduction to Vinyl 3.3
          • EDI XPath mapping
          • Jitterbit organizational administration
          • Jitterbit plugin creation
          • Jitterbit process template creation
          • Message queue
        • Overview
        • API proxy
        • APIs
        • Integration Studio
        • Complex orchestration best practices
        • Connector Builder
        • Environments
        • Error handling
        • External credentials storage and management
        • Jitterbit best practices
        • Logging best practices
        • Open API Portal Manager
        • Pass-through sources and global variables best practices
        • Private agents best practices
        • Process templates
        • Project organization best practices
        • Tips & tricks Harmony best practices
        • Overview
        • Virtual meetup 1
        • Virtual meetup 2
        • Virtual meetup 3
        • Virtual meetup 6
        • Virtual meetup 7
        • Virtual meetup 8
        • Virtual meetup 9
        • Virtual meetup 11
        • Virtual meetup 12
        • Virtual meetup 13
        • Virtual meetup 14
        • Virtual meetup 15
        • Virtual meetup 16
        • Virtual meetup 17
        • Integrate Conference 1
        • Integrate Conference 2
        • Integrate Conference 3
      • Microlearning tutorials
      • Process template tutorials
      • Overview
      • Downloads
      • AskJB AI
      • Overview
        • Overview
        • Logical security and architecture
        • Physical security
        • Organizational security
      • Security features
        • Apache Log4j2 JNDI vulnerability mitigation
        • TLS version compatibility
        • DROWN notice
      • Password controls
      • Harmony permissions and access
        • Overview
        • Configure
        • Identity providers
        • Allowlist information
        • APAC IP changes FAQ
      • ISO 27001, ISO 27017, and ISO 27018 certification
      • Security best practices
        • Overview
        • Fall 2025
        • Summer 2025
        • Spring 2025
        • Winter 2025
        • Fall 2024
        • Production Cloud Agent Group
        • Sandbox Cloud Agent Group
        • Private agent
      • App Builder
      • 11.49
      • 11.48
      • 11.47
      • 11.46
      • 11.45
      • 11.44
      • 11.43
      • 11.42
      • 11.41
      • 11.40
      • 11.39
      • 11.38
      • 11.37
      • 11.34
      • 11.33
      • 11.32
          • Overview
          • Summer 2024
          • Spring 2024
          • Winter 2024
          • Fall 2023
          • Summer 2023
          • Spring 2023
          • Winter 2023
          • Fall 2022
          • Summer 2022
          • Spring 2022
          • Winter 2022
          • Fall 2021
          • Summer 2021
          • Spring 2021
          • Winter 2021
          • Fall 2020
          • Summer 2020
          • Spring 2020
          • Winter 2020
          • Fall 2019
          • Summer 2019
          • Spring 2019
          • Winter 2019
          • Fall 2018
          • Summer 2018
          • Summer 2017
          • Winter 2017
          • Summer 2016
          • Production Cloud Agent Group
          • Sandbox Cloud Agent Group
          • Private agent
          • 11.31
          • 11.30
          • 11.29
          • 11.28
          • 11.27
          • 11.26
          • 10.87 / 11.25
          • 10.86 / 11.24
          • 10.85 / 11.23
          • 10.84 / 11.22
          • 10.83 / 11.21
          • 10.82 / 11.20
          • 10.80 / 11.18
          • 10.79 / 11.17
          • 10.78 / 11.16
          • 10.77 / 11.15
          • 10.76 / 11.14
          • 10.75 / 11.13
          • 10.74 / 11.12
          • 10.73 / 11.11
          • 10.72 / 11.10
          • 10.71 / 11.9
          • 10.70 / 11.8
          • 10.69 / 11.7
          • 10.68 / 11.6
          • 10.67 / 11.5
          • 10.66 / 11.4
          • 10.65 / 11.3
          • 10.64 / 11.2
          • 10.63 / 11.1
          • 10.62 / 11.0
          • 10.61
          • 10.60
          • 10.59
          • 10.58
          • 10.57
          • 10.56
          • 10.55
          • 10.54
          • 10.53
          • 10.52
          • 10.51
          • 10.50
          • 10.49
          • 10.48
          • 10.47
          • 10.46
          • 10.45
          • 10.44
          • 10.43
          • 10.42
          • 10.41
          • 10.40
          • 10.39
          • 10.38
          • 10.37
          • 10.36
          • 10.35
          • 10.34
          • 10.33
          • 10.32
          • 10.31
          • 10.30
          • 10.29
          • 10.28
          • 10.27
          • 10.26
          • 10.25
          • 10.24
          • 10.23
          • 10.22
          • 10.21
          • 10.20
          • 10.19
          • 10.18
          • 10.17
          • 10.16
          • 10.15
          • 10.14
          • 10.13
          • 10.12
          • 10.11
          • 10.10
          • 10.9
          • 10.8
          • 10.7
          • 10.6
          • 10.5
          • 10.4
          • 10.3
          • 10.2
          • 10.1
          • 10.0
          • 9.9
          • 9.8
          • 9.7
          • 9.6
          • 9.5
          • 9.4
          • 9.3
          • 9.2
          • 9.1
          • 9.0
          • 8.30
          • 8.29
          • 8.28
          • 8.27
          • 8.26
          • 8.25
          • 8.24
          • 8.23
          • 8.22
          • 8.21.0
          • 8.20.0
          • 8.19.0
          • 8.18.10
          • 8.18.0
          • 8.17.0
          • 8.16.0
          • 8.15.0
          • 8.14.0
          • 8.12.0
          • 8.11.0
          • 8.10.0
          • 8.9.0
          • 8.8.1
          • 8.8.0
          • 8.7.1
          • 8.7.0
          • 8.6.1
          • 8.6.0
          • 5.6.6
          • 5.6.5
          • 5.6.4
          • 5.6.3
          • 5.6.2
          • 5.6.1
          • 5.6.0
          • 5.5.3
          • 5.5.2
          • 5.5.1
          • 5.5.0
      • Overview
      • 11.41
      • 11.38
      • 11.32
      • 11.26
      • 10.86
        • 10.80
        • 10.72
        • 10.70
        • 10.54
        • 10.47
        • 10.45
        • 10.43
        • 10.41
        • 10.39
        • 10.37
        • 10.35
        • 10.33
        • 10.31
        • 10.29
        • 10.27
        • 10.25
        • 10.23
        • 10.21
        • 10.20
        • 10.17
        • 10.15
        • 10.14
        • 8.13 - 8.16.13
        • 8.7.4
        • 8.6.2
        • 8.4.4
    • Wevo iPaaS
    • Release schedule
    • Known issues
    • End-of-life policy
    • System status notifications
        • Overview
        • Glossary
        • Quick start guide
          • Database to text
          • Database to complex XML
          • XML to database
          • SOAP web service
          • RESTful web service
          • Create a schedule
          • Create an email notification
        • Frequently asked questions
        • Permissions, collaboration, and saving
        • Jitterbit iPaaS best practices
        • Integration project methodology
          • Projects page
          • Project toolbar
            • Overview
            • Workflows tab
            • Components tab
            • Resources tab
          • Design canvas
          • Design component palette
          • Script editor
        • Global Endpoints
        • Connector Builder
        • Configuration screens
          • Create and configure
          • Deploy
          • Transfer (Migrate)
          • Export and import
          • Project history
          • Overview
          • View dependencies, delete, and remove
          • Reuse
          • Validity
          • Custom groups
          • Create and design
          • Deploy
          • View dependencies and delete
          • Validity
          • Create and configure
            • Overview
            • Operation schedules
            • Operation actions
            • Operation options
          • Deploy and execute
          • Publish as an API
          • Logs
          • View dependencies, delete, and remove
          • Reuse
          • Patterns and validity
          • Overview
          • Basics
          • REST considerations
          • Storage considerations
          • 3LO authentication
              • Overview
              • Connection
              • Request activity
              • Response activity
              • SOAP Request activity
              • SOAP Response activity
                • Overview
                • Connection
                • Query activity
                • Insert activity
                • Update activity
                • Upsert activity
                • Connect to IBM DB2
                • Connect to Microsoft
                • Connect to MySQL
                • Connect to Oracle
                • Connect to PostgreSQL
                • Connect to Progress
                • Convert from JDBC to ODBC
              • Overview
              • Prerequisites for S/MIME encryption
              • Prerequisites for a Microsoft 365 OAuth 2.0 connection
              • Connection
              • Read Email activity
              • Send Email activity
              • Ways to send email
              • Overview
              • Connection
              • Read activity
              • Write activity
              • Overview
              • Connection
              • Read activity
              • Write activity
              • Overview
              • Connection
              • Decompress activity
              • Compress activity
              • Overview
              • Connection
              • GET activity
              • PUT activity
              • POST activity
              • DELETE activity
              • Custom activity
              • Convert to HTTP v2
              • Overview
              • Connection
              • Connection authentication types
              • PATCH activity
              • HEAD activity
              • POST activity
              • GET activity
              • OPTIONS activity
              • BULK activity
              • DELETE activity
              • PUT activity
              • Overview
              • Connection
              • Generate Token activity
              • Decode Token activity
              • Validate Token activity
              • Overview
              • Connection
              • Search Entry activity
              • Add Entry activity
              • Delete Entry activity
              • Modify Entry activity
              • Overview
              • Connection
              • Read activity
              • Write activity
              • Overview
              • Connection
              • Query activity
              • Update activity
              • Insert activity
              • Delete activity
              • Overview
              • Connection
              • Encrypt activity
              • Sign activity
              • Decrypt activity
              • Overview
              • Connection
              • Delete file activity
              • Search activity
              • Update file activity
              • Delete folder activity
              • Read file activity
              • Create folder activity
              • Update folder activity
              • Create file activity
              • Overview
              • Connection
              • Activities
              • Overview
              • Connection
              • Read activity
              • Write activity
              • Overview
              • Connection
              • Read activity
              • Write activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Search activity
              • Read activity
              • Create activity
              • Update activity
              • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Execute activity
                • Overview
                • Connection
                • Register Tools activity
                • Prompt activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Get Async Response activity
                • Get Function activity
                • Invoke Function activity
                • List Function activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Insert bulk activity
                • Query activity
                • Upsert activity
                • Invoke Stored Procedure activity
                • Insert Record activity
                • Update Record activity
                • Copy activity
                • Update Bulk activity
                • Delete Record activity
                • Overview
                • Connection
                • Move Object activity
                • Delete Object activity
                • Put Object activity
                • Get Object activity
                • List Objects activity
                • Overview
                • Connection
                • Send Messages activity
                • Receive Message activity
                • Get Messages activity
                • Create Queue activity
                • Delete Messages activity
                • List Queues activity
              • Overview
              • Connection
              • Read activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Get Messages activity
              • Send Message activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • 3LO prerequisites
                • Connection
                • Search activity
                • Issue activity
                • Create activity
                • Update activity
                • Search Dashboard activity
                • Delete activity
                • Transition activity
                • Search Filter activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Account creation
              • Connection
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
                • Overview
                • Connection
                • Get Case activity
                • Get Task activity
                • Search Cases activity
                • Search Tasks activity
                • Create Case activity
                • Create Task activity
                • Update Case activity
                • Update Task activity
                • Overview
                • Connection
                • Create activity
                • Get activity
                • Query activity
                • Update activity
                • Overview
                • Prerequisites
                • Connection
                • Work Order activity
                • Query activity
                • Merge activity
                • Create activity
                • Update activity
                • Incident Management activity
                • Delete activity
                • Change Management activity
                • Known Error activity
                • Problem Management activity
                • Overview
                • Connection
                • Get Event activity
                • Search Events activity
                • Create Event activity
                • Register Webhook activity
                • Deregister Webhook activity
                • Update Event activity
              • Overview
              • Prerequisites
              • Connection
              • Search activity
              • Query activity
              • Create activity
              • Delete activity
              • Copy activity
              • Update activity
              • Download File activity
              • Upload File activity
              • Update File activity
              • Delete File activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Get Records activity
              • Post Records activity
              • Put Records activity
              • Delete Records activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Registration
              • Connection
              • Query Contact activity
              • Create Contact activity
              • Update Contact activity
              • Delete Contact activity
              • Overview
              • Connection
              • Read activity
              • Create activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
                • Overview
                • Connection
                • Query activity
                • Create activity
                • Update activity
                • Overview
                • Create a Coupa lookup as a custom field
                • Populate Coupa lookup values
              • Overview
              • Prerequisites
              • Connection
              • Get activity
              • Create activity
              • Send activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Close Index activity
              • Create Document activity
              • Create Index activity
              • Delete Document activity
              • Delete Index activity
              • Get Document activity
              • Get Index activity
              • Open Index activity
              • Search activity
              • Update Document activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Read activity
              • Update activity
                  • Overview
                  • Connection
                  • Delete activity
                  • Get activity
                  • Post activity
                  • Get Custom Method activity
                  • Put BAQ (UBAQ) activity
                  • Update activity
                  • Get BAQ activity
                  • Post Custom Method activity
                  • Install an Epicor CAB package
                • Overview
                • Connection
                • Query activity
                • Upsert activity
                • Create activity
                • Update activity
              • Overview
              • Connection
              • Get Notes activity
              • Create Notes activity
              • Update Notes activity
              • Delete Notes activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Search activity
              • Query File activity
              • Create activity
              • Delete activity
              • Create File activity
              • Update File activity
              • Delete File activity
              • Issues activity
              • Pull Request activity
              • Update activity
                • Overview
                • Prerequisites
                • Connection
                • Create activity
                • Query activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Data Transfer activity
                • Invoke Routine activity
                • Query activity
                • Insert Record activity
                • Create Structure activity
                • Update Structure activity
                • Update Record activity
                • Delete Structure activity
                • Execute Custom Query activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Get Docs activity
                • Create Docs activity
                • Update Docs activity
                • Overview
                • Prerequisites
                • Connection
                • Update File activity
                • Delete File activity
                • Create File activity
                • List Files activity
                • Get File activity
                • Overview
                • Prerequisites
                • Connection
                • Acknowledge Message activity
                • Create Topic activity
                • Get Message activity
                • Publish Message activity
                • Create Subscription activity
                • Listen Message activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Get Sheets activity
                • Create Sheets activity
                • Update Sheets activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Prerequisites
              • Connection
              • Search activity
              • Create activity
              • Update activity
              • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
              • Overview
              • Connection
              • Read activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Delete Job
              • Get Job
              • Start Job
              • Stop Job
                • Overview
                • Connection
                • Get Metrics activity
                • Create Storage activity
                • Delete Storage activity
                • Query Items activity (Deprecated)
                • Insert Items activity
                • Query Items activity
                • Update Items activity
                • Delete Items activity
                • Overview
                • Connection
                • Get Document v2 activity
                • Get Document activity
                • Set Status activity
                • Send Document activity
                • Get Status activity
                • Overview
                • Connection
                • Get Document activity
                • Send Document activity
                • Get Status activity
                • Set Status activity
                • Overview
                • Connection
                • Get Bulk activity
                • Acknowledge activity
                • Send Bulk activity
                • Get activity
                • NACK activity
                • Get Queue Details activity
                • Send activity
              • Overview
              • Connection
              • Configure additional providers
              • Acknowledge activity
              • Get activity
              • Consume activity
              • Send activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Search activity
              • Read activity
              • Create activity
              • Update activity
                • Overview
                • Connection
                • Read activity
                • Create activity
                • Overview
                • Connection
                • Read activity
                • Create activity
              • Overview
              • Prerequisites
              • Connection
              • Search activity
              • Get activity
              • Get Bulk Status activity
              • Put activity
              • Put Bulk activity
              • Post activity
              • Post Bulk activity
              • Delete activity
              • Delete Bulk activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Upload Media activity
                • Get Metrics activity
                • Send Generic Message activity
                • Send Message activity
                • Mark message as read activity
              • Azure AD Graph deprecation
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Register Tools activity
                • Request Image activity
                • Prompt activity
                • Download Image activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Move Files activity
                • Get File activity
                • Create Files activity
                • List Files Objects activity
                • Delete Files activity
                • Overview
                • Connection
                • Update Vault activity
                • Create Vault Objects activity
                • Query Vault activity
                • Delete Vault Objects activity
                • Create Vault activity
                • Query Vault Objects activity
                • Delete Vault activity
                • Update Vault Objects activity
                • Overview
                • Prerequisites
                • Connection
                • Get Queue Message
                • Unlock Topic Message
                • Delete Queue Message
                • Consume Topic
                • Renew Topic Message Lock
                • Delete Topic Message
                • Send Message
                • Consume Queue
                • Renew Queue Message Lock
                • Get Topic Message
                • Unlock Queue Message
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Prerequisites
                  • Connection
                  • Query activity
                  • Create activity
                  • Update activity
                  • Delete activity
                • Overview
                • Agent configuration
                • Connection
                • Functions activity
                • Overview
                • Agent configuration
                • Connection
                • Create activity
                • Update activity
                • Upsert activity
                • Delete activity
                • Obtain an application ID
                • Overview
                • Connection
                • Create activity
                • Delete activity
                • Query activity
                • Update activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Execute activity
                  • Create activity
                  • Update activity
                  • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                  • Overview
                  • Prerequisites
                  • Connection
                  • Upload File activity
                  • Query activity
                  • Update activity
                  • Create activity
                  • Delete activity
                  • Overview
                  • Connection
                  • Connection details
                  • Query activity
                  • Create activity
                  • Update activity
                  • Delete activity
                  • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Add Channels activity
                • Add Members activity
                • Chat activity
                • List Channels activity
                • Send Message activity
              • Overview
              • Connection
              • Create activity
              • Delete activity
              • Read activity
              • Update activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Prerequisites
              • Connection
              • Query activity
              • Upsert activity
              • Insert activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Search activity
                • Create activity
                • Update activity
                • Get List activity
                • Upsert activity
                • Delete activity
                • Change the WSDL version
                • Enable multi-currency in NetSuite
                • Enable NetSuite asynchronous requests
                • Enable TBA in NetSuite
                • Gather values for using NetSuite TBA
                • Pass null values to NetSuite custom fields
                • Search by status in NetSuite
                • Use a NetSuite account-specific WSDL URL
                • Use NetSuite functions
                • Use standard forms in NetSuite
                • Concurrency governance
                • Custom fields
                • Custom segments
                • Data center error
                • Permissions error
                • Record limits
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
              • Overview
              • Connection
              • Create Transcription activity
              • Register Tools activity
              • Create Image activity
              • Prompt activity
              • Create Translation activity
                • Overview
                • Connection
                • Create activity
                • Delete activity
                • Read activity
                • Search activity
                • Update activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
              • Overview
              • Prerequisites
              • Connection
              • Get Incident
              • Create Incident
              • Update Incident
              • Create Note
              • Manage Incidents
              • List Incident
              • Create Status Update
              • Snooze Incident
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Publish Bulk activity
              • Get Bulk activity
              • Acknowledge activity
              • Get activity
              • Publish activity
              • Consume activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Read activity
              • Create activity
              • Update activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                  • Overview
                  • Connection
                  • Query activity
                  • Insert activity
                  • Update activity
                  • Upsert activity
                  • Delete activity
                  • Bulk Query activity
                  • Bulk Insert activity
                  • Bulk Update activity
                  • Bulk Upsert activity
                  • Bulk Delete activity
                  • Bulk Hard Delete activity
                  • Create a Salesforce external ID for Jitterbit
                  • Create users in Salesforce
                  • Deploy a custom fields package in Salesforce
                  • Manually add custom fields in Salesforce
                  • Update Salesforce picklist values and labels
                  • Use Salesforce functions
                  • Use Salesforce Jitterbit variables
                • Troubleshooting
                • Overview
                • Connection
                • Search activity
                • Read activity
                • Get activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Load activity
                • Overview
                • Prerequisites
                • Connection
                • Subscribe Event activity
                • Subscribe Insert CDC Event activity
                • Publish Event activity
                • Subscribe Update CDC event activity
                • Subscribe Delete CDC event activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Query activity
                • Insert activity
                • Update activity
                • Upsert activity
                • Delete activity
                • Bulk Query activity
                • Bulk Insert activity
                • Bulk Update activity
                • Bulk Upsert activity
                • Bulk Delete activity
                • Bulk Hard Delete activity
                • Overview
                • Connection
                • Query activity
                • Insert activity
                • Update activity
                • Upsert activity
                • Delete activity
                • Bulk Query activity
                • Bulk Insert activity
                • Bulk Update activity
                • Bulk Upsert activity
                • Bulk Delete activity
                • Bulk Hard Delete activity
                • Overview
                • Prerequisites
                • Connection
                • BAPI activity
                • Receive IDoc activity
                • RFC activity
                • IDoc activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Read activity
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Execute activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Prerequisites
                • Connection
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Read activity
              • Query activity
              • Upsert activity
              • Create activity
              • Update activity
              • Send activity
              • Delete activity
              • Overview
              • Prerequisites
              • Connection
              • Connection details
              • Schemas
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Create activity
              • Delete activity
              • Query activity
              • Update activity
              • Overview
              • Connection
              • Create activity
              • Delete activity
              • Query activity
              • Read activity
              • Update activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Prerequisites
              • Connection
              • Get activity
              • Post activity
              • Search activity
              • Chat activity
              • Files activity
              • Conversations activity
              • Users activity
              • Overview
              • Connection
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Delete Sheet activity
              • Import Sheet activity
              • Get Sheet activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Prerequisites
              • Connection
              • Query activity
              • Merge activity
              • Update activity
              • Get activity
              • Insert activity
              • Invoke Stored Procedure activity
              • Delete activity
                • Overview
                • Registration
                • Connection
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Overview
                • Connection
                • Read activity
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
              • Overview
              • Connection
              • Create activity
              • Delete activity
              • Read activity
              • Search activity
              • Update activity
                • Overview
                • Connection
                • Get Contacts activity
                • Create Contacts activity
                • Update Contacts activity
                • Delete Contacts activity
                • Overview
                • Connection
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Read activity
              • Initial Load activity
              • Create activity
              • Update activity
              • Overview
              • Connection
              • Read activity
              • Upsert activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Create activity
              • Delete activity
              • Query activity
              • Update activity
                • Overview
                • Prerequisites
                • Connection
                • Activity
                • Overview
                • Connection
                • Get activity
                • Complete wBucket activity
                • Create activity
                • Load data activity
                • Get status activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Read activity
              • Create activity
              • Update activity
              • Delete activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
              • Execute activity
              • Overview
              • Connection
              • Search activity
              • Query activity
              • Create activity
              • Update activity
              • Delete activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
                • Overview
                • Connection
                • Connection details
                • Query activity
                • Create activity
                • Update activity
                • Delete activity
                • Execute activity
              • Overview
              • Connection
              • Connection details
              • Query activity
              • Execute activity
          • Custom connectors
          • Tool types and creation
              • Key concepts
              • Create your first transformation
              • Choose schema sources
              • Navigate the interface
              • Overview
                • Map identical structures
                • Map fields manually
                • Map variables
                • Use custom values
                • Work with hierarchical data
                • Control data loops
                • Add conditional logic
                • Resolve mapping conflicts
              • Use scripts
              • Define schemas
              • Manage schema processing
              • Regenerate schemas
            • Test and validate
              • Export and import mappings
              • Reuse transformations
            • Create
            • Test
            • Jitterbit Script
            • JavaScript
          • Invoke Operation (Beta)
          • Log (Beta)
          • Decision (Beta)
          • Overview
          • Cache functions
          • Conversion functions
          • Cryptographic functions
          • Database functions
          • Date and time functions
          • Debugging functions
          • Dictionary and array functions
          • Diff functions
          • Email functions
          • Environment information functions
          • File functions
          • General functions
          • Instance functions
          • JSON functions
          • JWT functions
          • LDAP functions
          • Logging and error functions
          • Logical functions
          • Math functions
          • NetSuite functions
          • Salesforce functions
          • String functions
          • Text validation functions
          • XML functions
          • JavaScript Jitterbit and common functions
          • JavaScript standard properties and functions
          • Overview
          • Local variables
          • Global variables
          • Project variables
            • Overview
            • API Jitterbit variables
            • NetSuite Jitterbit variables
            • Operation Jitterbit variables
            • Scripting Jitterbit variables
            • SFDC Jitterbit variables
            • Source Jitterbit variables
            • Target Jitterbit variables
            • Text Jitterbit variables
            • Transformation Jitterbit variables
            • Web service Jitterbit variables
            • Miscellaneous Jitterbit variables
          • Filename keywords
          • Overview
          • Email notifications
          • Overview
          • Initialize global variables
          • Plugins added to an activity
          • Plugins called in a script
        • Filter records using conditions
        • Handle arrays using Get and Set
        • Manage asynchronous operations
        • Manage endpoint credentials
        • Manage workflows using controller scripts
        • Populate and use a dictionary
        • Read a zipped Base64-encoded file
        • Reuse endpoints and scripts
        • Send changed Salesforce object records to a database via Salesforce workflow rule and API Manager
        • Send changed Salesforce object records to a database via Salesforce flow and API Manager
        • Split a file into individual records using SCOPE_CHUNK
        • Split a file into individual records using SourceInstanceCount
        • Support SOAP MTOM/XOP messages
        • Use a naming convention for variables
        • Use scripts to chain or control operations
        • Known issues
        • Operations
        • Overview
        • Quick start guide
        • System requirements
        • Install on Windows
        • Install on macOS
        • Add certificates to keystore
        • Configure proxy settings
        • Configure SSL for web services
        • Best practices
        • Integration project methodology
        • Overview
        • Create a new project
        • User interface
        • User interface main menus
        • User interface main toolbar
        • User interface project tree
        • User interface transformation toolbars
        • Download a project
        • Restore from a cloud backup
        • Set up user preferences
          • Create an operation
          • Operation options
          • Chunking
          • Test an operation
          • Check pending operations
          • Review an operation log
          • Call an operation from a command line
          • Email messages
          • Route SOAP faults
          • Create a transformation
          • Check for duplicates in source file
          • Conditional mapping
          • Data normalization
          • Dynamic XML schema generation
          • Hierarchical entity path notation
          • Flat to hierarchical output
          • Flat to hierarchical structures
          • Hierarchical to flat structures
          • Multiple mapping
          • Regular expressions
          • Source loop node
          • Stream and batch transformations
          • Text to XML transformation wizard
          • Transformation mapping
          • Request and response data element display
          • Test a transformation
          • Database to a database
          • Database to a text file
          • Database to a web service request
          • Database to XML
          • Text file to a database
          • Text file to a text file
          • Text file to a web service request
          • Text file to XML
          • Web service response to a database
          • Web service response to an XML
          • LDAP to LDAP
          • XML to a database
          • XML to a text file
          • XML to a web service request
          • XML to database wizard
          • XML to XML
          • Create a REST transformation
          • Overview
            • Overview
            • Create a database source
            • Configure a Microsoft SQL database source
            • Configure an Oracle ODBC database source
            • Configure a Progress JDBC database source
            • Create a database target
            • Configure a Microsoft Access database target
            • Configure a Microsoft SQL database target
            • Configure a MySQL database target
            • Configure an Oracle ODBC database target
            • Configure a PostgreSQL database target
            • Set up DB2 on iseries using a JDBC driver
            • Connect to Excel spreadsheets
            • Connect to Microsoft Access
            • Convert to a JDBC driver
            • Manual connection string
            • Use a database as a source
            • Use a database as a target
            • Use a proprietary ODBC or JDBC driver
          • Email
            • Create a File Share source
            • Create a File Share target
            • Create an FTP site source
            • Create an FTP site target
            • Create a global variable source
            • Create a global variable target
            • Create an HTTP source
            • Create an HTTP target
              • Overview
              • Research a REST API
              • Validate a REST API
              • Connect to a REST API
              • Use a REST API in operations
            • Supported HTTP authentication methods
            • Create an LDAP source
            • Create an LDAP target
            • Use LDAP sources and targets
            • Use LDAP in a script
            • Create a local file source
            • Create a local file target
            • Use NetSuite TBA with a local file source
            • Overview
            • Create a Temporary Storage source
            • Create a Temporary Storage target
          • Export source and target settings
          • Global variable versus Temporary Storage
          • Flat to hierarchical target structure
          • Specify source and target fields dynamically
          • Test source data
          • XML as a source and target
          • Call a web service
          • Create a hosted web service
          • Create a web service method
          • Create a web service method (example)
          • Find the endpoint URL
          • Create a hosted HTTP endpoint
          • Overview
          • Define a file format
          • Create a text document definition from a sample file
          • Flat file field validation
        • Schedules
          • Overview
          • Create a condition
          • Create a script
          • Jitterbit Script language
          • JavaScript
          • Overview
          • Formula builder features
          • Use the formula builder
          • Debug the formula builder
          • Cache functions
          • Connector functions
          • Conversion functions
          • Cryptographic functions
          • Database functions
          • Date and time functions
          • Debugging functions
          • Dictionary and array functions
          • Diff functions
          • Email functions
          • Environment information functions
          • File functions
          • General functions
          • Instance functions
          • JSON functions
          • JWT functions
          • LDAP functions
          • Logging and error functions
          • Logical functions
          • Math functions
          • Salesforce functions
          • String functions
          • Text validation functions
          • XML functions
          • JavaScript Jitterbit and common functions
          • JavaScript standard properties and functions
          • Overview
          • Local variables
          • Global variables
          • Project variables
            • Overview
            • API Jitterbit variables
            • Hosted endpoint Jitterbit variables
            • NetSuite Jitterbit variables
            • Operation Jitterbit variables
            • Scripting Jitterbit variables
            • SFDC Jitterbit variables
            • Source Jitterbit variables
            • Target Jitterbit variables
            • Text Jitterbit variables
            • Transformation Jitterbit variables
            • Web service Jitterbit variables
            • Miscellaneous Jitterbit variables
          • Filename keywords
          • Overview
          • Create an API entity operation
          • Create a Jitterbit entity
          • Overview
          • Override JSON metadata
            • Overview
            • Org wizard
            • Query wizard
            • Upsert wizard
            • Insert wizard
            • Update wizard
            • Delete wizard
              • Overview
              • Bulk process wizard for query, insert, update, delete, or hard delete actions
              • Bulk process wizard for upsert action
            • Advanced
            • Create custom fields in Salesforce
            • Text to database wizard
            • Database to database wizard
            • Database to text wizard
            • Database to XML wizard
          • Overview
          • Recipes
            • Overview
            • Endpoint
            • Create
            • Update
            • Upsert
            • Delete
            • Get
            • Overview
            • Endpoint
            • Create
            • Update
            • Delete
            • Query
            • Advanced
            • Overview
            • Prerequisites
            • Endpoint
            • Create
            • Read
            • Update
            • Patch update
            • Delete
            • Advanced
            • Overview
            • Installation and setup
            • Endpoint
            • Send and publish activities
            • Poll activities
            • Browse activities
            • Listen activities
            • Listen and acknowledge activities in transacted sessions
            • Logging and debugging activities
            • Enable RabbitMQ provider with JMS
            • Overview
            • Installation and setup
            • Endpoint
            • Function and operation guide
            • Overview
            • Installation and setup
            • Endpoint
            • Connector create
            • Update
            • Upsert
            • Delete
            • Query
            • Obtaining a Microsoft Dynamics CRM connector application ID
            • Overview
            • Set up Microsoft Dynamics GP
            • Endpoint
            • Create
            • Update
            • Delete
            • Overview
            • Enable TBA in NetSuite
            • Use NetSuite TBA in the NetSuite connector
            • NetSuite HMAC-SHA1 deprecation
            • Endpoint
            • Create
            • Update
            • GetList
            • Upsert
            • Delete
            • Search
            • Advanced
            • Get a NetSuite application ID
            • Overview
            • Endpoint
            • Concurrency programs
            • Overview
            • Prerequisites
              • Overview
              • Prerequisites
              • Create QuickBooks app
              • Create endpoint
              • Implementation
              • Overview
              • Prerequisites
              • Create QuickBooks app
              • Create endpoint
            • Create activities
            • Update activities
            • Delete activities
            • Query activities
            • Overview
            • Prerequisites
            • Endpoint
            • Function
            • Guide to using RFC_READ_TABLE to query SAP tables
            • Best practices for SAP
              • Overview
              • Get started guide
              • SAP system configuration
              • Installation
              • Configuration
              • Design Studio configuration and use
          • Siebel
            • Overview
            • Endpoint
          • Overview
          • Apply pipeline plugins
          • Required plugins
        • Capture data changes with an API Manager API or HTTP endpoint
        • Capture data changes with file sources
        • Capture data changes with source field values
        • Capture data changes with table or file changes
        • Capture data changes with timestamp-based queries
        • Configure outbound messages with an API Manager API
        • Configure outbound messages with hosted HTTP endpoints
        • Create single- or multiple-record output
        • Create a transformation iterator dynamically
        • Filter duplicate records in a source file
        • Incorporate continuous integration practices
        • Link source or target records using shared IDs
        • Look up data during runtime
        • Look up data using a dictionary
        • Persist data for later processing using Temporary Storage
        • Persist inbound data for later processing
        • Process target records conditionally
        • Request a session token via REST
        • Run the next operations conditionally using operation chains
        • Set up alerting, logging, and error handling
        • Set up a team collaboration project
        • Update multiple targets from a single source record
        • Upsert Clarizen data with a chain of operations
        • Overview
        • Dashboard
        • Configure recipe
        • Generate or edit recipe
        • Manage deployed recipes
        • My recipes
        • Jitterpaks
        • Glossary
          • Overview
          • Known issues
          • SSL certificate or proxy filter setting error
          • Windows 10 high-density display scaling error
          • System errors
          • Repeating file transfers
          • Long load times when using a proxy
          • Overview
          • Export as a Jitterpak
          • Import a Jitterpak
          • MongoDB
          • NetSuite to Salesforce opportunity to order
          • Salesforce relationship query
          • Salesforce Einstein Analytics with a CSV file or a database
      • Overview
      • Get started
      • System requirements
      • Download Data Loader
      • End user license agreement
        • Add certificates to keystore
        • Configure proxy settings
        • Run a Salesforce query
        • Upgrade Jitterbit Data Loader
        • Upload files to Salesforce
        • Known issues
        • Agent not running or is stopped or unreachable
      • Overview
      • System requirements
      • Docker
      • Linux
      • Windows
        • Migrate agents
        • Custom PostgreSQL install on Windows
        • Reset the PostgreSQL admin user password
      • Troubleshoot
        • Agent registration
        • Database drivers
        • Java
        • Listening service
          • Native observability
          • Third-party observability with Datadog
          • Third-party observability with Elasticsearch
        • Performance
        • PostgreSQL
        • Proxy server
        • SAP connectors
        • SSH
        • Support tools
        • Utility programs
        • Character encoding
          • Overview
          • jitterbit.conf
          • jitterbit-agent-config.properties
          • Cleanup service
          • Apache
          • Agent log files
          • Operation logs
          • Operation debug logs (private agents)
          • Operation debug logs (cloud agents)
          • Verbose logs
          • Observability logs
        • Listening service architecture
          • Datadog dashboards
          • Overview
          • Available Plugins
          • AES Encryption
          • Amazon S3 SOAP Signer
          • AS2
          • AWS S3 Create
          • AWS S3 Get
          • Control Character Replacer
          • CSV File Splitter
          • CSV Splitter 2
          • DB Update
          • EBCDIC To ASCII
          • File Merger
          • Groovy Runner
          • HMAC-SHA1 Generator
          • HMAC-SHA256 Generator
          • HTML Form Encoder
          • Line Break Cleaner
          • Multipart
          • OASIS Web Service Security
          • OAuth - Google - Service Account
          • PGP Decryption
          • PGP Encryption
          • POP3 File Reader
          • Prepend Data
          • Run Command
          • Run Command On File
          • Send Email with Attachment
          • Siebel On Demand Login
          • Split XML by Value
          • UnixToDos
          • Unzip
          • UTF-8 File Encoder
          • XSL Transform
          • Zip Archive
    • Cloud Datastore (Beta)
    • Message Queue
      • Overview
          • Change status
          • Compress files
          • Decompress files
          • Delay
          • Delete
          • Enqueue items
          • Flow reference async
          • Get items pending
          • Global properties
          • If/Else
          • List paginated
          • Log
          • Loop
          • Parse Base64 decode
          • Parse Base64 encode
          • Parse HTML to PDF
          • Parse JSON to XML
          • Parse XML to JSON
          • Read flat file
          • Set variable and Get variable
          • Stop loop
          • Switch
          • Transformation
          • TryCatch
          • Upsert
          • Webhook response
          • Write flat file
        • API verbs
        • Configure or modify trigger
        • Connector store
        • Create a flow
        • Duplicate an action
        • Export a flow
        • Flow design
        • Flow versioning
        • Import a flow
        • Mapping
        • On-premise agent applications
        • Pod management
        • SMTP connector
        • Trigger event
        • Add or alter data in a lookup table
        • Code function
        • Create a connector
        • Create a lookup table
        • Dynamic storage
        • Send data via email in a spreadsheet
        • Upload data from a spreadsheet
        • Audit log
        • Create a process queue
        • Dashboard
        • Flow monitor
        • Log analysis
        • Log cryptography
        • Monitor a process queue
        • Notifications: Channels and groups
        • Notifications: Configure events
        • Process queue
        • Retry policy
        • User creation
        • User permissions
      • Overview
      • Key concepts
      • Quick start guide
      • View and manage
        • Custom API
        • OData service
        • Proxy API
      • Export and import
      • Generate documentation
      • Test with documentation
        • Overview
        • Cloud API gateway
          • Overview
          • Install on Linux
          • Run on Docker
          • Known issues
      • Configure security profiles
        • Microsoft Entra ID 2-legged OAuth 2.0
        • Microsoft Entra ID 3-legged OAuth 2.0
        • Google 3-legged OAuth 2.0
        • Okta 2-legged OAuth 2.0
        • Okta 3-legged OAuth 2.0
        • Salesforce 3-legged OAuth 2.0
      • Trusted IP groups
      • API groups
      • View logs
      • Analytics and metrics
      • Use the AI Assistant to create an API
      • Set up Salesforce connect to consume an OData service API
      • API endpoint communication issues when using Zscaler
      • Overview
      • Philosophy
      • Build a simple app
      • Use the AI Assistant to build an app
      • Navigate the UI
      • Features, systems, and security providers
      • Security
      • Deployment options
        • System requirements
        • AWS recommended resources
        • Antivirus configuration recommendations
          • High availability on-premises deployment in AWS
          • AWS Cognito setup
          • Install in AWS (Windows)
          • Install in Microsoft Azure
          • High availability on-premises deployment on Windows
          • Install on Windows
          • Install DB2 luw driver
          • Upgrade on Windows
          • Install
          • Upgrade from Vinyl
        • Linux
          • Scripts directory
          • GrantAppPoolPermission.ps1
          • ProtectConfiguration.ps1
          • RegisterCrystalReports.ps1
          • SetConnectionInfo.ps1
          • TestInstall.ps1
          • UnprotectConfiguration.ps1
          • Configure auto start for IIS 8.5
          • Configure auto start for IIS 7.5
          • Test always running behavior
          • Troubleshoot auto start behavior
          • HTTPS workaround
          • Native wrapper
          • Find the server URL
        • Startup configuration
        • Configure Harmony portal access to an instance
        • Crystal reports runtime engine
        • Data encryption keys
        • Encrypted database connection information
        • FIPS compliance
        • Licensing
        • Reverse proxies
        • Security headers
        • Security protocol support
        • Sites and aliases
        • Teradata file requirements
        • Transparent data encryption
        • URL rewriting
      • Site menu
      • Action drawer
      • Live designer
      • Design center
        • Overview
        • App settings
        • Data sources
        • Tables
        • Rules
        • Notifications
        • Pages
        • Menu
        • Roles
      • IDE
          • Create a data source connection
          • Stored procedures
          • Linked data sources
          • Sealing and unsealing data sources
          • Test connections
          • Time zones
          • Date migration
          • CData usage report
          • Dynamics 365 Business Central
          • Dynamics CRM
          • QuickBooks Desktop
          • QuickBooks Online
          • Veeva Vault
          • Airtable
          • Google BigQuery
          • Google Calendar
          • Google Contacts
          • Google Sheets
          • Google Sheets using JWT authentication
          • HubSpot
          • Infor M3
          • Jira
          • Microsoft SharePoint Cloud
          • NetSuite
          • OData
          • Quickbase
          • Salesforce ADO.NET
          • SAP Business One
          • SAP Concur
          • ServiceNow
          • Sybase ASE
          • Shopify
          • Amazon S3
          • Azure Blob Storage
          • Local file system or network file system
          • Microsoft SharePoint File System
          • SFTP
            • Transfer files from a file system to SFTP
            • Transfer files to SharePoint
            • Transfer files to a file system
          • Connectors
          • Gmail
          • Microsoft Exchange
          • MongoDB
          • IBM DB2 for i
          • Microsoft SQL Server
          • Microsoft SQL Server Informix
          • MySQL
          • Oracle
          • PostgreSQL
          • Redshift
          • Teradata
          • SAP ABAP over RFC IDoc
          • SAP ABAP over RFC with SNC
          • SAP ABAP over RFC BAPI
            • REST
            • SOAP
            • REST API repository
            • REST API tutorial
            • REST object
            • JSON to table mapping
            • Multipart request
            • Endpoint from an OpenAPI document
          • Webhook API
        • Overview
        • Import and export
        • Inspect the request
        • Active Directory (AD)
        • API key
          • Overview
          • Configure application authentication
          • Overview
          • Client authentication
          • Configure HTTP authentication
          • Anonymous authentication
          • Basic authentication
          • Mutual authentication
          • Overview
          • Configure IWA
        • Jitterbit Harmony
        • JWT SSO
          • Configure local user
          • Password expiration
          • Password policies
          • Password reset
          • Account lockout
          • Configure OAuth
          • Configure Amazon Login OAuth
          • Configure Google OAuth
          • Configure Facebook OAuth
          • Configure LinkedIn OAuth
          • Configure Microsoft SharePoint OAuth
          • Configure QuickBooks Online OAuth
          • Configure Salesforce OAuth
          • Configure Salesforce JWT OAuth
          • Configure Twitter OAuth
        • OData
          • Overview
          • Google OIDC
          • Microsoft OIDC
          • Salesforce OIDC
          • App Builder OIDC
        • Salesforce
          • Configure SAML
          • Configure AD FS SAML
          • Configure Auth0 SAML
          • Configure Duo SAML
          • Configure Google SAML
          • Configure Google SSO SAML
          • Configure Okta SAML
          • Configure SAML identity provider
          • Configure App Builder SAML identity provider
        • SAP OData services
          • Overview
          • Configure SuccessFactors OData
          • Overview
          • SuccessFactors password
        • URL rewriting
        • User provisioning
          • Overview
          • Configure CA WAM
          • Configure WS-Federation
          • Configure AD FS WS-Federation
          • Configure Microsoft Azure AD WS-Federation
        • Notifications
        • SMTP
          • Overview
          • Recommendations
          • Publish an app as a REST API
          • Complex REST API structures
          • Examples
          • JSON arrays (drill downs)
        • Webhooks
        • Logs
        • Create a new app
        • Application and page name restrictions
        • Auto build
        • Auto build report generator
        • Customize the support link
        • Repeatable file import process
        • Create and restore snapshots
          • Create a table
          • Import a table from Excel
          • Managed tables
          • Server-side pivot tables
          • Table inheritance
            • Overview
            • Boolean
            • Currency
            • Date
            • Date/time
            • Email
            • Number
            • Percent
            • Photo
            • String
            • Unique ID
            • URL
            • Overview
            • Block
            • Temporary
          • Column templates
          • Column encryption
          • Primary key column
          • Default values
          • Where used report for columns
          • Overview
            • App_DataObject_List
            • App_Image
            • App_List
            • App_Page_List
            • App_Role
            • ControlType_List
            • PageViewLog
            • DataSource
            • Event_List
            • Table
            • Country
            • Culture
            • TimeZone
            • TranslatePhrase
            • EventHistory
            • Job
            • Schedule
            • Authenticate
            • Challenge
            • Group
            • Identity_Current
            • IdentityClaim_Current
            • Key_Generate
            • Provider
            • User_Create
            • User_Current_ChangePassword
            • User
            • User_Current
            • User_LocalAuthentication
            • User_Read
            • User_SetPassword
            • UserGroup
            • UserRole
            • Realm_Group
            • Realm_Provider
            • Realm_User_Create
            • Realm_UserGroup
            • Notification_Create
            • Bundle
            • Bundle_App
            • Language
            • TranslatePhrase
            • Translation
            • Translation_Format
            • Translation_Type
            • Translation_User
            • Column_Public
            • DataSource_Public
            • Event_Public
            • Table_Public
            • App_SiteMenu
            • Native_App_TabMenu
          • Create a business rule
            • Overview
            • Subquery vs. business object
            • Table vs. business object
              • Overview
              • Create a join
              • Join types
              • Operators
                • Create a WHERE clause
                • WHERE clause operators
                • Overview
                • Is active value
                • User selectable values
              • Source business objects
              • Target in business object rules
              • Dynamic page linking
              • Access to public data objects
              • Display a file name for file download
              • Dynamically change an icon
              • Modify source business objects
              • Update a table with the name of a file being inserted into a file browser
              • Return a random row from a table
              • Expose a business object as an API endpoint
              • Tips for working with binary columns
              • Overview
              • CRUD Cram
              • Batching
            • Default
            • Migration
            • Reach
              • Overview
              • Bitwise operators
              • Column substitution
              • Escaping SQL
              • String literals
            • Validation
            • Implicit and explicit binding
            • List control bindings
            • Capability bindings
            • Shared criteria
            • Versions
            • Editor
            • Query support
            • String literals
          • Parameterized data objects
          • Cast options for a column
          • Generic file container
          • Dynamic substitution
          • Regular expressions
          • Configure an event
          • Action types
          • Inheritance
          • Concurrency and locking
          • Action error handling
          • Transactions
          • Rollback handlers
          • Run as user
          • Run on fail
          • Run on demand
          • Control panel behavior after event runs
          • Invoke another event as an action type
          • Export an event to CSV
          • Visual workflow
          • Workflow diagrams
          • Overview
          • User-defined functions
            • Abs
            • Aggregate
            • Average
            • Cast
            • Char
            • Concat
            • ConcatWithDash
            • ConcatWithParentheses
            • ContainsAlpha
            • Count
            • DateAdd
            • DateDiff
            • DateName
            • DatePart
            • DenseRank
            • Differ
            • EscapeIfRequired
            • Expression
            • FromOffSet
            • FromTimeZone
            • GroupConcat
            • HasFlag
            • IIF
            • IsNull
            • IsNumeric
            • Left
            • Length
            • Lower
            • Lpad
            • Max
            • Min
            • NewUUID
            • Now
            • Null
            • Position
            • Power
            • Rank
            • RowNumber
            • Rpad
            • RemoveSpaces
            • Replace
            • Right
            • Rj0
            • Round
            • Sqrt
            • Substring
            • Sum
            • Timestamp
            • ToOffSet
            • ToTimeZone
            • Trim
            • Type
            • Upper
            • UUID
            • VisibilityOption
            • Weekday
            • Workday
            • App
            • Caller
            • Changed
            • Claim
            • Client
            • Enum
            • Event
            • Generated
            • Memory
            • Page
            • RandomBytes
            • Recipient
            • Realm
            • Request
            • Role
            • Session
            • Shared
            • Version
            • Who
          • Remap error messages
          • Create a page
          • Wizard pages
          • Styles
          • Help text
          • Configure sizing for popup page
          • Convert a page to a Crystal Report
          • Crystal Report HTML tags
          • Replace page in history
          • Create a panel
          • Copy a panel
          • Remove the title bar and toolbar
            • Panel types
              • Visibility views
              • Display controls on a form with multiple columns
              • Paging
              • CSV downloading
              • Visibility columns
              • Column selection service
              • Configure a preset filter
            • Lane
            • Pivot
            • Network graph
            • Map
            • Gantt
              • Overview
              • Chart types
              • Chart with secondary axis
              • Bar
              • Bubble
              • Marimekko
              • Mixed
              • Stacked area
            • Calendar
            • Frame
            • Overview
            • Tabs
            • Scrolling groups
            • Scrolling panels
            • Panel size
            • Panel size options
            • Font size
            • Overview
            • Filter panels
          • Auto edit
          • Visibility
          • Multi filter
          • Label layout
          • Panel selection service
          • Add a control to a panel
            • Overview
            • Autocomplete
              • Overview
              • Change button icon from solid to regular fill
              • Dynamically disable the create button
              • Header button
              • Open a file from a panel
            • Checkbox
            • Color picker
            • Date
            • Dynamic
              • Overview
              • Quill WYSIWYG editor
            • Icon
            • Image
              • Overview
              • Always show subtitle
            • Password
            • Text
            • Text area
            • Overview
            • Collapse/expand, accordion, tabs
            • Priority
            • Sorting
            • Width
            • Pinning
            • Overview
            • Create, update, and delete
          • Add a badge on a button, icon, or image control
          • Configure external links on controls
          • Configure a control as a navigation link
          • Conditional formatting to change font color
          • Hide an up-down control in numeric field
          • Hide the chevron on a text field that has an event
          • Native mobile controls
          • Configure a tabbed or mobile menu
          • Configure a menu with a data object
          • Create a menu
          • Style themes
          • Mobile theme
          • Configure theme interfaces
          • Change the background on the page title bar
          • Change the color of the required field flag
          • Change the font color
          • Hide the exit button on a page
          • Add a logo to an app
            • Create and use HTML templates
            • Add a progress bar using an HTML template
            • Google maps HTML template
            • Media HTML template example
            • JSON options object templates with charts
            • Create a gradient fill for a chart
          • Add a widget
          • Download library
          • Troubleshooting
            • Overview
            • Configure custom fonts
          • Currency format
          • Dial
          • Favicon loader
          • Fraction dial
          • Geolocation
          • Google Analytics
          • iframe resizer
            • Overview
            • S3 multi file upload
          • Org chart
          • Rating bars
          • Signature
          • Text format
          • Web font loader
        • Overview
        • CreateRowOnEmptyTablePlugin
        • GenerateJwtPlugin
        • HttpRetrieverPlugin
        • RegexValidationPlugin
        • SaveReport
        • SMTPPlugin
        • Structured Data
        • Sleep
        • Build a release package
        • Release management
        • Maintenance workflow
        • Sealing and unsealing applications
        • Translate an app to another language
        • How the translation system works
        • Internationalization and localization
        • Translation templates
        • Background services
        • Foreground events
        • Event history
        • Log secure data
        • Tracing
        • User security reports
        • Self-documenting reports
        • Sessions
        • Create a session table
        • Page view and session activity logs
        • Monitor application
        • Audit lite
        • Full audit
        • Audit configuration
        • Users and groups
        • User and group management
        • User and group provisioning
        • User provisioning application
        • User authentication methods
        • Change password on logon
        • Privileges and permissions
        • Providers and identities
        • Security log
        • Realms
        • Claims
        • Developer silos
        • Self-service
        • Anonymous access
        • Hide errors from users
        • Deactivate a user
        • Performance debugging and enhancement
        • Disable HTML icons based on roles
        • Mobile app troubleshooting
        • Retrieve a dump file
        • Copy button for error messages
        • Create a plugin
          • Default
          • Validation
          • Row-level action
          • Table-level action
          • Default
          • Visibility
          • HTTP requests
          • HTTP responses
        • Overview
        • Vinyl.Sdk.Controls
        • Vinyl.Sdk.Events
        • Vinyl.Sdk.Filtering
        • Vinyl.Sdk.Functions
        • Vinyl.Sdk.Http
        • Vinyl.Sdk.Tables
        • Overview
          • Validate a URI
          • Validate an encrypted password field
          • Perform a dns lookup to validate a host name
          • Sleep for a second
          • Generate JSON from cell values
          • Write to the Windows event log
          • Download a file
          • Execute the ping command
          • Text file import
          • Encrypt file with open PGP
          • Text file creation
          • Custom Excel import
          • Batch files for download
          • Export to XML
          • Format values with humanizer
          • List system processes
          • Default a value to the server's public IP address
          • Convert Base64-encoded value to text
          • Convert binary response to text
          • Logging
          • Generate HMAC HASH using private token
          • Return a field as XML
      • Add a Google Map to a panel
      • Aggregate a business object at the panel level
      • Build an offline app
      • Offline app authentication
      • Connect to DocuSign
      • Connect to Intercom
      • Configure Google Fonts
      • Convert a control to all uppercase
      • Count the occurences of a character in a string
      • Create a custom login page
      • Create a number table with 1 to N rows
      • Create a ranking system
      • Create a tiered directory structure
      • Design a dashboard
      • Format an Excel export using Crystal Reports
      • Generate a random letter
      • Group rows by column
      • Incorporate Facebook messenger
      • Ingress links
      • Notification using dynamic query to insert into HTML table
      • Rename a database logical name
      • Render binary column photo in an email as an image
      • Share non-binding data between panels
      • Troubleshoot installation issues
      • Use date part
      • View an app's change log
      • Keyboard shortcuts
      • Glossary
      • Best practices
    • Overview
    • Get started with EDI
    • Set up an ISA ID
      • Introduction
      • Manage workflows
      • Manage PII
        • Overview
        • X12
        • EDIFACT
        • TRADACOMS
      • Archive settings
      • Communication settings
    • Manage transactions
    • View archives
    • View messages
    • View transaction reports
      • Document types
      • EDI envelopes
      • FTP connection filename parameters
      • ISA ID qualifier codes
      • Upload file formats
      • XPath mapping file
    • Overview
    • Get started
    • User interface
    • Search expressions
    • Integration recipes
    • Process templates
      • Overview
      • Sales Agent
      • Knowledge Agent
    • Overview
    • Dashboard
    • Access Tokens
      • Overview
      • Private agents
      • Cloud agents
      • Observability metrics
        • Observability metrics charts
        • Page settings
    • Alerts
    • Audit Logging
    • Cloud Datastore (Beta)
    • Endpoints Usage (Beta)
    • Environments
    • Message Queues
    • Organizations
    • Projects
    • Runtime Operations
    • User Management
      • App Registrations
      • Client Certificates
      • Plug-ins