SFTP to hubspot most recent file (error)

  • 253Views
  • Last Post 21 October 2021
0
votes
Pieter Verhaaren posted this 18 October 2021

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 the SFTP and will be updated with a form submit troughout the day. 

Using file mask with that specific format seems to work (variables of the columns are loaded correctly). However, everytime I run the import, Skyvia returns an error that the columns aren't imported. 

But, when I import an individual file, the import does work. So the problem is only showing whenever I want to automate a daily import. 

 

0
votes
Olena Romanchuk posted this 21 October 2021

Hello Pieter, 

Please make sure both Skyvia IP's  40.118.246.204 and 13.86.253.112 are whitelisted on the SFTP server.
We also recommend you to activate the new runtime option on the package editor page. 
Please inform us about the result.

Best regards,

Olena

 

Technical Support Engineer

Close