Skip to main content

CData Arc

Share product questions and get support for CData Arc

  • 132 Topics
  • 246 Replies
132 Topics
ericbux
ericbux
asked in CData Arc
Major release upgrade hesitation

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 hundreds of connectors where I may run into issues.  Has anyone experienced issues like this when doing a major release upgrade?  I have a

1048
James B
6 months ago
John
JohnCommunity Manager
posted in CData Arc
Exciting New Reporting and Visibility Package for CData Arc!

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 integrations for maximum efficiency.  We would love to hear your thoughts on this new feature! Ho

1022
John
7 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
Connector which discards empty messages

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

603
lohith
7 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
Copying XML input into a Message header and passing through the XML input to the output

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

552
James B
7 months ago
C
Christophe KCollaborator
asked in CData Arc
How are you using views

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?

624
C
7 months ago
W
wnielsonApprentice
asked in CData Arc
HELP: Hs anyone used arc to ingest 278 files??

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.

333
lohith
7 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
httpGet Operation - behaviour on HTTP Status 4040 ?

(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 ?

585
James B
7 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
BUG: Deleting Source Connector breaks XMLMap

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 possible, then warn the user before the Source connector can be deleted

371
lohith
7 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
REST Allow ArcScript in URL?

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')] 

761
T
7 months ago
J
jussihiApprentice
asked in CData Arc
Find and replace CSV file columns based on translation table in CData Arc?

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 this in CData Arc, should I use the ArcScript or create a python-based program that exposes REST API…? The latter sounds a little too much for this simple o

734
R
7 months ago
M
mja311Apprentice
asked in CData Arc
Best way to format GraphQL Payloads

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 } } }Which fair enough is simple for my example, but realistic GraphQL queries are much more complex. Any suggestions on how to potentially work with this format in Arc? 

602
M
8 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
Convert a JSON string into XML within a Script connector using ArcScript?

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

591
James B
8 months ago
T
TonyLApprentice
asked in CData Arc
MySQL Connector - Clean up log files

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?

472
James B
8 months ago
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? 

422
E
8 months 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

972
R
8 months 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

754
James B
9 months 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

502
lohith
9 months 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.

502
T
9 months 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: 

591
James B
9 months 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?

513
James B
9 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
MySQL Connector: "Allow User Variables" - what does it do?

 

6553
R
10 months 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>

562
R
10 months 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

300
James B
10 months 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? 

391
James B
10 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?

724
R
10 months ago
Terms and ConditionsCookie settings