> For the complete documentation index, see [llms.txt](https://docs.xenioo.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xenioo.com/database/database-api-access/csv-direct-data.md). # 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. ### Requirements To successfully invoke this endpoint : 1. The Account API Key, Bot Token and Bot Secret must be sent in the request header 2. An active Database package must be active on the target account. 3. The desired [collection ](/database/collections.md)must exist and must be flagged as [accessible through API](/database/collections.md#enable-api-access). ### Request The following request shows how to extract a direct CSV from a collection ```bash curl --location --request GET 'https:///data//direct//' \ --header 'account-key: ' \ --header 'bot-key: ' \ --header 'bot-secret: ' \ --header 'Content-Type: application/json' \ ``` {% hint style="warning" %} Please note that this API purpose is not to access live data but for Excel statistical content. Data returned by this API is cached for up to 30 minutes and should not be considered live. {% endhint %} ### Response If successful, this call will return a complete CSV file containing all of the records affected by the supplied filter. Only the fields specified in the \ 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. ### Response Codes This endpoint will reply with the following standard HTTP codes. | Code | Meaning | | ---- | ------------------------------------------------------------------------- | | 200 | Ok. The request has been successfully fulfilled. | | 400 | Bad Request. The call does not contain the data required to be fulfilled. | | 404 | Not Found. The specified collection has not been found. | | 403 | Unauthorized. The specified collection cannot be access through API | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.xenioo.com/database/database-api-access/csv-direct-data.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.