Solved

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

 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 am trying to use the NETSUITE ODBC driver within Visual Studio SSIS project, everything connects good but when selecting some tables, I noticed that there are some missing fields in the table, for example in the table item, the field subsidiary is missing:   But in the log file, the json has it:  Should I need to set something else in the configuration? How can I solve this? Thanks.

Hi , I am getting error while connecting GA4(Google Analytics 4) to Tableau desktop using cdata connect with cdata  connector and GoogleAnalytics by cdata.   If anyone has some suggestion on this or anyone is trying to achieve the same then let me know. Regards,Pankaj 

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

ObjectiveTrying to use a cData DSN in Excel to connect to an OLAP cube in Azure Analysis Services on macOS. I can successful setup the DSN in iODBC Data Manager and it tests successfully, but when I try to use the DSN in Excel I get a “Could not bind server socket: Operation not permitted”.   I have screen-grabbed all my steps below in the attached PDF.  

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? 

We are a new CData user, connecting Acumatica oData as the source to SQL Server OLE DB destination.  It works great for the initial configuration of the data flow, but we often change the underlying Acumatica query (i.e. add columns). I can’t seem to find a way to refresh the available columns in the CDdata Acumatica Source Editor screen.  If I click the preview button, the new columns appear there correctly with data, but how are the columns added to the Columns node of the Editor screen?  Along those lines, is there a way to refresh the list of available Generic Inquiries for new oData sources?  The first time you log into Visual Studio the list of available inquiries refreshes, but after that I have to just use the Advanced Editor and hand-write the name of the query.  Thanks for any feedback!

I am trying to insert a manual journal entry into Xero using below SQL insert statement. And I get the following error. “A validation exception occurred: The total Debits (1.50) must equal total credits (0.00)" It suggests that cdata is not processing it as one API post but as 2 posts and Xero spits back an error because it expects both lines in the POST api. INSERT into ManualJournals ( JournalLine_AccountCode, JournalLine_LineAmount, Narration) VALUES (620, 1.50, 'Test1'), (611, -1.50, 'Test1');Any ideas would be appreciated. 

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.

Is it possible to connect to more than one QuickBooks company file? My organization uses a few company files, and I’m confused as to how to connect the driver to all of them.

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

Hi!I’m using the Excel add-in to connect to Zoho Books. I would like to get all “BillLineItems” from Zoho. The BillLineItems is a standard view or table.It is not possible to use the SELECT * command in order to retrieve all lineitems. It is required to a specify a BillID (key) number in order to get the data for that specific bill from this table (as I understand).Maybe it is my lack of knowledge of SQL. Do you have any suggestions how to get all BillLineitems? Thanks in advanve for your response.Regards,Marc

When double clicking on the CData source, I am getting the following error.  “Could not load file or assembly 'Microsoft.DataWarehouse, Version=17.3.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.” 

Does CDataFireDACComponentsforExcel2022 support batch insert to a sheet?If so, how to use it?I am using Delphi + FireDac + CDataExcel + SQLServer.From a stored procedure that returns two DataSets I need to create an excel file with those two DataSets (worksheets).Previously I have managed to use a batch insert from CSV files to SQL Server; but I have not been able to do the same from a dataset to an excel sheet. I tried this but it throws this exception:[FireDAC][Phys][CDataExcel]-303. Capability is not supported FDQuery1.Connection.StartTransaction; FDQuery1.Params.ArraySize := 3; FDQuery1.Params[0].AsStrings[0] := '66666666-269a-491f-ae3a-86ff85149e03'; FDQuery1.Params[1].AsStrings[0] := 'A666666666'; FDQuery1.Params[2].AsStrings[0] := '2023-05-02'; FDQuery1.Params[3].AsFloats[0] := 666666.7895; FDQuery1.Params[0].AsStrings[1] := '77777777-269a-491f-ae3a-86ff85149e03'; FDQuery1.Params[1].AsStrings[1] := 'A777777777'; FDQuery1.Params[2].AsStrings[1] := '2023

Issue encountered while extracting data using CDATA JDBC driver in Snaplogic. Specifically, we are receiving the following error message: "Class java.lang.Boolean cannot be cast to class java.lang.Number (java.lang.Boolean and java.lang.Number are in module java.base of loader 'bootstrap')" Thanks

We are getting the error message when we tried to install the JDBC on Linux machine.Error:Downloading license data...Error downloading license: Connection reset We were given the linux setup link to download the setup.zip file, after downloading we are not being able to install the JDBC driver on Linux Machine.we are using-  “java -jar cdata.jdbc.xero.jar -license” command from linux terminal to install the driver.Please suggest.Thanks.