Getting Started
Quick-Start Guide
Installation and Configuration
Starting the Server
Windows
Java
Cloud Marketplaces
How to Upgrade
Administration
Profiles Page
Settings Page
Global Settings Vault
Single Sign-On
User Management and Roles
Status Page
Clustering
DMZ Gateway
Importing and Exporting
Reports
Separate API Endpoints
Security Best Practices
Architecture
Glossary
Release Notes
Current Release (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
Batch Create
Batch Merge
Batch Split
Branch
CData
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
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 Designer
Using the Expression Editor
Conditionals
Advanced
Virtual Nodes
XML Attributes
XML Match [Deprecated]
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
Send/Receive Configuration
SharePoint [Deprecated]
WebDAV
EDI
EANCOM
EDIFACT
HL7
HL7 MLLP
IATAPADIS
PDF Label
PIP
TRADACOMS
VDA
X12
Database
Database
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Database [Deprecated]
DB2
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
DB2 [Deprecated]
MySQL
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
MySQL [Deprecated]
Oracle
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Oracle [Deprecated]
PostgreSQL
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
PostgreSQL [Deprecated]
SQL Server
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
SQL Server [Deprecated]
SQLite
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
SQLite [Deprecated]
Other
Amazon Marketplace
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Submit Vendor Order Ackowledgement
Submit Vendor Shipment Confirmations
Submit Vendor Payments
Update Inventory
Advanced Configuration
AMQP
Apache Kafka
BigCommerce
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Databricks
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
DataRobot
Dynamics 365
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Dynamics 365 Business Central
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Exact Online
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
FHIR
Setup
Lookup
Select
Execute Stored Procedures
Advanced Configuration
IBM MQ
Infor CloudSuite Industrial
Magento
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
MQTT
NetSuite
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Odoo
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
QuickBooks Online
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Sage Intacct
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Salesforce
Setup
Upsert
Lookup
Select
Upload
Download
Execute Stored Procedures
Advanced Configuration
SAP IDoc
ShipStation
Setup
Lookup
Select
Execute Stored Procedures
Create Shipping Label
Advanced Configuration
Shopify
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Snowflake
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Square
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Stripe
Setup
Upsert
Lookup
Select
Advanced Configuration
Tally
Setup
Lookup
Select
Execute Stored Procedures
Export Report
Advanced Configuration
Wasabi [Deprecated]
WooCommerce
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Zoho CRM
Setup
Upsert
Lookup
Select
Execute Stored Procedures
Advanced Configuration
Zoho Inventory
Setup
Upsert
Lookup
Select
Execute Stored Procedures
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
Back Up 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
httpReceive
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
jsonClose
Version 22.0.8473
jsonClose
Version 22.0.8473
Stop reading or writing a JSON document.
Required Parameters
handle
: The handle of the specified JSON reader.