CData Arc

We're thrilled to unveil the latest enhancements to CData Arc! Our Q3 version release brings a host of exciting features designed to elevate your workflow experience.1. Enhanced flow designer: Collaboratively build workflows by adding descriptive notes directly to the flow canvas. This feature enhances the platform’s usability and visual workflow design, fostering seamless collaboration.2. Improved admin REST API: Enjoy a smoother remote administration experience with support for standardized data types for date formats. Automate the administration of your Arc instance with greater ease.3. Enhanced SAP IDoc connector: Translate IDocs without connecting to the SAP Server, offering greater flexibility and a streamlined user experience.4. Advanced webhook connector: Gain greater customizability and the ability to push data items to downstream connectors in the workflow, supporting the creation of event-driven workflows within Arc.5. Continuous perform

CData Arc™ 2023 - 23.4.8789.0 I’m trying to use a SQL Server Lookup to determine if a matching record exists or notHere are my settings    If I use “Use NULL Value” I do not get the Lookup-consignmentno header at all.If I use “Use Empty String” I get an Error “Lookup: Field cannot be null”In the logs I get [2024-07-11T11:23:07.371] [Info] SQLCommand: SELECT `consignmentno` FROM `woodside`.`pallettrackduplicateprevention` WHERE (`consignmentno` = @p1); @p1='EPB0925'[2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+01:00 2 [3553|Q-Id] [EXEC|Parsed] Executing query: [SELECT [cons

Sometimes I find I need to find files passing through a flow based on their content.To help with this, I grab some useful data and rename the file as it passes through the flow.These I can use the search function in the Input and Output connector tabs. <arc:set attr="xml.xpath" value="/" /><arc:set attr="xml.uri" value="[Filepath]" /><arc:call op="xmlDOMSearch" in="xml" out="result"> <!-- xpath is a context sensitive function in arcscript. If an xml document is loaded in a search, xpath will return the name of a child relative to the search result --> <arc:set attr="output.header:e_id" value="[xpath('/Schedule/Results/TrackingEvent/e_id')]" /> <arc:set attr="output.header:p_uuid" value="[xpath('/Schedule/Results

Given a file like <?xml version="1.0" encoding="utf-8"?><statuses xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <status> <StatusID>1056</StatusID> <ReqDepot>183</ReqDepot> <ManifestDate>2024-07-05</ManifestDate> <DeliveryDate>2024-07-08</DeliveryDate> <ConNo>0000105</ConNo> <VigoID>0</VigoID> <TrackingCode>1831110000105</TrackingCode> <PalletID>1831110000105-02</PalletID> <StatusCode>DSO</StatusCode> <StatusTime>16:37:09</StatusTime> <StatusDate>2024-07-05</StatusDate> <Notes /> <PODName /> <PODTime>16:37:09</PODTime> <PODDate>2024-07-05</PODDate> </

In a Script connector, based on a value I’ve calculated earlier in the script (numberofpallets) , I need to repeat an XML structure multiple times. The only thing that changes is the <PalletID>I’m trying this <arc:set attr="output.data"> <arc:enum range="1..[output.header:numberofpallets]"> <OrderStatusUpdate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <EventTime>2024-07-03T13:03:00.0000+01:00</EventTime> <OrderNo>200766</OrderNo>... <Longitude>Not Available</Longitude> <PalletID>[_index]</PalletID> </OrderStatusUpdate> </arc:enum></arc:set> But get the error “Invalid range, e.g of valid ranges are 1..20, a..z, A..z, z..a etc :”

HiI have order files coming in which are named <ordernumber>.xmlBut I need to hold them until they are triggered by another real world event.I am thinking of fetching them and then holding them in a connector with Automation Send turned off. Separately, I have status files coming in which I can use to trigger the release of the order file. I’ll inspect the status file and if it contains a certain status I can grab the <ordernumber> from the status file. Can I use api.rsc/sendFile/  to release a file which is queued in a connector by name? Is there a better way? I don’t really want to manage it through a database table.

I am still running Arc Version 23.3.8725.0 and want to upgrade to 24, but I am hesitant.  There’s been a lot of upgrades to the UI and I’m concerned about my workspaces blowing up - as I have them all carefully laid out for ease of use.Another concern I have is deprecated script functions.  For instance, I use the After Send events on dozens of connectors to trigger other flows the “old fashion way”<arc:set attr="target.ConnectorId" value="SOME_CONNECTOR" /><arc:call op="portReceiveFile" in="target" />From what I understand, this method will not work in the latest release.  This has been replaced with a more secure token-based approach:<arc:call op="api.rsc/receiveFile?" ConnectorID="SOME_CONNECTOR" httpmethod="POST" authtoken="admin:xxxxxxxxxxxxxxx" />I have so much ArcScript written I’m concerned there are other places throughout

Hey everyone!  We are thrilled to introduce the new Reporting and Visibility Package for CData Arc! This powerful feature, previously available only on our enterprise tier, is now accessible as a standalone package.  Here is what you can expect with this new package:  • Enterprise-Level Reporting: Generate detailed reports on B2B data exchange activities, including workflow performance, transaction volumes, and expected SLAs per trading partner. Gain valuable insights into your integration health. • Scheduled Reporting: Automate report generation and delivery, ensuring timely access to critical information for stakeholders across your organization. • Customizable Dashboards: Visualize key B2B gateway metrics on customizable dashboards. Monitor trends and identify potential issues proactively.  This package empowers you to make informed decisions based on real-time data, optimizing your B2B integra

Is there a way to discard an empty message?I have a misbehaving HTTP endpoint which is causing me to get intermittent empty messages going through the flow.These end up clogging up the logs.It would be good if I could detect empty messages in the flow and discard them before they affect anything downstream

Hi I need to pass some XML through an XMLMap connector, but I also want to preserve the original XML input, for later use.My thought was to do this in a script before it hits the XMLMap But I don’t know how to copy the Script connector input, straight out to the output copy the Script connector input into a message headerThoughts

We have a workspace for each customer we have and there we mostly do a mapping from their interface messages to our own format.  We are not using views, but I am thinking of starting to use them to make a difference between the incoming and outgoing flow to have a better overview. Are you using views, and yes, how are you using them?  Can you also move connectors from 1 view to another view?

I have spent hours spinning my wheels on how to process an x12 278 and don’t even know where to start. My brain is fried so I really don’t have more details than that.

(Title should read 404 not 4040) HiIf I use <arc:call op="httpGet" in="http"> , will a 404 response raise an exception which I need to catch or can I check the http:statuscode ?

HiI’d like to file a bug report for CData Arc™ 2023 - 23.4.8789.0I have an XML Connector (PrepareForJSONConversion) which was originally created using the output from one connector (MapLorealIFCSUMToET) as an Source File.That source connector was no longer needed so it was detached and then subsequently deleted at a much later date.Now the mappings in the XML Connector have gone.I have no idea if the connector is still performing the expected mappings   I can also no longer export the XMLMap connector. Expected Operation:not lose mappings if preserving mappings is not

HiIn the REST Connector, under Advanced, there is the Option “Allow ArcScript in URL”. I have two questionsDoes this also apply to the Access Token URL when using OAuth2.0 ? Would it support dynamic endpoints and formatters like this[Vault('ENVIRONMENT') | equals('TEST', 'https://test-api.domain.com/api/SendTracking', 'https://api.domain.com/api/SendTracking')] 

Hi,I have a flow and would like to take in and forward a csv file in said flow. In the flow, the end product should however have the 2nd column values translated. Say we have a python dict for translations:translations: Dict[str, str] = { "08.0": "S", "08.1": "O", "08.3": "S", "08.4": "O", "08.6": "S3", "09.0": "T", "10.5": "LS", "10.6": "LS"}What I would like to do would be to check each row’s 2nd column if a key from this dictionary is present in the said 2nd column (substring, doesn’t have to be 100% match), and then change the row so that the 2nd column would be rewritten to the value of the key found from the translation dictionary.If the row’s 2nd column’s text doesn’t match to any of the dictionary keys, the row should be omitted completely. I can do this really easily in Python. But how can I achieve

I’m working with a few different GraphQL endpoints where are becoming much more common it seems in B2B applicaitons. While GraphQL still uses just REST, formatting payloads in Arc is a bit difficult other than just using plain text and script port:For example:https://shopify.dev/docs/api/admin-graphql/unstable/queries/order?language=cURL GraphQL looks like: query { node(id: "gid://shopify/Order/148977776") { id ... on Order { name } }} but to support this in Arc, I need to use a script port with a string of: {"query": "query { node(id: "gid://shopify/Order/148977776") { id ... on Order { name } } }Wh

How do I convert a JSON string to XML in ArcScript / Script connector?

I have the files going into the connector every 10 mins and that create a ton of logs in the Input tab.I already have the Save to Send Folder and Log Messages disabled for the MySQL connector but it is still taking up disk space.  what would be the best way to handle the clean up process for the MySQL Connector besides the Cleanup Option in the Advanced settings?

Hello,A PDF file was made from the XLSX document. Then I created a PDF template with form fields (Adobe Acrobat), using the “Text field” function Multi-line. By filling in the form manually, the text in the field moves to a new line, but the text taken from the XML doesn't move to a new line. Why the Multi-line functionality doesn't work in CData Arc? 

HiI would like to compare two XML files for differences.Here’s my use case.I create an order via an API and can get the entire order back in the response.I will store that order in a database table.Later, I will poll the API again and fetch the latest details of that order.I can do a quick check for overall changes using a hash, but I will need to know what changes if they latest and stored order differ. thanks in advance

In my main application, I started using Arc to send automated emails by writing a simple XML file to a folder that Arc monitors.  I have a case where I am mapping the XML to an Email Send connector (using template mode) and I need to attach a PDF to the message (which was already uploaded to the server).I have the path to the file saved in SQL and I can add the path to my XML file.  My question is, how can I configure the Email Send connector to “attached” the file (assuming the path is a node in my XML)?  Right now, all I can do is reformat the path into an http link and add it to the body. Thanks

Is is possible to pass values retrieved using xpath() into the div([value]) or divide([value]) Math formatters? I want to do something like this in an XML Map connector [xpath(ConsignmentNode/DefinitionOfGoods/TotalKilos)  | div(xpath(ConsignmentNode/DefinitionOfGoods/TotalFull)| add(xpath(ConsignmentNode/DefinitionOfGoods/TotalHalf)) | add(xpath(ConsignmentNode/DefinitionOfGoods/TotalOversize))))]!--endfragment>!--startfragment>  which in pseudo code is    Weight = Total Kilos / (Full + Half + Oversize) Things like “….| div(2)” work, but I can’t seem to get it to work with values from other parts of the message. Even simplifying to [xpath(ConsignmentNode/DefinitionOfGoods/TotalKilos) | divide(xpath(ConsignmentNode/DefinitionOfGoods/TotalHalf))]gets the same error:Formatter divide failed in the evaluation of <weight>[xpath(ConsignmentNode/Definit

Dears,I’d like to ask for your help how to get the current system time using Script connector?So far, I tried to use:<arc:set attr="timestamp" value="[utcnow()]" /> <arc:set attr="timestamp" value="[now()]" />But I got the error saying this:Execute 'RSSBus.RsbOps.RSBFunctions.now' function failed: The function 'now' could not be found. What is the correct format? I m using ArcESB 2020 EDI.

I find it useful to document my flows using a Script connector as follows: