CData Arc

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: 

Is there a way to conduct a WebSocket connection and exchange in Arc?  Maybe something that can be done in ArcScript?

I am creating an XML message using a Script connector:<arc:set attr="output.filename" value="xmltriggerfile_[guid()].xml" /><arc:set attr="output.filepath" value="[filepath]" /><arc:set attr="output.data"><?xml version="1.0" encoding="UTF-8"?> <Schedule> <startDateTime>[_|now()|dateadd('day',-1, 'yyyy-MM-dd 00:00:00')]</startDateTime> <endDateTime>[_|now()|dateadd('day',-1, 'yyyy-MM-dd 23:59:59')]</endDateTime> <Results></Results></Schedule> </arc:set><arc:push item="output" /> This is then fed into a MySQL Lookup Connector which results in the following message <Schedule> <startDateTime>2024-03-11 00:00:00</startDateTime> <endDateTime>2024-03-11 23:59:59</endDateTime> <Results> <TrackingEvent> <e_updated_at>2024-03-11T00:03:25.0000+00:00</e_updated_at> <e_shipment_id>20167856</e_shipment_id> <s_uuid>

In earlier releases of CData Arc the Lookup connector / Lookup action of Database connectors had a fairly simple interface to it. You can configure a single query to select a single column from a table in a database, and output the result of the lookup in a specified XPath in the XML, like so:  Simply put, if the Input file is: <Items> <Record> <Name>James</Name> </Record></Items> The output file creates the result in a neighboring element:<Items> <Record> <Name>James</Name> <ID>0</ID> </Record></Items> In the 2023 release of CData Arc, a significant upgrade was provided to the Lookup action in a  database. You can now select multiple columns in a single select statement, expect multiple results, and the experience is backed by an updated designer that allows you to build the query without having to hardcode table and column names:  This new format is objectively more de

I have a flow which pulls rows from MySQL, formats them into JSON messages and pushes them to Azure Service Bus.There’s a step in the flow which creates the necessary signature for the REST POST to Azure Service Bus: But the SAS Token/Signature header is not dependant on the message.I only really need to do it once and make sure it is valid for long enough - at the moment I make it valid for a week.But my flow is calculating it for every row/every message. Is there a way to calculate it once (say for each time I run SELECT in the MySQL connector) and have it used repeatedly by PublishDirectToServiceBus? 

I want to do something like this <arc:set attr="scope">[encodedurl]\n[expiry]</arc:set>  I have tried using a multiline arc:set but without any luck<arc:set attr="scope">  [encodedurl]  [expiry]</arc:set> Any ideas?

Use this script before your REST connector <!-- %3A etc must be uppercase! --><arc:set attr="encodedurl">https%3A%2F%2Fyour-sb-resource-name.servicebus.windows.net%2Fyour-topic</arc:set><arc:set attr="expiry">[now(unix)|add(604800)]</arc:set> <!-- add a week --><arc:set attr="scope">[encodedurl]\n[expiry]</arc:set><!-- Encode using HMAC --><arc:set attr="encIn.data" value="[scope]" /><!--<arc:throw code="x" desc="[encIn.data]" /> --><arc:set attr="encIn.format" value="HMAC" /><arc:set attr="encIn.hmackey" value="[azureprimary.key]" /> <arc:set attr="encIn.hmacalgorithm" value="SHA" /><arc:set attr="encIn.hmacbits" value="256" /><arc:set attr="encIn.outformat" value="BASE64" /><arc:call op="encEncode" in="encIn" out="result"> <!-- setting the output file data to be the encoded data returned from the operation --> <arc:set attr="output.hashb64">[result.encodeddata]&lt

In PHP I can use ‘U’ format. How do I do this in Arc Script?So far I’ve got <arc:set attr="expiry">[utcnow() | dateadd('day', 7) | todate('U')]</arc:set> But ‘U’ is not recognised, and I getError:Formatter todate failed in the evaluation of [utcnow()|dateadd('day', 7)|todate('U')]. The error was:Input string was not in a correct format.Value: 2024-02-20T11:07:09+00:00Parameters: U

HiI’m trying to convert this file to JSON.<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Sheet1> <Country_code>AC</Country_code> <field_1 xsi:nil="true" /> <field_2 xsi:nil="true" /> <Year>2013</Year> <field_4 xsi:nil="true" /> <Month>1</Month> <field_6 xsi:nil="true" /> <Days>1</Days> <Description>New Year's Day</Description> </Sheet1> <Sheet1> <Country_code>AC</Country_code> <field_1 xsi:nil="true" /> <field_2 xsi:nil="true" /> <Year>2013</Year> <field_4 xsi:nil="true" /> <Month>3</Month> <field_6 xsi:nil="true" /> <Days>29</Days> <Description>Good Friday</Description> </Sheet1> <Sheet1> <Country_code>AC</Country_code> <field_1 xsi:nil="true" /> <field_2 xsi:nil="true" /> <Year>2013</Year> <field_4 xsi:nil=

Dear all, I have a ftp connector that is reading from multiple folders/subfolders and transferring data to a local server using an sftp connectorI would need to either be able to set the destination folder in my local server depending on the remote source folder or to put everything in the same folder but renaming the file in such a way I can understand from where they were coming from Currently the only way I found was to use several correctors (one for each folder), but I am doing to many connections to the server and using too many  connectors for my license Thanks 

I need to generate a CSV file with a header and trailer record, not column headers.  What is the best way to accomplish this?

hi, Dear Team, I am in the process of setting up an AS2 link between us and our partner but my partner cannot send us the message. For our part, sending messages to the partner works well but it is impossible to receive their messages.I have no logs on ArcESB and my partner thinks that the problem comes from us.We have traffic on our partner's port but we have an error like: 'RST,ACK'Looks like the partner is rejected.On the partner’log :disconnection indication         [reason="Error 0 (0x0)"] [origin="0"].My partner can do a telnet our AS2 server successful. Could you help me please Best Regards,BL

I've set up a flow that interacts with other services using the REST connector. From this flow I've created a Flow API by multi selecting the entire flow, right clicking it and selecting the API settings option. Inside the flow I extract a response header from one of the REST requests respones I receive in the flow and I want that value to show up as an output header of the entire Flow API response whenever this service gets called from the outside. Right now I only can see the default response headers. I've read and search the documentation pertinent to these elements but I haven't found out how I can create and parse custom response headers for the Flow API and if anyone knows how to do that, your help will be immensely appreciated 😬

I have Workspaces A, B and SWorkspace S (for ‘shared’) is a sort of utility or library workspace.My plan is for Workspaces A & B to set a message header e.g. _message.header:callingFlow in Event:BeforeSend and then use WorkspaceSend to call the WorkspaceReceive in S. S then needs to respond back to the correct calling Workspace.Can a WorkspaceSend in S dynamically call WorkspaceReceive in A or B based on  _message.header:callingFlow ?Or do I need use maintain a series of Branches (we could have many more calling workspaces in the future)

I'm using an xmlmap connector to create an insert into a slq table. everything works correctly, I recently had to add a field for each record I insert that must contain the name of the file I'm importing (which is the same name as the output mapping xml file for the slq connector)There is no way I can create the mapping via the script. I searched for examples and other topics, I use this simple command <arc:set attr="result.text">[Filename]</arc:set>The error in the log i have is:The value of the attribute could not be accessed: The attribute does not exist.I have no indication of the reason and I have already made many attempts, any suggestion or idea is welcome, thanks in advance for any help you wish to give me.Best Regards.

Hello,I need to get a specific filename part value while mapping XML to the desired structure in the XMLMap connector. F. ex. I need to extract ‘1234’ part from a file name 1234_abcd.xml.I have tried to write an expression in the Expression Editor: [getfilename(substring(0, indexof(filename(), "_")))]It does not work and I am not sure that is wrong.Any ideas? Maybe there are even better solutions?

Is there a way to export the message or transaction logs from /logs.rst#messages or logs.rst#transactions ?I want to analyse traffic so I can determine a maintenance window for the best time do upgrade cData Arc I’m sure with a bit of AI magic cData Arc could even suggest one 😃 

Greetings everyone.I have a problem using a flat file connector, which I use to convert a fixed length .txt file to xml. the conversion is successful, but the characters present that have accents are converted with the symbol � in the resulting xml. Are there any settings or workarounds to avoid this?address in the .txt file → 3 AVENUE DES SPÉLUGUESaddress in the xml file → 3 AVENUE DES SP�LUGUESThanks in advance to anyone who can help me

Dear All, I have a business logic, where i need to select value for RSN field , based on below Condition  IF  TypeCode = WriteOff  then   {       if  RsnCode = “1004” then          Rsn = “925”      elseif RsnCode = “1006” then         Rsn = “200”      elseif RsnCode = “1003” then         Rsn = “935”    }ElseIf TypeCode = WriteOn then  {       if  RsnCode = “1004” then          Rsn = “950”      elseif RsnCode = “1006” then         Rsn = “250”      elseif RsnCode = “1003” then         Rsn = “935”    } to achieve i tried to add the arc:case within the If condition as below,  <arc:if exp="'TypeCode'=='StockWriteOff'">  <arc:select attr="RSNCode">  <arc:case value="1006">    <arc:set attr="Rsn" value="200"/>  </arc:case>  <arc:select attr="RSNCode">  <arc:case value="1004">    <arc:set attr="Rsn" value="925"/>  </arc:case>  <arc:select attr="RSNCode">  <arc:case value="1003">    <arc:set attr="Rsn" value="935"/>  </a

As of the publishing of this entry, there is nothing inherent in ArcScript that performs the equivalent of a sleep or delay - all commands in ArcScript are executed immediately.  In most cases, it is desirable to execute scripting operations immediately, but there may be times when a sleep between calls would be useful (for example, when interspersing calls to an API that may be rate limited). In that situation, you can effectively create a delay in ArcScript through use of the sysExecute operation, which allows for the execution of external processes on the machine.  On a Windows environment, for example, you can call out to a batch file which itself implements the delay: <arc:set attr="sys.Name" value="C:\\ProgramData\\CData\\Arc\\Sleep_2s.bat" /><arc:call op="sysExecute" item="sys" /> In the batch file itself, you can implement your own code for a delay, such as:timeout 2 

Hi I want to trigger a simple flow using a webhook. When I call it via PostmanPOST /connector/AtlasTrackingToServiceBus/Webhook1/webhook.rsb HTTP/1.1Host: jpREDACTED01:80XXContent-Type: application/xmlAuthorization: Basic RGF0-REDACTED-5eTFnContent-Length: 13<root></root>I’m not interested in the message body, I just want to trigger the flow I can see the Webhook being triggered and that looks SUCCESSful. The Webhook flows into a MySQL Connector, but the MySQl Connector reports that the message is not “Finalised” [2024-01-08T11:38:56.632] [Info] Arc Version: 23.3.8698.0[2024-01-08T11:38:56.632] [Info] System Version: Microsoft Windows Server 2022 Standard[2024-01-08T11:38:56.632] [Info] VM Version: 4.0.30319.42000[2024-01-08T11:38:56.632] [Error] The message Webhook1-20240108-113856335-cK_v is not finalized.[2024-01-08T11:38:56.632] [Info] Message Webhook1-20240108-113856335-cK_v is finalized. Name: Webhook1-20240108-113856335-cK_v.xml, Type: Input, Status: Error, Message:

I am using the Copy connector to make a copy of all EDI 810 for a trading partner and sending them to another workspace where I need to find a group of 200 possible unique matches and route them to another trading partner.  As you can see in the screen shot below, I know what file name(s) to look for and therefore began this new flow using the Branch connector.  The values I’m looking for in the filename will always match a specific pattern.  However, the branch connector is going to be MASSIVE if I manually add 200 possible filename patterns. (this image shows only 6)Besides being tedious, this method will work but I am wondering is there a way to script this?  Regardless, I will still be hard-coding 200 filename prefixes.  Thanks

My lookup looks like this `/Items/tracking_events/parcel` node does not exist. Only /Items/tracking_events existsWhen I run the connector I don’t get a parcel or a barcode node.I have also tried /Items/tracking_events/parcel_barcode.Does the XML node have to exist in the incoming message? I can extract the barcode to a message header okay.