B2B Integration

Ask questions, get answers, and engage in discussions about B2B integration solutions from CData.

94 Topics

E
EdiSupportGirApprentice
asked in CData Arc

PDF Label Connector incorrectly returns data from xml (multi-line function not working)

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? 

1
James B
1 day ago
R
russell-jerseypostInfluencer
asked in CData Arc

Compare two XML files

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

2
R
2 days ago
ericbux
ericbux
asked in CData Arc

Attaching File to Email Send using template message type

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

4
James B
6 days ago
R
russell-jerseypostInfluencer
asked in CData Arc

div() or divide() with Xpath denominators

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/DefinitionOfGoods/TotalKilos) | divide(xpath(ConsignmentNode/DefinitionOfGoods/TotalHalf))]</weight>. The error was: Error parsing

2
lohith
7 days ago
T
tunghsApprentice
asked in CData Arc

Get system time ArcESB 2020 EDI

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.

2
T
29 days ago
R
russell-jerseypostInfluencer
posted in CData Arc

Tip: Document your Flows using Script Connectors

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

1
James B
30 days ago
W
Walter VApprentice
asked in CData Arc

ws:// Anyone?

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

3
James B
1 month ago
R
russell-jerseypostInfluencer
asked in CData Arc

MySQL Connector: "Allow User Variables" - what does it do?

 

3
R
1 month ago
R
russell-jerseypostInfluencer
asked in CData Arc

Split Connector Error: "Can't write content text here".

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>

2
R
1 month ago
James B
James BEmployee
posted in CData Arc

How to replicate the Lookup behavior of earlier versions of CData Arc (releases prior to 2023)

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

0
James B
1 month ago
R
russell-jerseypostInfluencer
asked in CData Arc

Is there a more efficient way to create an Azure Shared Access Signature?

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? 

1
James B
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc

Arcscript: How do I put a linefeed in an attribute?

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?

4
R
2 months ago
R
russell-jerseypostInfluencer
posted in CData Arc

How to Authenticate with Azure Service Bus - SOLVED

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

0
R
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc

How do I get Unix Epoch Time?

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

2
James B
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc

Mapping XML to JSON

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=

1
James B
2 months ago
B
bvbert1969Apprentice
asked in CData Arc

change destination folder depening on source folder

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 

2
B
2 months ago
A
abarrApprentice
asked in CData Arc

Header and Trailer on CSV

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

1
James B
2 months ago
B
blahmar1976Apprentice
asked in CData Arc

Issue receiving AS2 messages (ArcEsb)

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

1
James B
2 months ago
A
ambrosino94Apprentice
asked in CData Arc

Flow API custom headers

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 😬

1
James B
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc

Dynamically call different WorkspaceReceive connectors

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)

1
A
2 months ago
A
AndreaMassaApprentice
asked in CData Arc

Problem in mapping xmlconnector with file name.

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.

1
A
2 months ago
E
EdiSupportGirApprentice
asked in CData Arc

Get a filename part while mapping XML

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?

5
A
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc

Export Message/Transaction logs?

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 😃 

2
R
2 months ago
A
AndreaMassaApprentice
asked in CData Arc

XML Conversion Problem: Accented Characters (É) Result in � Symbol

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

2
A
2 months ago
John
JohnCommunity Manager
posted in CData Arc

New Features Alert: CData Arc's Q1 2024 Release is Here! 🌟

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?   Workspace-Specific Access Controls: Tailored access in different workspaces is now possible. We'd love to hear how you plan to implement this in your setup. Customizable Access Policies: This feature allows for detailed control over user permissions. What specific policies are you looking forward to setting up? SLA Implementation and Alerts: Keep track of tr

4
John
2 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings