Skip to main content

CData Arc

Share product questions and get support for CData Arc

  • 139 Topics
  • 265 Replies
139 Topics
R
russell-jerseypostInfluencer
asked in CData Arc
SQL Connector: Update a processed_at column with the current time

I’d like to do this Will it work? I get an error ”Error parsing Date value [now()].”

1172
James B
C
Christophe KCollaborator
asked in CData Arc
Possible to get element name via xpath

Is it possible to use the xpath formatter to get the name of the current element?Currently I am interested to get the name of the root element and get the content of an attribute on said element.

3784
James B
James B
James BEmployee
posted in CData Arc
Calling VBScript from within CData Arc (Windows)

The sysExecute operation in ArcScript can be used to call processes on the local system as long as you have access to the process, and this includes VBScript files that you create yourself.  sysExecute To call a VBScript, you’ll want to use cscript as the name of the process to execute, and pass the path to the vbs file as an argument. If there is whitespace in that path, you’ll want to include quotes around the full path so that the path is passed as a singular argument, e.g.:<arc:set attr="sys.Name" value="cscript" /><arc:set attr="sys.Arguments" value='"C:\\Program Files\\CData Arc\\www\\bin\\test.vbs"' /><arc:call op="sysExecute" item="sys">  <arc:set attr="output.data" value="[sys.sys:output]" />  <arc:set attr="output.filename" value="results.txt" />  <arc:push item="output" /></arc:call> NOTE: This script returns the output of the vbs as a file output of the Script connector. If you just want to trigger the vbs, it is not necessary to re

540
James B
W
Walter VApprentice
asked in CData Arc
fileReadLine Example Scripts

Does anyone have any example Arc script that uses the fileReadLine operation to walk through an input file, parsing text line-by-line?

1794
R
R
russell-jerseypostInfluencer
asked in CData Arc
Can I use ArcScript in the Notify Connector?

I have a REST Connector.On Error, I would like to Notify admins.I’d like to include the body of the Response in the email message. The documentation for the Notify connector says you can use ArcScript. But it doesn’t seem to do anything: The email I get isFile ES501_JE501_IN323078978944_ITMREF_20230720221100_20230720224809_47c0ddca-729b-43a6-833d-4466c9d422b11.json was routed to notification connector Notify2.<arc:set attr="in.file" value="[filepath]" /> <arc:call op="fileRead" in="in" out="out" > <!-- Here is where you can access the content of the file via the 'file:data' param. --> <arc:set attr="output.data" value="[out.file:data]" /> </arc:call>We attempted to send this to Atlas[output.data] How do I use ArcScript in the message?

751
James B
R
russell-jerseypostInfluencer
asked in CData Arc
Does %header:% work for the Batch Merge Connector

When I use %Header:my-header-id% in the Btach Merge connector, I just get files called “.xml”Does this work?

806
R
R
russell-jerseypostInfluencer
asked in CData Arc
Getting an Error when Exporting a Workspace

 Any ideas?It doesn’t matter whether I choose “Export all...” or “Export Sensitive….”

782
Ankit Singh
R
russell-jerseypostInfluencer
asked in CData Arc
What's is the syntax for the Branch connector's "In" operator Match Value?

Is this correct? 

511
S
R
russell-jerseypostInfluencer
asked in CData Arc
Dynamic paths on File Connector

I need to pick up from a different path each day, so I need to have paths like //SERVER/PathToRoot/ddmmyyddmmyy should be today’s date I see I can use %Header:xxxx% but I think that will only work for sending out file, not collecting files.Is there a way to set a Header when collecting files? Are there any examples using a script and fileListDir ?

1221
A
R
russell-jerseypostInfluencer
asked in CData Arc
SQL Server connector " Unable to retrieve columns "

I’m seeing this in my logs [2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 2 [45|Q-Id] [META|Schema] Executing column schema query: [Shipment][2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send Begin - Length: 360[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send End.[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]DataIn, Length: 337[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send Begin - Length: 986[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send End.[2023-07-10T16:25:14.632] [Info] [DRIVER] 2023-07-10T16:25:14.632+01:00 3 [Connection: 45]DataIn, Length: 176[2023-07-10T16:25:14.632] [Info] [DRIVER] 2023-07-10T16:25:14.632+01:00 3 [Connection: 45]Send Begin - Length: 406[2023-07-10T16:25:14.632] [Info] [DRIVER] 2023-07-10T16:25:14.632+01:00 3 [C

2601
R
P
PrashanthApprentice
asked in CData Arc
REST Connector Dynamic URL

 REST Connector: I need to pass the XML input filed in the GET method URL dynamically. ex: XML input to REST connectgor  <ZNA_SHIP_TRACK><IDOC><EDI_DC40>...</EDI_DC40><ZSHIP_RESPONSE><VBELN>7100124618</VBELN><ZAPI_KEY>922f65ee-093a-45fd-8f1f-c61c8050e67e</ZAPI_KEY></ZSHIP_RESPONSE></IDOC></ZNA_SHIP_TRACK>  REST API should be called with below URL in the GET method:EX: “https://www.client.shipmentstatus.com/api/cn/outbound_parcel_shipment/track?parcel_shipment_id=”  +  shipment ID value (XPATH(ZNA_SHIP_TRACK/ZSHIP_RESPONSE/ZAPI_KEY)value is https://www.client.shipmentstatus.com/api/cn/outbound_parcel_shipment/track?parcel_shipment_id=922f65ee-093a-45fd-8f1f-c61c8050e67e I have tried numeros method but dynamic URL is not created and throwing error.

2751
R
R
russell-jerseypostInfluencer
asked in CData Arc
CSV Connector reports "Multi level XML file is not supported."

I have an XML input of<?xml version="1.0" encoding="UTF-8"?><rows xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <row> <DestCode>MET</DestCode> <DestName>Middle East</DestName> <Network>TD-PRIORITY</Network> <Format>P</Format> <LowerLimit>0 kg</LowerLimit> <UpperLimit>0.5 kg</UpperLimit> <ItemCount>19</ItemCount> <KiloCount>2.506</KiloCount> </row> <row> <DestCode>LTU</DestCode> <DestName>Lithuania</DestName> <Network>TD-PRIORITY</Network> <Format>P</Format> <LowerLimit>0 kg</LowerLimit> <UpperLimit>0.5 kg</UpperLimit> <ItemCount>3</ItemCount> <KiloCount>0.312</KiloCount> </row> ... <row> <DestCode>FET</DestCode> <DestName>Far East</DestName> <Network>TD-PR

501
R
R
russell-jerseypostInfluencer
asked in CData Arc
Does "Delete All Transactions" work?

 My flow had some errors in it which means i have a large amount of messages which I don’t want to be pushed any further in my flow.Does this option actually work? It doesn’t seem to do anything, therefore I am having to delete 500 at a time manually

992
D
R
russell-jerseypostInfluencer
asked in CData Arc
Flatten XML before converting to CSV

Hi I have a message containing <?xml version="1.0" encoding="utf-8"?><Items xmlns:json="http://arc.cdata.com/ns/jsonconnector" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <envelopes json:array="true"> <envelopeId>a9b6d6d0-393a-4542-9441-ae622f84f8dd</envelopeId> <recipients json:array="true"> <recipientId>0da3068e-da57-42c5-a99a-432f0822aa59</recipientId> <email>[email protected]</email> <name>Russell Hutson</name> <formData json:array="true"> <name>Your_Ref_RGR 1cda86af-e7ff-4812-9be8-6f45b98b72e8</name> <value>65546546546</value> </formData> <formData json:array="true"> <name>Co_Address_Line1_RGR f53b822c-d976-43ce-b786-dbfa7c46be12</name> <value>Test 1</value> </formData> <formData json:array="true"> <name>Co_Add_Line2_RGR bc4630a4-3e29-49df-b22a-1f911439666e</name> <value&g

1373
James B
G
GregRYorkApprentice
asked in CData Arc
Changing XML input in a script

I have several XML documents with different formats, so I can’t use XML mapping. I have been able to do some manipulations with a mixture of XSLT and scripts to add to the message header.What I need to do now is remove some parts of the XML tree based on some logic that’s not possible in XSLT alone. Has anyone tried this or has an example?

1262
G
R
russell-jerseypostInfluencer
asked in CData Arc
Fetching data from an external API endpoint since last poll

We have a flow that needs to poll an external API  “list” endpoint for new entries in the list.Over time the list will grow, so we don’t want to read the entire list every time. We’re only interested iin new items. We can ask for entries only created after a given time (a `from_time` parameters is supported by the endpoint.) Is there a way to set the `from_time` parameter based on the last time the REST Connector ran? Or is there another approach?

2163
James B
R
russell-jerseypostInfluencer
asked in CData Arc
How to Rename a Arc Flow

HiI need to promote my flow from our test environment to our production instance.I plan to export the flow, but I would like to rename it when I import the flow.Is that possible? 

1153
James B
W
wnielsonApprentice
asked in CData Arc
Renaming File With No Extension

I need to be able to change a filename of an outbound file to the following naming convention MOT599XXXX.CCYYMMDDHHMMSSNN using the current date and not adding a file extension. Any pointers on getting this done?

2001
James B
R
russell-jerseypostInfluencer
asked in CData Arc
Arc HTTPGet Operation - How to pass Authentication: Bearer header

I’m just trying to authenticate with an API Endpoint which expects a fixed token to be passed as the Authorization HTTP header.Does this look like it should work? I need to pull the token/API key from the Vault.<arc:set attr="http.URL" value="https://api.XXXX.com/carrier/api/shipment-listing/[data.shipmentNumber]" />  <arc:set attr="http.header:Authorization" value="Bearer [Vault(My.API.Token)]"/> <arc:set attr="http.contenttype" value="application/json"/>   <arc:call op="httpGet" in="http">  <arc:set attr="output.data" value="[http:content]" /></arc:call>I’m getting a 401 thanks

28210
James B
James B
James BEmployee
posted in CData Arc
I am unable to bind my server on port XXXX (which was previously used for the embedded web server) on Windows

One issue that comes up infrequently but can be inscrutable to troubleshoot is a situation where you are unable to start the web server hosting CData Arc on a port that you have previously used for the embedded web server provided with the application. For the purposes of this thread, we will refer to port 8001 here, since this is the default port assigned to the embedded web server distributed with CData Arc. Most commonly, issues with binding to a specific port are due to an existing process that is already listening on that port, but you may find that even after you run a check for ports in the listening statenetstat -a You do not see anything listening on that port. One possibility is that the URL for the port you are selecting has already been reserved on the system and cannot be assigned to another server. To check for this, run:  netsh http show urlacl This will list all of the reserved entries on the machine. If the URL that you are trying to bind shows up like this: Reserved U

1261
E
C
Charlie SEmployee
posted in CData Arc
Custom Signature Authentication in the Webhook Connector

OverviewSometimes, a requirement arises where you may need to receive data from a trading partner via the Webhook connector but that partner might require a bit more security other than just the basic auth username/password that is used to authenticate inbound webhook requests - or maybe you just want to add an additional layer of security on inbound webhook messages.Using the custom response feature of the webhook connector, you can actually create your own HTTP signature authentication logic to perform some additional authentication on inbound webhook requests, via the use of an HMAC signature value assigned to a header on the request.GitHub has a good writeup about this, and this is what has been used to make the below example within CData Arc - https://docs.github.com/en/webhooks-and-events/webhooks/securing-your-webhooksThe ScriptThis script is one that I wrote within the Response event of the Webhook Connector attached to this post:<!-- setting the secret key value to be avail

2342
Ankit Singh
C
Charlie SEmployee
posted in CData Arc
Connector Backoff Behavior in CData Arc

In CData Arc 2022, a new feature was added to the application which has been coined “backoff”. You may or may not have seen this mentioned in the application log of your instance, but if you haven’t, an entry in the application log would look something like this:~/AutomationService    Warning    The [ConnectorID] connector has failed more than 3 times and has entered a backoff state. The automation service will skip this connector until [date/time]. The connector will remain in the backoff state until a message is successfully sent manually, the connector settings change, or all messages are sent successfully during an automated send attempt.This is a feature where the automation for the connector will be temporarily paused if the connector fails to send a file successfully with automation three times in a row. If this happens, a 60 minute delay will be added to the automation of that connector before the connector will try to send any files via automation again. If the connector fails

1940
C
C
Chris CApprentice
asked in CData Arc
How to automate a Sql Server Connector

I have a stored procedure that I want called once per day and the data pulled sent to a Send Email Connector. When I manually click the Receive button on the Output table of the Sql Server Connector, everything works as desired.  However, I set up the Receive Interval on the Automation Settings to Receive the data once per day, but it doesn’t run.  Am I doing something wrong? Or is there another way to automate the execution of this stored procedure?  Thanks,Chris

922
C
C
Chris CApprentice
asked in CData Arc
Execute final stored procedure after multiple tables import.

I have a flow that processes multiple files into multiple Sql Server tables. Once all those database tables are updated with the imported data, I want to run a stored procedure that uses that data to populate other tables. I was thinking I would just add another Sql Server connector after the import_pricing connector, but can I be sure that all the other import connectors have successfully completed first?  Is there a proper way to do this in Arc, so that when I run the final stored procedure all the needed import tables are populated appropriately first? Thanks!

1363
C
W
wnielsonApprentice
asked in CData Arc
Setting sFTP server thumbprint to public key

Hello - I am having troubles establishing an sFTP ssh key pair connection. I want to set the server thumbprint to the servers public key which I have saved to a certificate but I just keep getting a “thumbprint format” error. Does anyone know exactly how to accomplish this?  

601
Ankit Singh
CData's Winter 2025 Release

Badge winners

  • Product Expert
    bgrassihas earned the badge Product Expert
  • Product Expert
    DuyNguyenhas earned the badge Product Expert
  • Product Expert
    quinnfhas earned the badge Product Expert
  • Product Expert
    JDBhas earned the badge Product Expert
  • Product Expert
    Annahas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings