Solved

I am trying to use httpGet to retrieve binary files, then push them through via a Script connector: <arc:set item="httpGetInput" attr="url" value="[params.pdfUrl]" /><arc:call op="httpGet" in="httpGetInput" out="response"> <arc:set attr="output.data" value="[response.http:content]" /> <arc:set attr="output.filename" value="test.pdf" /> <arc:push item="output" /></arc:call>It downloads the file, and sends it through, however the file is garbled, I assuming this is a encoding problem somewhere.Downloading the files directly from the source URL, the files render fine.Said connector is inside an API Request, with Response content type set to “application/pdf”:There must be something I am missing. 

I am new to arcESB and we have a basic requirement where we need to call a rest service, get the data in json format and same data i need to use to later while using smtp connector (filename need to be modified). I am unable to map the data, i tried using arcScript in event section of rest connector but it seems to be not working. Any suggestion will be really appreciated. thanks in advance. 

We are trying the map multiple fields in a XML (EDI) into one field in another XML in a XML Map connector. We use the implode formatter for this. But it isn’t working, we only get the first item. But we want all the NTE02 fields joined with a newline as separator. This is the script we use:[xpath("FunctionalGroup/TransactionSet/TX-00401-940/NTE/NTE02") | implode] Source XML:<FunctionalGroup>            <TransactionSet>        <TX-00401-940 type="TransactionSet">            <NTE type="Segment">                <!--Note                Reference Code-->                <NTE01><!--Warehouse                    Instruction-->WHI</NTE01>                <!--Description-->                <NTE02>PALLETS COVERED WITH STRETCH HOOD</NTE02>            </NTE>            <!--Note/Special            Instruction-->            <NTE type="Segment">                <!--Note                Reference Code-->               

Is there a better way to check for null results from a dbQuery, I feel dirty for coming up with this: <arc:set attr="db.query">select null as something;</arc:set><arc:call op="dbQuery" in="db" out="results"> <arc:if exp="'[results.*]' == '<table></table>'"> <!-- handle null --> </arc:if> ...</arc:call> 

Hi all, I kindly need help on this one. While checking the documentation CData JDBC Driver for Google Analytics - GoogleAnalytics4 Data Model , I noticed that there are no metrics or dimension related to TAX, DISCOUNT, SHIPPING ,REFUND. These informations were present in the universal model.From the documentation say this in the EcommPurchaseItemIdReport (see boxed part of screenshot) , but the Column names and the description do not match. and after querying the data, it proved that they indeed do not match .   

This works with a REST connector just fine: However with a SOAP connector it does not (fails with  _message specified in the formatter, does not exist): Both connectors do have the correct header payload. Both have Allow Script in Url checked. Any ideas what I am doing wrong?

I'm having trouble with C-Data CMS when I use an ONT from another brand. For example, I added a ZTE F663NV3A ONT. After checking the parameters, the ONT I added doesn't accept the SSID password. So, I can't see the Wi-Fi password and can only see the SSID. Has anyone else experienced this issue? It seems that only C-Data ONTs can be accepted by C-Data CMS. Or maybe the product doesn't provide the parameters? Please help.

I want to add my Jo-Link OLT with model JL08-L3 to C-Data's CMS. Since my OLT doesn't support MQTT, I'm using SNMP+Telnet as an alternative. However, there is no hardware version that supports the Jo-Link OLT. Please help..

I’m trying to deploy an SSIS package to my server, and receiving the error “file:FileService SFTP Client Error during operation 'DOWNLOAD': The specified directory could not be created” server side.This runs without any issues from my developer. The service account has access to the folder (I also tried running the package with my AD account and got the same error). I’m kind of running out of ideas where to look. Does anyone else have ideas where to look?

Hello everyone,I recently purchased the CData QuickBooks ODBC Driver (Desktop version, $499/year) for one desktop and one data source (QuickBooks), as shown in the attached image.When trying to use it in Navicat Premium to query data, I get the following error: 1003 - The feature is only available with an Enterprise server license of CData Provider for QuickBooks 2024.I’m attaching screenshots of both the purchase and the error.My questions are: Why is it asking for an Enterprise Server License if I bought the Desktop version? Is there any configuration I need to change for it to work in my current setup? My final goal, after successfully testing with Navicat, is to connect to QuickBooks from a Laravel application.Thanks in advance for any guidance.

Error:Hi everyone, New to the community, within our team we are responsible for a ARC server (CData Arc™ 2024 - 24.3.9159.0) and I am running into the following issue: “Connection open failed: [500] Unable to connect to databasename.database.windows.net:1433: System error: No such host is known” (Azure SQL)Strange thing is that it works normally, but just sometimes it doesn't. This connector has almost 6000 entries in the last 5 days, only 8 have this error.These 8 are 4 Messages, with a retry of 60 minutes and a retry count of 1. Making that these 4 messages were tried 2 times in total. Last time 1,5 hour prior to this post. Trying manual send and boom all messages processed.SQL Database show no health warning and I can't find any metric that would indicate a problem with the database. Connector type is a script.

'{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"cause":"Validation failed : DISCRETE_PAGINATION_LIMIT_EXCEEDED => You can only get the first 2000 records without using page_token param [ 2000 ] ","conditions":"","connection_type":"Zohocrm","entity_type":"Accounts"}}],"message":"Unable to list entities.","status":"FAILED_PRECONDITION"}}'

We would like to inquire if there are any specific restrictions or limitations when fetching records for "campaigns" specifically from Salesforce Marketing Cloud (SFMC) using CData connectors/drivers.

We are currently using a GCP application integration to connect to Salesforce Marketing Cloud. Our goal is to fetch a list of the Campaigns entity.However, when attempting to list or retrieve data for the Campaigns entity, we are consistently encountering the following error response:{  "error": {    "code": 400,    "details": [      {        "@type": "type.googleapis.com/google.rpc.ErrorInfo",        "metadata": {          "cause": "[10000] \"A general error occurred while trying to retrieve campaigns\". A general error occurred while trying to retrieve campaigns. ",          "conditions": "",          "connection_type": "SFMarketingCloud",          "entity_type": "Campaigns"        },        "message": "Unable to list entities.",        "status": "FAILED_PRECONDITION"      }    ]  }} 

We are currently using a GCP application integration to connect to Salesforce Marketing Cloud. Our goal is to fetch a list of the Journeys entity.However, when attempting to list or retrieve data for the Journeys entity, we are consistently encountering the following error response: Execution timeout, cancelled graph execution. Note any variable contains large data was failed to upload to GCS. Please try again. error/code: 'common_error_code: SYNC_EVENTBUS_EXECUTION_TIMEOUT''View logs for error details. Check the troubleshooting guide  for possible ways to resolve your error.

import cdata.dynamics365 as modconn_str = (    'OrganizationUrl=https://dddddd.crm4.dynamics.com;'    "OAuthSettingsLocation=/home/ddddddv.txt;"    'InitiateOAuth=REFRESH;'    'Edition=Sales;'    'IncludeLookUpLogicalName = true;')conn = mod.connect(conn_str)try:    cursor = conn.cursor()    cursor.execute("""       UPDATE table1         SET colum1 = 'sdsdds0299e3'         WHERE A = 110 AND B = 0    """)    # Get column names from description    columns = [col[0] for col in cursor.description]    print("Columns in gfwi_projects:")    for col in columns:        print(col)finally:    cursor.close()    conn.close()column 1 is a lookup column which refers to column 2 of table 2. when i run the python query. there is an error : column1 could not be updated. This column is read-only. please help

I am interested in learning ARC Script for cdata arc and I am from non programming background,  Can you please suggest me any pre requisite (like any programming concepts should know )required before starting learning ARC Script 

When attempting to use SF_Metadata to retrieve metadata from CustomField, the MetadataXML column is never populating. The Member and Id columns are populating when I use the List operation, and executing the proc with the Retrieve operation appears to succeed, but the MetadataXML column remains NULL.CustomObject and the other tooling objects I’ve worked with have worked fine.This behavior is not confined to a single org. I have confirmed it against three orgs so far.I’ve tried querying CustomField directly in a query using the four-part object identifier, but I get an errorMsg 7314, Level 16, State 1, Line 1The OLE DB provider "MSOLEDBSQL" for linked server "<linked server name here>" does not contain the table ""CData"."Salesforce"."CustomField"". The table either does not exist or the current user does not have permissions on that table.I am able to successfully query the CustomField object in the org via SOQL through Inspector and Workbench to retrieve metadata. I’ve done a fa

Hi Team, I have requirement, where  I need to send back the response back to customer, Below is message we will be receiving from customer, via Webhook connector.    {     "transId": "PUTO300000308",     "whId": "OMEGA-TEST",     "ownerCode": "199501010666",      "jobType": "11",     "jobCode": "010000000408",     "status": "ACTIVE",     "eventAt": "2025-07-03 12:34:56",     "containerId": "00493460370000410856",     "jobGroupCode": "03072026"    }  The response customer is expecting are like below, {"transId": " PUTO300000308","status": "ok","message": ""}  I need pick the transId value from the received data and built the response back with status “Ok” to them. Please help to advice how I need achieve this.

Hey All, I’m using cdata sync , version  Cross-Platform Edition - 24.2.9064.0. I’d like to pull cdata sync’s job history  metadata   into a table in SQL Server, so I can perform analysis. Any suggestions on how to do this? I didn’t find anything in the documentation other than info on how to use the cdata sync GUI, but that is not useful.I’d even settle for exporting job history data into a .csv file if that is possible. Ultimately, I want to be able to perform aggregations on the number of records loaded per job. This can’ tbe done through the existing GUI. Thanks! 

I can’t get the connection string to work with charset ie. DataSource=myaccesdb;Charset=windows-1252; The connection is fine, but Charset has no effect. Has anyone solved this?

Hi Everyone,I have a scenario to use Azure Managed SQL Instances and these are not supported for DBAmp because they do not allow the installation of 3rd-party linked servers on the Instance. So I am trying to install dbamp remotely - to a on-prem SQL server virtual machine. We will create a Azure SQL managed instance where data will be stored. - DBInstanceDbAmp will be configured as linked server  in a on premise virtual machine with SQL server installed. - DBAmpServer I have two questions:Can we run DBAmp from DBAmpServer to move the data from DBInstance to Salesforce? The article DBAmp - Running DBAmp Remotely (cdata.com) mentions the other way around, but we need a bi-direction data transfer between DBInstance and Salesforce. The article mentions that a subset of stored procedures will be available. Can you confirm if that subset includes all SPs needed to transfer data between SQL tables and Salesforce standard & custom objects as well as extracting error logs to DBInstance fro

Hi,I have 3 years worth of data. All the data stay the same but the latest 3 months are dynamic. I need to replace the old data with the latest data. But if I do “Drop Table”, it drops all the data and bring all 3 years worth of data and sometimes the system dont seem to be able to handle it.  I would like to keep everything and just have the last 3 months tables dropped and replaced. I dont want the system to have to bring ALL data from the past 3 years. I just need the last 3 months dropped and replaced.  What setup should I do?

<arc:set attr="input.uri" value="[FilePath]"/><arc:call op="xmlOpen" input="input">  <arc:set attr="xml.handle" value="[handle]" /></arc:call><arc:set attr="xml.map:lastupdate" value="/Items/gtm_req_pr_details_ib_pr/lastupdate"/><arc:set attr="xml.map:till_date"     value="/Items/gtm_req_pr_details_ib_pr/till_date"/><arc:try>  <arc:call op="xmlDOMGet" in="xml" out="out1">    <arc:set attr="data.lastupdate" value="[out1.lastupdate]"/>    <arc:set attr="data.till_date"     value="[out1.till_date]"/>  </arc:call>  <arc:set attr="http.URL" value="https://api.com/purchaserequisitions?approvalLeftDate=[data.lastupdate]&approvalRightDate=[data.till_date]" />  <arc:set attr="http.header:name#" value="X-AUTH-TOKEN" /><arc:set attr="http.header:value#" value="xcxcxcxcdxcxcccccccc"/><arc:set attr="http.header:name#" value="email" /><arc:set attr="http.header:value#" value="[email protected]"/><arc:c

Since this morning at 08.00 we have problems with the Cdata Driver Connector for Power BI. This error is from Power BI Desktop I tried to recreate the connection, but without success.