CData Arc

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: 

Hi All,I’m try to setup the flow that receives file from a FTP server in multiply folders  and then send an email with the subject containing the sub folder name. The flow I've create is as per  below In the  Navis, a script, connector I've added the below script however I keep receiving the below messageFormatter [ subfolder_path ] failed in the evaluation of [subfolder_path]. The error was: The value of the attribute could not be accessed: The attribute does not exist.please can anyone guid me to a better solution or why I’m receiving the message.<arc:script>  <arc:set attr="output.header:subfolder" value="[subfolder_path]" />  <arc:set attr="output.filepath" value="[filepath]" />  <arc:set attr="output.header:email" value="[email_address]" />

I am working with an incoming EDI file where I use lookaheads to identify the correct loop. In my case, the EDI file contains the Service Level Loop (HL/HL03='SS') appearing twice. While I can successfully extract the first occurrence using the following XPath:xpath("HLLoop1[HL/HL03='SS']/MSG/MSG01")I attempted to retrieve the second occurrence using:xpath("HLLoop1[HL/HL03='SS'][2]/MSG/MSG01")Although this expression did not return an error, it did not extract the expected data either. Has anyone encountered a similar issue? What would be the correct XPath expression to extract both occurrences of the Service Level Loop? Any insights or alternative approaches would be greatly appreciated!

CData Arc supports cloud deployment through the Azure cloud platform via Azure Virtual Machines (VMs) and Azure Web Apps. You can follow our guide for both deployment options here: https://arc.cdata.com/kb/articles/azure-deployment.rst

What is the CData Arc system service level agreement for the API’s .  e.g. availability ratio, RTO/RPO

For the Email Send is there a solution for controlling the To: field dynamically with data coming into it from the workflow?Seems that Subject: and From: fields can be, but not much else. 

Hello,I am currently working on building certain JSON messages.For doing this I am starting with an XML message that has the desired structure and place the data into this XML. Then I use the JSON Connector to convert my XML into the JSON format.So far so good.Due to the fact that sometimes the data of a node does not exist, I would like to know, if there is an option in the JSON Connector that will automatically remove all nodes that are empty in the underlying XML.For example the following XML Structure shows that some fields have values and other do not:<?xml version="1.0" encoding="UTF-8"?><Items xmlns:json="http://arc.cdata.com/ns/jsonconnector" json:array="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">  <Item>    <field1>value1</field1>    <field2>value1</field2>    <field3></field3>    <su

Hey CData Community!We're excited to share the latest CData Arc update for Q1 2024, bringing innovative features that manyof you have been anticipating. Let's dive into what's new and start some discussions around these updates:  Enhanced User Role Granularity & Access Policies: We've upgraded user roles and access policies for better management and security. How do you see these changes impacting your workflow?   Service-Level Agreements (SLAs) for Connectors: With SLAs for connectors, you can now monitor transaction volumes more effectively. What are your thoughts on utilizing SLAs to maintain partner relationships?  

Hi,I am working on EDI 856(CSV to X12).Please help me on this issue.Wanted to generate multiple transactions set in single X12 fileEXAMPLE:ISA*...GS*...ST......SE...ST.....SE...GE...IEA...

How to remove the last line in flat file using Arc script ??The below script is to add the “END” on the last line but I need to remove the END which is present in the last line of a Flat-file??<arc:set attr="file.file" value="[filepath]" /><arc:call op="fileRead" item="file">  <arc:set attr="tmp.originalBody">[file.file:data]</arc:set></arc:call><arc:unset attr="output.data">[tmp.originalBody]END</arc:set><arc:unset attr="output.filename" value="940_[now()]" /><arc:push item="output" />

how to remove the first five lines in flat file using Arc script 

Hi.I have incoming invoice CSV files with invoicer’s ID as the only metadata of the invoicer. These are single-line csv files. Let’s call them “invoice.csv”.I have other single CSV file with all of our invoicers’ metadata (including the ID). This file has some 90+k lines. Let’s call this file “invoicers.csv”How can I enrich the invoice.csv file with the correct row from the invoicers.csv file so that the invoice.csv file would contain all the metadata of the invoicer in question?Also, one of the fields in the invoice.csv is a html link to said invoice. How can I download this file with CData Arc?

I have a flow where I need to create two csv files and email them using the Email Send connector.I’ve done these many times and it’s super easy...until now.  I need to create and email the first CSV then set a delay (Schedule Connector?) and use a tracked header value from the first part of the flow to create and email another CSV with data from a stored procedure.In other words, once the CSV hits the Input folder of the first Email Notify it sends the email and stops.  Nothing ever shows up in the Output of the Email Notify.I suppose I could use the After Send event to trigger the Schedule, but is their another way to send the first email and continue to follow the flow and send the next email.  The key to this is that I have a tracked header value that must remain through the entire flow, as it’s my stored procedures incoming parameter.Appreciate any input!

Hey everyone, We’ve just released the Q4 2024 version of CData Arc, and it’s packed with features designed to make managing your trading partners and building workflows even smoother. From a centralized partner management interface, to a revamped UI for quicker workflow creation, to improved connectors and routing capabilities—this release has something for everyone. Key Highlights:• Centralized Trading Partner Management: View and manage all partner connections, documents, and dashboards in one place, making onboarding and optimizing relationships simpler than ever.• Enhanced User Experience: A refreshed UI, built-in disk usage info, and new messageOps capabilities help you work more efficiently. Expect faster workflows, clearer visibility, and a more intuitive platform.• Improved Connectivity: XML Map interface upgrades, more flexible Workspace Send options, and Dro

Hello everyone,I’m curious about the security advantages of combining Intel Core M vPro technology with CData’s cloud data connectivity solutions. We know that Intel vPro is built with security features like Intel Active Management Technology (AMT) and hardware-based encryption, which offer enhanced protection for enterprise devices. But how does this integrate with CData's connectors, especially for cloud-based applications and databases?For instance, CData’s JDBC and ODBC drivers provide seamless connectivity to a wide range of cloud data sources. Using these in tandem with Intel security features could potentially streamline secure data access and reduce the risk of unauthorized access during data transactions.I’m particularly interested in how Intel’s built-in remote management and secure boot options could enhance the security of data connections when using CData’s cloud solutions. How do these technologies work together to ensure encrypted

ERP Implementation refers to the process of deploying an Enterprise Resource Planning (ERP) system within a business. ERP systems integrate and manage core business processes, such as finance, human resources, supply chain, and customer relationship management, into a unified platform.

Hi Team, I was calling files from XML map connector to do cross reference from Input values to pick the respective values from list. This function working fine, and from yesterday i am facing the below error “System error: Access to the path 'C:\Users\ligEDIAdmin\Documents\SCJ\SCJCode.xlsx' is denied”  Same function works fine in Production environment, but in Test system i am facing the issue, We have worked with all network / server team and there where no changes made with access / permission levels. Still i am facing the issue, could anyone please help me out by pointing what is to be done to fix this issue. 

How to get the log file from the folderC:\\ProgramData\\CData\\Arc\\workspaces\\[WorkspaceId]\\[ConnectorId]\\Logs\\Sent\\[Date]\\[MessageId]\\[LOG FILE NAME].mdnand send it by email after running the AS2 connector?I tried using the AS2 success connector linked to a "notify" or "send email" or "scripts"I tried in the AS2 connector in the Events tab in "Before send" to find the file and attach it to an emailI tried to read the .mdn file in batch mode and have the result in the output so I could create the attachmentall of them without success, is it possible to do this?

I’m using an Excel connector to pass a spreadsheet into a Script connector for further processing.The Excel input contains columns of the form:  A: B CIn the Script connector, I try to reference it in an xpath like this:  xpath([A:_B_C])But I get the “attribute does not exist” error. I need to deal with or escape that colon character somehow, I just haven’t been able to find where in the docs how to do that yet.Any suggestions?Thank you!

I’ve been using _log.info as a way to debug scripts. This makes log entries I’m wondering if it’s possible to insert log entries in the individual message logs? It would be more convenient to do it that way than going over to the application log every time I want to inspect the data. 

Hi, Where can we find the Changelog of the different Arc versions?

Hi, Original question:When creating a simple webhook and calling it using curl, the webhook returns an error about “application/x-www-form-urlencoded”.This is resolved by setting the correct Content-Type header to either application/json or application/xml as configured in the Connector. Follow-up question (am not able to update the title of this post...): Can the webhook return to the requestor immediatly with a 200 upon creating the Output message, so that the requester doesnt have to wait for the full flow behind the wehbook to complete?

Hi Team, I have a requirement, where i have a standard JSON body which need to be post every 10 mins to API endpoint , as response to post i will be getting the Orders payload from partner’s API. Need your expertise, help me to post this one JSON file over & over again to the API as input file.  below is the JSON body to be posted.  {    "app_id": "RDCSBY01"} 

Can anyone explain to me the difference in the two timeout settings in the SQL Server db connector advanced tab? 

When I use the EDIFACT connector for sending the outbound EDIFACT messages, there is option to enable to include Test Indicator, thus it include “1” as test indicator at UNB 11.UNA:+.? 'UNB+UNOC:2+ZZLINFOXSIP:ZZZ+9500SCJID:ZZZ+240913:0829+000000007++INVRPT++++1'UNH+0002+INVRPT:D:98B:UN' Once we move the code to Production environment, I have to disable the Test Indicator since this is Prod files, but the UNB11 dosen’t populated with “0”. UNA:+.? 'UNB+UNOC:2+ZZLINFOXSIT:ZZZ+9500SCJIDTEST:ZZZ+240913:1140+000000186++INVRPT'  à missing the Prod Flag “0”.UNH+121+INVRPT:D:98B:UN'  Please advise is there any option I could be able to populate the Prod Flag.