Access the All Companies File
File Structure
The flat files are grouped together based on data type. The flat file data types are:
Companies
Domains
Locations
Contacts
Within each of the above should be at least one compressed tar file (this is displayed with the suffix .ta.gz). Each of these Tar files contain a number of CSV files with approximately 500,000 rows per file.
Downloading Files
Linux/macOS
After you have completed the setup in the Accounts page then you may begin this process.
In the terminal type the following to access the SFTP.
Please ensure to change <name as you wish> to the name of your public key.
sftp -i ~/<name as you wish> data@warehouse.grata.com |
Are you sure you want to continue connecting (yes/no/[fingerprint])?
If you receive this question, please select YES.
Once you have successfully connected to the SFTP, type 'ls' to access the folder structure.
You will see these directories listed:
Companies
Domains
Locations
Contacts
You can navigate into the directories by typing 'ls' before typing the directory name.
For example 'ls Companies' to view all files in the Companies directory.
You can download the files to your machine by typing 'get' before typing the file name.
For example 'get 2021-10-23.18-01-09.all_Companies.tar.gz'
Windows
Download Filezilla if not already present
Open Filezilla
For Protocol, choose SFTP - SSH File Transfer Protocol
Enter in the following value for Host: warehouse.grata.com
Type in 22 for Port
Ensure the Logon Type is Key file
User should be the Username as it appears in the Accounts page (in the UI) -> Flat File tile
If you cannot access the Accounts page in the UI please contact your account manager and they can provide it to you
Key File: Path to your private key generated above
Example: C:\Users\privatekeyfolder\privatekey.ppk
Click Connect
Access Files Generated from a List
File Structure
The flat files are grouped together based on data type. The flat file data types are:
Companies
Domains
Locations
Contacts
Within each of the above should be one compressed tar file (this is displayed with the suffix .ta.gz). Each of these Tar files contain a number of CSV files with approximately 500,000 rows per file.
Linux/macOS
After you have completed the setup in the Accounts page then you may begin this process.
In the terminal type the following to access the SFTP.
Please ensure to change <name as you wish> to the name of your public key.
Please ensure to change <username> with the username value displayed in the flat file setup screens.
sftp -i ~/<name as you wish> <username>@warehouse.grata.com |
Are you sure you want to continue connecting (yes/no/[fingerprint])?
If you receive this question, please select YES.
Once you have successfully connected to the SFTP, type 'ls' to access the files.
You can download the files to your machine by typing 'get' before typing the file name.
For example 'get 2021-10-12.18-41-28.list_A4Q67R3Y_Companies.tar.gz'
Windows
Download Filezilla if not already present
Open Filezilla
For Protocol, choose SFTP - SSH File Transfer Protocol
Enter in the following value for Host: warehouse.grata.com
Type in 22 for Port
Ensure the Logon Type is Key file
User should be the Username as it appears in the Accounts page (in the UI) -> Flat File tile
If you cannot access the Accounts page in the UI please contact your account manager and they can provide it to you
Key File: Path to your private key generated above
Example: C:\Users\privatekeyfolder\privatekey.ppk
Click Connect