Tickets Tagged With:import
Category: Questions
cannot upsert on Synapse SQL pool with primary key constrains
I am trying to upsert on a table that has primary key constraints created so that there is PK functionality on a Azure Synapse dedicated SQL pool. Here is the ....
Category: Questions
Import package from BigCommerce not importing data to SQL Server
We have a Import package that is fetching data from BigCommerce and importing to SQL Server. After running the package we can see that it succeeds, and we see the ....
Category: Questions
Netsuite object not visible
Hi , I am not able to see the desired object in the Netsuite's connector table list, the connection & the agent are working fine , i am able to ....
Category: Questions
Integrations CSV Import - need filename wildcard
In integrations I am trying to import a CSV file from a SFTP server. The source files are created with the following format: GFPVAN_RHSC_DiscreteOrderDownload_1.0_{yyyyMMddhhmmss}.csv and placed there for us to ....
Category: Questions
SFTP to hubspot most recent file (error)
Hi, I want to import data from a SFTP file to Hubspot on a daily basis. Each day, a file with a name containing that specific day will drop into ....
Category: Questions
Google Sheet Import Very Slow
We have an import job that imports from 2 csv to 2 tabs of a Google Sheet. The process takes extraordinarily long. It took over 3 hours to import under ....
Category: Questions
Google Analytics - No State Filter
Hi, Is there a workaround to import only the recently inserted and/or updated records from Google Analytics? Unlike other sources, there's no State Filter (i.e. Inserted, Updated) and it just duplicates ....
Category: Bug Reports
Cannot see the list of files in the FTP directory
I am trying to import data from multiple CSV files from a FTP server. While trying to do file masking, I cannot see the list of all the files in ....
Category: Questions
Odata Dynamics 365 Business Central
Hello, I am trying to import all my MS Dynamics 365 Business Central Contacts into HubSpot. I connected MS Dynamics with OData but I can't seem to get any other source ....
Category: Questions
Data Import File Mask Format
Is there a way to ignore characters in a file mask? We are receiving files with name "Accounts_2021_06_15_122503", but we need to ignore the hour, minute and second at the ....
Category: Questions
"Update" function is not working in Import Package
Oracle to Big Query connection - thru agent (Oracle) Error message: Action 'UpdateKeysRequiredAction' is not supported. Not being able to use the UPDATE function - tried several ways but cannot find ....
Category: Questions
Import Google sheet data to sql server
Is there anyway to create connection with Google sheet and import gsheet data into Sql Server ? Thank you ! ....
Category: Questions
HubSpot import Engagement (MEETING) Outcome parameter
Hello, Importing to HubSpot, of object Engagements and type MEETING. Everything is working as it should but can't find the correct mapping of column for "Outcome". CSV column: Outcome CSV column ....
Category: Feature Requests
Target Lookups to Allow Expressions
When running a data import it would be incredibly useful to enable the use of Expressions in the Lookup functionality. The explicit use case is when the data types do ....
Category: Bug Reports
Object reference not set to an instance of an object. - Import SQL to Salesforce
When importing from the SQL Server to Salesforce, the import package always fails with the error. Object reference not set to an instance of an object. ....
Category: Bug Reports
Import Package Error
I am performing an UPSERT import operation which pulls a CSV fle from S3 and imports it it into the lead table in Marketo. It works great except there are ....
Category: Questions
Initial mapping error from a mysql db
I am trying to do the intial mapping of my products table to bigcommerce and keep getting "task has some invalid columns mappings." please help I have tried all different ....
Category: Bug Reports
Import Taking to long
I have an Import process that is taking to long to complete. The process keeps running and does not give any error. There are only 591 records. My replication process ....
Category: Bug Reports
Server returned an error: (400) Bad Request on upsert operation (Amazon S3 and Salesforce)
Hello! My Import operation seemed to be working up until a certain point when it suddenly cut out stating the following: An exception has occurred during upsert operation, the message returned ....
Category: Questions
Help needed Writing an Expression
Hey Skyvia! I'm currently performing a data import to zoho. The conncetions are set and established and I have data importing. I want to add in an expression to ....