Hello,
I would like to automate data imports from a transaction list via an SFTP connection. My SFTP connection is working properly.
Issue 1: Variable date
When I use the “Fixed file” option with the file path and name “ZME2K_20260828_0018BSQz.P0J.csv” it works.
However, when I try to use the “Most recent file” option with the file path and name “ZME2K_{{date}}_0018BSQz.P0J.csv” no file is found. Pigment documentation specifies that the “ISO-8601” standard is accepted (with or without “-”). However, article only provides the example with a hyphen. I use a YYYYMMDD format. Did I do something wrong?
https://kb.pigment.com/docs/connect-sftp-server.
Issue 2: Other variable
This same transaction list must be populated from several separate files with the same structure, originating from different departments (existing “department” dimension).
I understand that I must create a connection for each file (i.e., for each department), and that only the file date can be varied. This system seems a bit cumbersome to me. I’m encountering technical issues when trying to export my data into a single file (due to file size limitations). Do you have any advice for me?
Thank you in advance