Skip to main content

CData Arc

Share product questions and get support for CData Arc

  • 115 Topics
  • 224 Replies
115 Topics
P
PradeepApprentice
asked in CData Arc
Prod Flag - EDIFACT Connector

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.

2
Chaitanya Sandra
22 days ago
Origin-AnthonyR
Origin-AnthonyRApprentice
asked in CData Arc
How to loop comma seperated values in XML node into multiple XML nodes with each value in?

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:  Any help would be appreciated. Thanks, Anthony.

3
Origin-AnthonyR
1 month ago
John
JohnCommunity Manager
posted in CData Arc
Exciting News: CData Arc Q3 2024 Version Release

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 performance improvements: We're dedicated to

0
John
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
Problem using Lookup

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 [consignmentno] FROM [woodside].[pallettrackduplicateprevention] WHERE [consignmentno] = @p1][2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+01:00 2 [3553|Q-Id] [EXEC|Parsed] Parameter: p1 = EPB0925[2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+01:00 3 [3553|Q-Id] [TCP |Send ] Send Begin - Length: 242[2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+

3
lohith
2 months ago
R
russell-jerseypostInfluencer
posted in CData Arc
TIP: Renaming files during a flow

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/TrackingEvent/p_uuid')]" /> <arc:set attr="output.header:e_country_code" value="[xpath('/Schedule/Results/TrackingEvent/e_country_code')]" /> <arc:set attr="output.header:c_carrier_name" value="[xpath('/Schedule/R

2
Chaitanya Sandra
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
Removing similar records from XML

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> </status> <status> <StatusID>1066</StatusID> <ReqDepot>183</ReqDepot> <ManifestDate>2024-07-05</Manifes

2
R
2 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
arc:enum Can it take a dynamic range?

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 :”

4
James B
3 months ago
R
russell-jerseypostInfluencer
asked in CData Arc
api.rsc/sendFile/ - Can I use it to release files?

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.

2
R
3 months ago
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

8
James B
3 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

2
John
3 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

3
lohith
3 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

2
James B
4 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?

4
C
4 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.

3
lohith
4 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 ?

5
James B
4 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

1
lohith
4 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')] 

1
T
4 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

4
R
4 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? 

2
M
4 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?

1
James B
5 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?

2
James B
5 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? 

2
E
5 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

2
R
5 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

4
James B
5 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

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

Badge winners

Show all badges
Terms and ConditionsCookie settings