Introduction
When configuring Queryly, an SFTP folder is associated enabling secure file transfer for list management.
SFTP management
Here is the SFTP path useful to create and manage contact lists : /queryly/contact_lists_sftp/{group_name}-{group_id}
with the {group_name}corresponding to the name of the group in lowercases, replacing spaces with ‘-’ and ‘/’ with ‘_’.
- Static list from SFTP: the available files need to be in a directory called
statics:/queryly/contact_lists_sftp/{group_name}-{group_id}/statics Dynamic list: available directories must be created in the folders of the desired groups :
/queryly/contact_lists_sftp/{group_name}-{group_id}. A directory can only be used by one dynamic list.When the filename contains a date variable, Queryly retrieves the file by replacing the date variables with the current date.
The directory /archive is automaticallyt created within the directories described above to stock files after insertion. The files are pre-fixed with the date and identifier of the insertion.
In order to access SFTP, you need to communicate an SSH public key to the support team, specifying which groups this account can access.
Conclusion
To access SFTP for contact lists, provide an SSH public key and specify the authorized groups.