CData Arc

How can I get this Sql Server dbQuery to work? The INSERT is completing fine, but I need to get the inserted identity PK and Arc is not picking it up.<arc:set attr="db.query"> insert into table (...) values (...); select SCOPE_IDENTITY();</arc:set><arc:call op="dbQuery" in="db" out="results"> ...Is there a better way to get the identity? (I have to use ArcScript, the upsert connector is not an option)

In the input there is a value “<N201>Germany GmbH & Co. KG</N201>”. After it is mapped it is “<Address>Germany GmbH & Co. KG Hahnstraße 70</Address>”. How can I set it up that special characters are still escaped after the mapping. Because now the next Json connector is failing because of the & character.

OverviewSometimes APIs return data to the connecting client in a page based format. This can happen when the requested dataset to be returned is too large for the API to return in one response, or it could be the way that the API administrator has built the API to return responses.For example, if an API request is sent to GET the total number of items in an order, and the total number of items is 500, the API might return the results in a series of 10 pages where there are 50 items per page. The client requesting the information would then have to issue 10 separate API calls to get each page. This behavior is often coined “pagination”.The REST Connector and the FlowPagination isn’t something that is natively supported within the REST connector however, it is typically possible for Arc users to develop a solution to accomplish this by use of some custom script within a script connector and the utilization of custom headers to hold the page numbers (or

How do I delete unused template files?

Let me explain the overall flow i am trying to achieve. The flow is exposed as rest service to client. Client will call the rest service to send a file to a specific location. Client will trigger the flow, there is a requirement where i need to call a rest service inside the flow . Client is passing the required data in headers and the same header values i need to set while calling the rest service. I tried adding rest connector but body is disabled. I am not able to send custom request body to a service through rest connector. can you please guide me how to do it. 

Hey CData Community! 👋Looking to strengthen data protection and compliance in your integration environment?Our latest guide, “How to Secure CData Arc (.NET / Windows Edition)”, walks through key security configurations to help safeguard your data and automate workflows confidently.Check out the full article here: How to Secure CData Arc (.NET / Windows Edition)

Dear Support ArcESB,We are using Arc 2023 Professional on Windows Server 2022 Standard. Our customer exchanges data with us via AS2.The customer has recently migrated their AS2 system to a new platform which uses HTTP Authentication requiring a username and password. The username length is 78 characters, and the password length is 81 characters, as shown in the attached image.Could you please verify if your program supports usernames and passwords of this length? We would appreciate your confirmation and any recommendations you may have.Thank you for your assistance.Best regards,Parinya  P.

Is it possible to create my own Operations that I can call via <arc:call>? Or simple reusable methods/functions using <arc:include> perhaps that can return data? Or?

I have a trading partner who’s sending EDI with a file extension (.xml) and a Content-Type: text/plain and they’re also sending EPCIS xml files which are also of Content-Type: text/plain.  I need to determine which files are legit xml/edi and route them accordingly.I use a script on my EDI files to add additional headers, but I don’t think this will work on the xml EPCIS files because they are not EDI.<!-- code I use to add additional headers to edi files --><arc:set attr="edi.File" value="[FilePath]" /><arc:call op="x12Scan" in="edi" out="edi"> <arc:enum item="edi"> <arc:set attr="output.header:[_attr]" value="[_value]" /> </arc:enum></arc:call><arc:set attr="output.filepath" value="[filepath]" /><arc:push item="output" />Since the EPCIS files are true xml, I feel like this will bomb on the op=”x12Scan”.  A

I am trying to use httpGet to retrieve binary files, then push them through via a Script connector: <arc:set item="httpGetInput" attr="url" value="[params.pdfUrl]" /><arc:call op="httpGet" in="httpGetInput" out="response"> <arc:set attr="output.data" value="[response.http:content]" /> <arc:set attr="output.filename" value="test.pdf" /> <arc:push item="output" /></arc:call>It downloads the file, and sends it through, however the file is garbled, I assuming this is a encoding problem somewhere.Downloading the files directly from the source URL, the files render fine.Said connector is inside an API Request, with Response content type set to “application/pdf”:There must be something I am missing.

I am new to arcESB and we have a basic requirement where we need to call a rest service, get the data in json format and same data i need to use to later while using smtp connector (filename need to be modified). I am unable to map the data, i tried using arcScript in event section of rest connector but it seems to be not working. Any suggestion will be really appreciated. thanks in advance. 

We are trying the map multiple fields in a XML (EDI) into one field in another XML in a XML Map connector. We use the implode formatter for this. But it isn’t working, we only get the first item. But we want all the NTE02 fields joined with a newline as separator. This is the script we use:[xpath("FunctionalGroup/TransactionSet/TX-00401-940/NTE/NTE02") | implode] Source XML:<FunctionalGroup>            <TransactionSet>        <TX-00401-940 type="TransactionSet">            <NTE type="Segment">                <!--Note                Reference Code-->                <NTE01><!--Warehouse                    Instruction-->WHI</NTE01>                <!--Description-->                <NTE02>PALLETS COVERED WITH STRETCH HOOD</NTE02>            </NTE>            <!--Note/Special            Inst

Is there a better way to check for null results from a dbQuery, I feel dirty for coming up with this: <arc:set attr="db.query">select null as something;</arc:set><arc:call op="dbQuery" in="db" out="results"> <arc:if exp="'[results.*]' == '<table></table>'"> <!-- handle null --> </arc:if> ...</arc:call> 

This works with a REST connector just fine: However with a SOAP connector it does not (fails with  _message specified in the formatter, does not exist): Both connectors do have the correct header payload. Both have Allow Script in Url checked. Any ideas what I am doing wrong?

I’m trying to deploy an SSIS package to my server, and receiving the error “file:FileService SFTP Client Error during operation 'DOWNLOAD': The specified directory could not be created” server side.This runs without any issues from my developer. The service account has access to the folder (I also tried running the package with my AD account and got the same error). I’m kind of running out of ideas where to look. Does anyone else have ideas where to look?

CData Arc supports cloud deployment on Microsoft Azure through Azure Virtual Machines and Azure Web Apps. Run CData Arc with the flexibility to choose between full control on VMs or simple management with Web Apps. You can follow our guide for both deployment options here: https://arc.cdata.com/kb/articles/azure-deployment.rst

Error:Hi everyone, New to the community, within our team we are responsible for a ARC server (CData Arc™ 2024 - 24.3.9159.0) and I am running into the following issue: “Connection open failed: [500] Unable to connect to databasename.database.windows.net:1433: System error: No such host is known” (Azure SQL)Strange thing is that it works normally, but just sometimes it doesn't. This connector has almost 6000 entries in the last 5 days, only 8 have this error.These 8 are 4 Messages, with a retry of 60 minutes and a retry count of 1. Making that these 4 messages were tried 2 times in total. Last time 1,5 hour prior to this post. Trying manual send and boom all messages processed.SQL Database show no health warning and I can't find any metric that would indicate a problem with the database. Connector type is a script.

I am interested in learning ARC Script for cdata arc and I am from non programming background,  Can you please suggest me any pre requisite (like any programming concepts should know )required before starting learning ARC Script 

Hi Team, I have requirement, where  I need to send back the response back to customer, Below is message we will be receiving from customer, via Webhook connector.    {     "transId": "PUTO300000308",     "whId": "OMEGA-TEST",     "ownerCode": "199501010666",      "jobType": "11",     "jobCode": "010000000408",     "status": "ACTIVE",     "eventAt": "2025-07-03 12:34:56",     "containerId": "00493460370000410856",     "jobGroupCode": "03072026"    }  The response customer is expecting are like below, {"transId": " PUTO300000308","status": "ok","message": ""}  I need pick the transId value from the received data and built the response back with status “Ok” to them. Please help to advice how I need achieve this.

The CData Arc Team is excited to announce our Q2 2025 release, with powerful enhancements to connectivity, visibility, and security! What’s New? The Q2 2025 release focuses on improving EDI metadata awareness, enhancing API integration, and reinforcing platform governance. Our overall goal with this release is to accelerate workflow design and give you greater visibility into your trading partner network. Key Highlights:  Enhanced EDI control: EDI workflows are now metadata-aware, allowing you to track and route documents based on information in document headers.  Improved REST API integration: Use Swagger doc imports to easily integrate with REST APIs.  Extended governance and security: We’ve added SAML 2.0 integrations with identity providers, extended RBAC, and

<arc:set attr="input.uri" value="[FilePath]"/><arc:call op="xmlOpen" input="input">  <arc:set attr="xml.handle" value="[handle]" /></arc:call><arc:set attr="xml.map:lastupdate" value="/Items/gtm_req_pr_details_ib_pr/lastupdate"/><arc:set attr="xml.map:till_date"     value="/Items/gtm_req_pr_details_ib_pr/till_date"/><arc:try>  <arc:call op="xmlDOMGet" in="xml" out="out1">    <arc:set attr="data.lastupdate" value="[out1.lastupdate]"/>    <arc:set attr="data.till_date"     value="[out1.till_date]"/>  </arc:call>  <arc:set attr="http.URL" value="https://api.com/purchaserequisitions?approvalLeftDate=[data.lastupdate]&approvalRightDate=[data.till_date]" />  <arc:set attr="http.header:name#" value="X-AUTH-TOKEN" /><arc:set attr="http.header:value#" value="xcxcxcxcdxcxcccccccc"/><arc:set attr="http.header:name#" valu

OAuth 2.0 Overview In today’s standards, OAuth 2.0 is becoming increasingly popular as a means to authorize users who are attempting to access a resource, be it a mail server, API endpoint or database. A common example of this shift is the deprecation of basic authentication in Exchange Online (Microsoft’s mail server for Outlook), which can be read about in more detail in Microsoft’s article, here.OAuth 2.0 is an authorization protocol and not an authentication protocol; a means of granting users access to a set of resources - in the case of what is discussed here, that resource would be a mail server.At a very high level, OAuth 2.0 can be summarized in the following steps: The connecting client acquires both a client ID and a client secre

Hi All,Sorry for the late response and recreating the  topic. The solution provide did to work as the heading info is no been added to the file. Not sure if this is because of the way I created the flows.   The file are received/collected from the FTP server and place into the folder on my server. Please would some assist with a possible solution. Thank you 

The first CData Arc update of 2025 is here! The Q1 2025 release brings powerful new capabilities to streamline trading partner management, expand connectivity, and enhance security. Here’s what’s new: 🔹 Enhanced trading partner management – Test workflows end-to-end before deployment to minimize integration errors.🔹 Expanded connectivity & formats – New XML Group connector and ZPL label support for seamless shipping label generation.🔹 Enterprise-grade security – Built-in 2FA and extended Arc Key Vault integration for enhanced data protection.🔹 EU compliance & hosting – Support for AS4, ENTSOG V4, ZUGFeRD, and GDPR-compliant EU hosting.🔹 Migration utili

Hi, We have an XML file that contains a node called /Items/delivery_header/delivery_line_item/serial_numbers and in that node we have a list of serial numbers separated by commas if there is more than one (e.g. 1 serial would just be XYZABC but 2 or more would be XYZABC,XYZDEF). Is there a way on the destination XML to create a loop that can iterate through the comma separated values and create XML nodes like the following: for a single serial number SerialNumber      ManufacturerVersion = XYZABC or for multiple serial number SerialNumber      ManufacturerVersion = XYZABCSerialNumber      ManufacturerVersion = XYZDEF I have got as far as the below in the XML Map designer, I assume that I need to use a Loop with the nodes under it, but not sure what to use to split the values out, populate the ManufacturerVersion and then repeat with the next value: