CSV Direct Data
This endpoint allows direct extraction of collection data in CSV format. Since this endpoint is meant as a data source, to be used in external Business Intelligence tools, no authorization header need to be created for each call.
To successfully invoke this endpoint :
The following request shows how to extract a direct CSV from a collection
curl --location --request GET 'https://<API ROUTE>/data/direct/<COLLECTIONNAME>/<FIELDS>/<FILTER>' \
--header 'account-key: <ACCOUNT API KEY>' \
--header 'bot-key: <BOT API KEY>' \
--header 'bot-secret: <BOT API SECRET>' \
--header 'Content-Type: application/json' \
Please note that the collection API url proposed by Xenioo is not the direct data url. Use the example above when configuring your direct data url.
If successful, this call will return a complete CSV file containing all of the records affected by the supplied filter.
Response content is cached with a 30 minutes interval.
Only the fields specified in the <FIELDS> parameter will be returned. Multiple fields must be separated using a comma. Using * (asterisk) as a value for fields will export only the fields found in the very first record returned by the query.
This endpoint will reply with the following standard HTTP codes.