Data Integration

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

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]

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

We upgraded to DBAmp V22 version. Have upgraded the Stored Procedures.Regular SOQL queries work from the SQL server, but when try using SF_REPLICATE or SF_REFRESH we get the following error. --- Starting SF_Replicate for Account V830409:56:45: Parameters: SALESFORCE Account  Version: V830409:56:45: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc.09:56:45: Using options specified in Options parameter: soap09:56:45: Obtaining Connection Props09:56:46: Error: Unable to retrieve settings from sys_connection_props.09:56:46: System.Data.SqlClient.SqlException (0x80131904): Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnecti

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

Is this correct? 

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 ?

Hi, We are migrating to new SQL 2022 servers.  I have installed v2022 of DBAmp on our new dev server, we use SF_Replication/SF_Refresh, changing to SF_Mirror is not yet on the table.  My default server collation is Latin1_General_CI_AS, and the DBAmp replicant also becomes this collation.  This is the exact same setup we run in production, with version 5.1.8.0 of dbamp.   Both environments, current prod and new dev have “Collation Compatible” and “Use Remote Collation” set to true.I have run a full SF_Replicate, and when i start to run the daily SF_Refresh i am getting the below error:--- Starting SF_Refresh for Contact V830416:12:31: Using Schema Error Action of subsetdelete16:12:37: Local table created at: 2023-05-17 16:29:0016:12:37: Using last run time of 2023-05-17 16:29:00Msg 468, Level 16, State 9, Line 1Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to ope

When I attempt to replicate ContentDocumentLink with CData Sync from Salesforce to SQL, I am getting this error. [0] [500] Could not execute the specified command: [sf:MALFORMED_QUERY] MALFORMED_QUERY: Implementation restriction: ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id's using the IN operator. The tool that I am looking to replace with CData Sync can do it.  Is there a workaround to get this object to replicate? Thanks

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[20

 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_TRA

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

 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

Does anyone here have any experience with the CData Sync email connector? I want to know what type of functionality it has - as in, can it read attached files and replicate those, etc?

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> &

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?

Hi all, Was wondering if anyone has any ideas regarding a NetSuite connector that will allow me to add the connection but displays no tasks when adding a new job.  The connector is using an OAuth token to auth against SuiteQL. It can connect sucessfully, although I can’t create any tasks as it says “No Tasks found. Please verify your connection has access to tables”. The permissions in NetSuite were set according to “https://cdn.cdata.com/help/DNH/cloud/default.htm#pg_permissions”. Any help would be appreciated!

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?

There are a host of errors, mostly “Error occurred creating primary key for table.” in tables AppDefinition, AuraDefinitionBundleInfo, AuraDefinitionInfo, FormulaFunction, FormulaFunctionAllowedType, FormulaFunctionAllowedType and other. but also “Using FullCopy because the FieldChangeSnapshot table does not exist.”threw a SOAP error: Error System.Web.Services.Protocols.SoapException: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: Enter a valid ParentID.    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)   at DBAmpAZ.sforce.SforceService.query(String queryString)    at afo220l.Uh.w() Should I wipe out all the tables and start again? Please advise.RegardsAndre

Has anyone ever used the REST API Source to get to MS Teams Auto Attendant and/or Call Queue data?Any help is appreciated.

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? 

I am using cdata sync and getting the error “EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.”I have seen other posts say to use a Full vs partial copy but I am not sure that is something that Cdata sync does.   Is there a way go get beyond this error in cdata or salesforce?

Is there a patch / hotfix official release schedule for DBAMP? There must be some fixes since the official V2022 release.  I did get some Hotfix patches but was wondering if I am to expect an official 2023 or 2022.1 release. I currently have to restart the windows service each night to prevent crashes.

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?

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