Daily Data Export Report - Receive It Your Way

Daily Data Export Report - Receive It Your Way

You can now retrieve your Daily Data Export via the API, have it delivered to Webio's SFTP for you to retrieve or download it via the WebApp.  

The Daily Data Export is a daily export of all inbound and outbound messages from your Webio organisation.  For more details on the data included seeWebio Reporting

Reporting Download WebApp

If you have access to the Reporting tab, log into your Webio organisation.  Click reports, next to Daily Data Export select Run Report, choose your organisation and date range and click Run Report.  You will now be able to add filters to the report and export this in your desired format as required. 

API Call

Before calling the Daily Data Export API, if you haven't already done so, you will need to generate your organisation's API key.  Once generated use the Daily Data API call to request the export as you require it.  Please note the export is limited to one day's worth of data. 

Use the getDailyDataExport API, you will need your API key, your Organisation id and the date you want to retrieve information for.  


SFTP Hooks

SFTPHooks enable users to utilise the benefits of API connectivity from the Webio SFTP endpoint. 

You will need to configure your Webio SFTP and generate your organisation's API key if you haven't already done so.  If you already have an API key generated for your organisation, then jump to step 1 below.

SFTP hooks can only be used for post requests.

sftp.webio.com - this is where you save your API key file and retrieve your files from 
sftphook.webio.com - this is the URL you enter into your organisation screen webhook setup as the URL

Step 1

Save your API key as a text file called apikey.txt and transfer this to your sftp.webio.com folder. 

It may take c. 10 minutes for the key to be processed. 

If you need to update your key, place a new file there and that will replace the old key.

Step 2

Send a request to support@webio.com to put live your report delivery. 

You will need to confirm:

the organisation you want the report ran against;
the time of day the report should run;
whether this should be a JSON or a CSV file.

Step 3 

You will receive confirmation from support that your report delivery has been configured. 

Login to your SFTP folder to check the report is there and to retrieve and delete old files. 

Files not retrieved within 7 days may be deleted. 




    • Related Articles

    • Data Sharing - Third Parties

      Webio takes our data protection responsibilities very seriously.  We protect your data by ensuring it is secure and we manage your data in compliance with GDPR.  When necessary we do share data with carefully selected third parties, but before we do ...
    • Webio - Information Security and Data Protection

      Webio incorporates information security and data protection principles into everything we do.   Below are some of the ways in which we put this into practice. Disaster Recovery and Business Continuity - Webio's disaster recovery plan is reviewed ...
    • Uploading Data To A Daily Campaign

      Quick Trick: Click in Campaigns, click List, click the upload arrow next to your campaign, drop in your file You can easily upload data to your campaigns. Click into campaigns and select "List", this is above the QUICK CAMPAIGN button. You will now ...
    • Listening Steps To Gather Data

      Listening steps can be used to gather responses and store them in either Data fields or in Customer ID fields.  If you store the response as a Customer ID then that value will display in the conversation screen and in reports and webhooks where the ...
    • Editing a campaign - adding a new column to your data import

      Quick trick:  In campaigns click list view then edit your required campaign.  Drag in your file containing the new column.  Complete the campaign setup process. To add a new column to your campaign, first edit the sample file to include the required ...