Learn how to retrieve data from ASAPP Messaging
Generate a SSH key pair
Generating a SSH key pair
<keyname>.pub
file with your ASAPP team.Connect to SFTP server
prod-data-sftp.asapp.com
22
sftp{company name}
Download data
/FEED_NAME/version=VERSION_NUMBER/format=FORMAT_NAME/dt=DATE/hr=HOUR/mi=MINUTE/DATAFILE(S)
Path Element | Description |
---|---|
FEED_NAME | The name of the table, extract, feed, etc. |
version | The version of the feed at hand. Changes whenever the schema, meaning of a column, etc., changes in a way that could break existing integrations. |
format | The format of the exported data. Almost always, this will be JSON Lines.* |
dt | The YYYY-MM-DD formatted date corresponding to the exported data. |
hr | The hour of the day the data was exported. |
mi | The minute of the hour the data was exported. |
DATAFILE(s) | The filename or filenames of the exported feed partition. |
_SUCCESS
file to verify that the export is complete.Upon completing the generating for a particular partition, ASAPP will create an EMPTY file named _SUCCESS
to the same path as the export file or files. This _SUCCESS
file acts as a flag indicating that the generation for the associated partition is complete. A _SUCCESS
file will be written even if there is no available data selected for export for the partition at hand.Until the _SUCCESS
file is created, ASAPP’s export is in progress and you should not import the associated data file. You should check for this file before downloading any data partition.convos_metrics
, use this query:
primary_key
for that table and get the latest data using order by logical_timestamp
DESC in the subquery. Then we only select where row_idx
= 1 to only pull the latest information we have for each issue_id
.
export_docs.yaml
, which is generated each day and sent via the S3 feed. By incorporating this into the workflows, you can maintain a proactive stance, ensuring uninterrupted service and a smooth transition in the event of schema adjustments.