The Day resource allows you to download the export file containing a single day's data for your account and the requested data type.
Day files are stored and returned as compressed (gzip) JSON files with one record per line. Records are similar to the Message resource. The differences are:
price_units
will not be present
api_version
will not be present
error message
will not be present (but
error_code
is)
uri
and
subresource_uris
will not be present.
date created
,
date updated
and
date sent
are in UTC and ISO 8601 format.
Day files are stored and returned as compressed (gzip) JSON files with one record per line. Records are similar to the Calls resource. The differences are:
uri
and
subresource_uris
will not be present.
Day files are stored and returned as compressed (gzip) JSON files with one record per line. Records are similar to the Conferences resource. The differences are:
api_version
will not be present
uri
and
subresource_uris
will not be present.
##Participants BulkExport file format Day files are stored and returned as compressed (gzip) JSON files with one record per line. Records are similar to the Participants resource. The differences are:
uri
will not be present
label
will not be present
resource_typetype: stringThe type of communication – Messages, Calls, Conferences, and Participants
redirect_totype: string<URI>GET https://bulkexports.twilio.com/v1/Exports/{ResourceType}/Days/{Day}ResourceTypetype: stringThe type of communication – Messages, Calls, Conferences, and Participants
Daytype: stringThe ISO 8601 format date of the resources in the file, for a UTC day
This will get a redirection to the day's file, once you know what days are available from the list of exported days.
Once you have the redirection, you can fetch the file. The redirection is of the format:
_10https://documentation-example-twilio-bucket/daily/day%3D2020-02-02/type%3DMessages/account%3DACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/created_time%3D20200202000014/part-0XXXXXXXXXX0.json.gz?X-Amz-Security-Token=IQoXXXXXXXXH1GQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200202T012341Z&X-Amz-SignedHeaders=host&X-Amz-Expires=240&X-Amz-Credential=AXXXXXXXXXXX22%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=bXXXXXXXXX9
This link is a one-time use signed S3 link to the file. You can request these links multiple times from the API above, but each link can only be used once.
The file is compressed using gzip. You can use a command line tool to gunzip the file, or utilities in your language like Java's GZIPInputStream or GZipStream in C#.
Inside the file, messages are contained, with JSON equivalent to the Message Resource. These are of the format
_16{_16"date_updated": "2020-01-013T03:57:34Z",_16"date_sent": "2020-01-01T03:57:33Z",_16"date_created": "2020-01-01T03:57:32Z",_16"body": "Sent from your Twilio trial account - woot woot!!!!",_16"num_segments": 1,_16"sid": "SM32743c2e9c251806c2317dee566f6d7b",_16"num_media": 0,_16"messaging_service_sid": "MG1ef70550624e8b354860a98d787ee1f1",_16"account_sid": "ACa674802ceae35ad19498be749e085991",_16"from": "+14155551212",_16"error_code": null,_16"to": "+14155552389",_16"status": "delivered",_16"direction": "outbound-api"_16}
This will be repeated per message for that day.
GET https://bulkexports.twilio.com/v1/Exports/{ResourceType}/Days{ResourceType} is the type of Twilio resource, one of Calls or Messages. The Developer Preview release of Day supports exporting Messages only.
ResourceTypetype: stringThe type of communication – Messages, Calls, Conferences, and Participants
PageSizetype: integerHow many resources to return in each list page. The default is 50, and the maximum is 1000.
This will get the list of the exported days. There will be one day json block per day of exported data.