Getting Started
Quick-Start Guide
Installation and Configuration
Starting the Server
Cross-Platform Edition
.NET Edition
Cloud Marketplaces
How to Upgrade
Administration
Dashboard Page
Profiles Page
Settings Page
Global Settings Vault
Single Sign-On
User Management and Roles
Logs Page
Clustering
DMZ Gateway
Importing and Exporting
Reports
Separate API Endpoints
Security Best Practices
Architecture
Glossary
Release Notes
Current Release (8698)
July 2023 (8601)
April 2023 (8517)
January 2023 (8473)
October 2022 (8336)
June 2022 (8215)
April 2022 (8126)
January 2022 (8054)
June 2021 (7832)
Flows
Designing a Flow
Common Flows
Error Handling
Workspaces
Flow API
Connectors
Overview
Core
API
Configure a Connector
Establish a Connection
Build Your First API
API Resources
API Actions
Query Your API
API Management
Authentication
Additional Output Formats
Customize Your API
Batch Create
Batch Merge
Batch Split
Branch
CData
Setup
Advanced Configuration
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
CData [Deprecated]
Copy
CSV
CSV Map
Email Receive
Email Send
Excel
File
Flat File
Form
Header Match [Deprecated]
JSON
Lookup [Deprecated]
Notify
PSV
REST
RSS
Schedule
Script
SOAP
Split
TCP Server
TSV
Validate
Webhook
Workspace Receive
Workspace Send
XML Map
Overview
Configuration
Generating Template Files
Using the Mapping Editor
Using the Expression Editor
Using the Condition Mapping Editor
Advanced
Virtual Nodes
XML Attributes
XML Match [Deprecated]
XSD
XSLT
Zip
MFT
AS2
AS3
AS4
Azure Blob
Box
Dropbox
FTP
FTP Server
GISB
Google Drive
Google Storage
OFTP
OneDrive
OpenPGP
RosettaNet
S3
SCP
SFTP
SFTP Server
SharePoint
Connection Setup
Configuration
SharePoint [Deprecated]
WebDAV
EDI
EANCOM
EDIFACT
HL7
HL7 MLLP
IATAPADIS
PDF Label
PIP
TRADACOMS
VDA
X12
Database
Database
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Database [Deprecated]
DB2
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
DB2 [Deprecated]
MySQL
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
MySQL [Deprecated]
Oracle
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Oracle [Deprecated]
PostgreSQL
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
PostgreSQL [Deprecated]
SQL Server
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
SQL Server [Deprecated]
SQLite
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
SQLite [Deprecated]
Other
Adobe Commerce
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedures
Advanced Configuration
Amazon Marketplace
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Submit Vendor Order Ackowledgement
Submit Vendor Shipment Confirmations
Submit Vendor Payments
Update Inventory
Advanced Configuration
AMQP
Apache Kafka
BigCommerce
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Databricks
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Dynamics 365
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Dynamics 365 Business Central
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Exact Online
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
FHIR
Setup
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
IBM MQ
Infor CloudSuite Industrial
Kintone
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
MQTT
NetSuite
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Odoo
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
QuickBooks Online
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Sage Intacct
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Salesforce
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Upload
Download
Execute Stored Procedure
Advanced Configuration
SAP IDoc
ShipStation
Setup
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Create Shipping Label
Advanced Configuration
Shopify
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Snowflake
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Square
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Stripe
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Tally
Setup
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Export Report
Advanced Configuration
WooCommerce
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Zoho CRM
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
Zoho Inventory
Setup
Upsert
Lookup
Lookup Stored Procedure
Select
Execute Stored Procedure
Advanced Configuration
How-To Guides
Overview
Configure an AS2 Connection
Configure an AS4 Connection
Configure an OFTP Connection
EDI QuickStart with Excel
Map EDI to CSV
Map Database Output to EDI
Backup or Migrate CData Arc
API
Overview
Authentication
Resources
Filtering
Actions
Example Use Cases
Scripting
Overview
Introduction
Keywords
arc:break
arc:cache
arc:call
arc:case
arc:catch
arc:check
arc:continue
arc:default
arc:else
arc:enum
arc:equals
arc:exists
arc:finally
arc:first
arc:if
arc:import
arc:include
arc:includec
arc:info
arc:last
arc:map
arc:match
arc:notequals
arc:null
arc:notnull
arc:push
arc:render
arc:restrict
arc:script
arc:select
arc:set
arc:setc
arc:setm
arc:throw
arc:try
arc:unset
arc:validate
Operations
appSendEmail
dbBeginTransaction
dbCall
dbEndTransaction
dbListColumns
dbListTables
dbListViews
dbNonQuery
dbQuery
encDecode
encEncode
fileCopy
fileCreate
fileDelete
fileListDir
fileMakeDir
fileMove
fileRead
fileReadLine
fileReceive
fileWrite
httpGet
httpPost
httpPut
httpUpload
jsonClose
jsonDOMGet
jsonDOMSearch
jsonOpen
sysExecute
xmlClose
xmlDOMGet
xmlDOMSearch
xmlOpen
zipCompress
zipExtract
zipScan
Formatters
String Formatters
Date Formatters
Math Formatters
File Formatters
Special Formatters
Software License
Search
xmlClose
Version 23.3.8698
xmlClose
Version 23.3.8698
Stop reading or writing an XML document.
Required Parameters
handle
: The handle of the specified XML reader.