B2B Integration

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

96 Topics

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
3 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
3 months ago
P
PradeepApprentice
asked in CData Arc

If-Else Condition with arc:case

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

2
P
3 months ago
James B
James BEmployee
posted in CData Arc

Simulating a sleep in ArcScript

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 

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

Trigger flow using Webhook

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:

3
R
3 months ago
ericbux
ericbux
asked in CData Arc

Scripted Branch connector

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

1
ericbux
4 months ago
R
russell-jerseypostInfluencer
asked in CData Arc

Can a MySQL Connector Lookup create a new node in XML?

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.

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

MySQL Connector: Custom Query and Message Headers

Hi I have a complex MySQL query with several JOINs need to only fetch new data from the tables. I have read https://cdn.cdata.com/help/AZH/mft/Database-AC.html#only-process-new-or-changed-records but not sure how to apply this to a Custom Query, Can custom queries us data from the message header? If so I may be able to use the method James suggested at  

2
R
4 months ago
ericbux
ericbux
asked in CData Arc

EDI X12 payload octet-stream

I am setting up a new trading partner to send EDI X12 850 and they keep coming back to me saying “we received your file but it is not processed with octet-stream.  Please send as EDI-X12”.My X12 connector is setup and working just like the dozens of other trading partners.This is a screen shot of what they are sending me:I checked the Advanced settings on my X12 connector and didn’t see where the application/octet-stream is being set.  I tried adding payload=application/edi-x12 on my AS2 Extension map to no avail.Any ideas would be appreciated.

2
ericbux
4 months ago
C
Charlie SEmployee
posted in CData Arc

Using OAuth 2.0 in the Email Send and Receive Connectors

OAuth 2.0 Overview In today’s standards, OAuth 2.0 is becoming increasingly popular as a means to authorize users who are attempting to access a resource, be it a mail server, API endpoint or database. A common example of this shift is the deprecation of basic authentication in Exchange Online (Microsoft’s mail server for Outlook), which can be read about in more detail in Microsoft’s article, here.OAuth 2.0 is an authorization protocol and not an authentication protocol; a means of granting users access to a set of resources - in the case of what is discussed here, that resource would be a mail server.At a very high level, OAuth 2.0 can be summarized in the following steps: The connecting client acquires both a client ID and a client secret from the authorization server. The client requests to be authorized by the authorization server by providing their client ID and client secret. Additionally, any necessary scopes and a redirect URI are also provided. If the supplied credentials

6
I
4 months ago
M
MattMApprentice
asked in CData Arc

CData Arc - Mapping CSV with parent-child rows to flat CSV format

Hi all, I’m trying to create a mapping to translate a CSV format with parent-child rows into a flat CSV format. My source file is structured like this:Row Type Order number Customer name Total Cost Header 12345 John Smith $15.00 Row Type Item code Item name Cost Line 40123 5mm cable $5.00 Line 40124 10mm cable $10.00 Row Type Order number Customer name Total Cost Header 12346 Jane Lane $10.00 Row Type Item code Item name Cost Line 40124 10mm cable $10.00  Note that the actual file does not have headings, so looks like this:Header 12345 John Smith $15.00 Line 40123 5mm cable $5.00 Line 40124 10mm cable $10.00 Header 12346 Jane Lane $10.00 Line 40124 10mm cable $10.00  I am wanting to convert this to a flat CSV structure that combines data from the parent header and child line rows. So the above would be translated to:Order number Customer name Item code Item name Cost 12345 John

3
Ankit Singh
5 months ago
Matt S
Matt SEmployee
posted in CData Arc

Lookups in CData Arc

What are Lookups?Lookups describe a situation where you need to find a target piece of data, like an Account ID, but you only have a related public piece of data, like an email domain. You can reference some data store, like a database or SaaS platform, to “look up” the Account ID based on the email domain. If you’ve ever “looked up” the definition of a word in a dictionary, then you already understand the concept -- the spelling of the word is your starting public data (equivalent to the email domain), the definition of the word is the target data (equivalent to the Account ID), and the dictionary itself is the data store.Why are Lookups useful?Lookups solve critical problems that may arise when integrating external data (like EDI documents) into internal systems (like CRM or ERP platforms). When you integrate data into an ERP system, you may need to reference internal identifiers or private values like an Account ID, a warehouse ID, or a contract number. Inbound EDI documents will co

1
Ankit Singh
5 months ago
ericbux
ericbux
asked in CData Arc

Reading the MDN

We have a lot of manufacturers that we send X12 850 purchase orders to.  We don’t always receive a 997 and I am wondering if its possible to read and parse the MDN and extract the response confirming delivery.My goal is to confirm AS2 delivery and add an Email send connector to the flow and notify our purchasing department that the PO was received. Thanks

2
ericbux
5 months ago
C
Christophe KApprentice
asked in CData Arc

How do I add items in an array

I have following script: <arc:set attr="Files#1">[FilePath]</arc:set><arc:call op="xmlDOMSearch?uri=[FilePath]&xpath=/Items/File"> <arc:set attr="Files#[_index | add(1)]">SOME_FILEPATH\[xpath('FileName')]</arc:set></arc:call><arc:enum attr="archiveFiles" expand="true"> <arc:set attr="_log.info">([_index]) [_attr] -> [_value]</arc:set></arc:enum> Whatever I try, the enumeration only shows the first item.  If I add a arc:set="_log.info” in the arc:call, each item is logged, but for some reason it is not added in the array. The reason I want to add these files in an array is that I want to compress them all in 1 ZIP file.

2
C
5 months ago
James B
James BEmployee
posted in CData Arc

Mapping out to an EDI 856 (and HLLoops in general)

One of the trickiest types of documents to map against in the EDI 856, which makes frequent use of a segment loop called HL (Hierarchical Loop). HLLoops represent multiple elements that are part of a hierarchical structure at once. From the EDI standpoint, each HLLoop is treated like a sibling element, but the HLLoop is a representation of an element in a hierachy so two neighboring HLLoops can mean different things based on the values of HL01, HL02, and HL03:HL01 is the index of the loop from the top of the documentHL02 is the index of the immediate parent to this loopHL03 is the type of the loopLet's look at a simplified 856: HL*1**S~  <-- the root shipmentHL*2*1*O~  <-- the first order, child of the shipmentHL*3*2*I~  <-- the first item, child of the first order (index 2)HL*4*2*I~  <-- the second item, child of the first order (index 2)HL*5*1*O~  <-- the second order, child of the shipmentHL*6*5*I~ <-- the first item of the second order (index 5)HL*7*5*I~ <--

1
P
5 months ago
ericbux
ericbux
asked in CData Arc

Scripted flow cleanup

I was wondering if anyone had a good solution for purging files from all flow connectors.  Maybe a custom script where I could pass in WorkspaceId and a ConnectorId that would delete files from the Send/Receive directories.My initial thought, is it possible to delete files across all connectors within any given flow?I have a few CSV connectors that are used to download 5K+ rows, split them into their own file and pass the data into a SQL stored procedure.Because of the split, that single CSV is now a new XML file for each line.  As it travels down the flow I end up with 5K+ XML files in my Send/Receive directories.  Usually I get an Arc notification that the size of X directory has exceeded the recommended size..Right now, I use the interface to click Delete All from both Input/Output tabs to keep folders clean. 

3
C
5 months ago
ericbux
ericbux
asked in CData Arc

Calling SQL Stored Procedure from within XML Map

I don’t know if this is possible but I have a standard 850 map that I am able to use with all of our trading partners.  I am using the SQL connector to return the data of a simple Header/Detail table relationship.  Up until now, the data from the Detail table has always been sufficient for all of our current connections, but I have a new connection i’m setting up and they require additional data.Currently, I am creating POLoop1 > PO1and sending the following:PO101 linenumberPO102 QuantityPO103 Identifier (EA)PO104 PricePO105 (empty)PO106 Identifier (N4)PO107 UniqueIDThis new setup requires PID (which I have added) but they only need PID05 (item description).My question is: Is is possible to add some arc script within my loop where I can call a SQL stored proc and pass it the value of PO107 and map the result to PID05?Thanks

2
James B
6 months ago
ericbux
ericbux
asked in CData Arc

AS2 Message Integrity Check failure

Just received an error on the Input of my AS2:The Message Integrity Check returned by the server is incorrect. Expected: iPPnthXZ7ofwn1v8b6lzhhPhE+2ZYHp+aHDfRgJsI8c=; Received : hrROR/jpYl1Q7PKbG2tY4AHImdCALRS37NPEDiH+5go=This is the first time I’ve seen this error.  What I don’t know is - is this on my side or the trading partner?Anyone familiar?Thanks.

1
James B
6 months ago
James B
James BEmployee
posted in CData Arc

Batching UPSERT transactions in Arc through flow design

​Setting the Batch Input Size in a database connection can increase the performance of that connection (provided the data source itself supports batches), because instead of sending requests one at a time, a batch insert or batch update can commit multiple records in a single request.  Ordinarily, this cannot be used with the default UPSERT action for database connections. An UPSERT involves a query that first determines if the record exists so that new records can be INSERTed and existing records can be UPDATEd, but UPSERTs alternate SELECTs and INSERT/UPDATEs and cannot batched. If you were to be able to separate the requests into INSERTs and UPATEs, however, you could batch each types, and it so happens that there is a Lookup action for most database connectors. https://cdn.cdata.com/help/AZJ/mft/Database-Lookup.html If you execute this lookup step into a separate step in your flow, you can determine which records are inserts and which are updates, and separate them to batch them: A

0
James B
6 months ago
E
EdiSupportGirApprentice
asked in CData Arc

How I can get base64 files from XML file and send them with email as attachments

Hi, I have a case where receiving  XML files with base64 (e.g. PDF)files inside the file which ones do I want to send as attachments in an email with Email Send connector (Template mode)maybe someone knows what script could be used?XML example<?xml version="1.0" encoding="utf-8"?><ForwardingInstructions xmlns="urn:oasis:names:specification:ubl:schema:xsd:ForwardingInstructions-2" xmlns:dtd="http://dtd.riege.com/scope/shippingorder" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2">  <cac:DocumentReference>    <cbc:ID>523651</cbc:ID>    <cbc:DocumentType>comment</cbc:DocumentType>    <cbc:DocumentDescription> Transporter: Agile Logistics AS - BIL - Bil (Vei transport)</cbc:DocumentDescription>  </cac:DocumentReference>  <cac:DocumentReference>    <cbc:ID>126242</cbc:ID>    <cbc:Status>Docum

2
E
7 months ago
S
ShakilApprentice
asked in CData Arc

Importing PDF data into QuickBooks Online (QBO) with CData Arc

Is it possible to import PDF data into QuickBooks Online (QBO) with CData Arc? If so, can someone please provide a step-by-step guide?

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

How to use the UPSERT query?

 What should I put in the “”Perform this query to select the UPSERT key” box?

4
James B
7 months ago
James B
James BEmployee
posted in CData Arc

AS2 Tips: Getting your partner's SSL certificate and signing certificate on your own

One of the most common causes for AS2 connection errors is not having the correct certificates configured for your trading partner within Arc. In an AS2 connection, your partner’s SSL server certificate is validated against your system’s security settings to proceed with an SSL handshake, and their S/MIME certificate is used for the validation of signed messages and encryption of outgoing messages. Ordinarily, these certificates are exchanged as part of the setup of a new AS2 connection, but certificates are commonly replaced, and you may be left with a connection that is not working after an update from your partner. The following methods are not foolproof, but there are possible methods for obtaining these certificates without direct contact from your partner.  Obtaining the SSL Server certificate  This is straightforward - place your partner’s receiving URL in a browser:  If the URL resolves, click on the lock icon and locate the server certificate.   the certificate viewer will giv

0
James B
7 months ago
P
PukhrajChoudharyApprentice
asked in CData Arc

How to define a cross reference table or codelist in XML to X12  mapping?

How to define a cross reference table or codelist in XML to X12  mapping? Collect = CCPrepaid = PPPer Contract = DE

1
James B
7 months ago
RichardG
RichardGCollaborator
asked in CData Arc

Filename selector in new Branch connector fails

I started using the new Branch connector with an existing AS2 connector. The Branch connector will be used to save specific messages based on the Filename to a different folder.I've setup the Branch connector as shown in the image provided in the Help for the Branch connector.IF Filename matches glob CUS*.*But instead of the output being send to the provided File Connector to save the message in a different folder, the message is forwarded to the ELSE clause and forwarded to that attached connector.The log-file shows the following information (not really helpful at the moment):[2023-08-25T15:36:47.403] [Info] CUSDEC325-0000000000062014 is routed to File_SHPP2MEP_Test (which is the ELSE clause). [2023-08-25T15:36:47.403] [Info] Message CustomerAS2_TEST-20230825-153646575-eCIr is finalized. Name: CUSDEC325-0000000000062014, Type: Output, Status: Success, Message: , Processing Time: 16ms. [2023-08-25T15:36:47.403] [Info] Arc Version: 23.2.8606.0 [2023-08-25T15:36:47.403] [Info] System Ver

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

Badge winners

  • Product Expert
    TonyLhas earned the badge Product Expert
  • Product Expert
    Sagehas earned the badge Product Expert
  • Product Expert
    Ruppiehas earned the badge Product Expert
  • Product Expert
    ekanshdhas earned the badge Product Expert
  • Product Expert
    jacob fhas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings