Daily Feeds
Files transfer
We require a daily feed to be uploaded into a dedicated S3 folder created for your platform. Please contact Bouquet.ai for its setup.
Protection
This folder, hosted on Bouquet’s AWS account is explicitelly restricted on your IAM role to ensure privacy
Files format & naming
Please ensure to use the following format when generating files for the daily feed:
File encoding : UTF-8 only
File compression: Always compressed in GZIP
Rows format: Delimited
Separator: ',' (comma)
Field delimiter (text only): '"' (double quote)
Date format: YYYY-MM-DD
Timestamp format YYYY-MM-DD HH24:mm:SS.FFF in UTC time zone
Boolean format: 0 (false) & 1 (true) only
Null values: leave field blank
Decimal separator: '.' (dot)
Escape char: '\' (please escape the field delimiter & the escape char within delimited fields )
Header: fields name on top , they can follow your own naming convention
Please generate file names as follow: YYYYMMDD_tablename.csv.gz
tablename is one of the following value :
"retrieval",
"search" or "search_detail",
"account", "account_hierarchy", "article", "content", "database", "collection", "publisher", "application", "format"
"subscription", "subscription_suspension","subscription_exception","database_content"