# Transaction Query by Date

This functionality is intended to return all transactions for a specific date.

Optionally, you can filter by a specific period (based on start time and end time), or by a
terminal in specific.

In GW/Express platform queries, it is possible to filter transactions by a specific customer,
sending the client code parameter.

The key consists of the fields:
- **Transaction date**
- **Start time**
- **End time**
- **POS number**
- **Customer Code** (only on GW/Express platform)

## Call details

- **Method:** `GET`
- **URL:** `basic URL + transactions/buscadata?datatrn=aaaammdd`
- **Answer:** Transaction List (see [Transaction List](retornos-requisicoes.md#lista-de-transacoes))
- **Description of URL parameters:**

| Field | Description | Type | Size | Format | Required |
| --- | --- | --- | :---: | --- | :---: |
| **datatrn** | Transaction date | Numeric | 8 | YYYYMMDD | Yes |
| **horainicial** | Search -  start time | Numeric | 6 | HHMMSS | No |
| **horafinal** | Search - end time | Numeric |6 | HHMMSS | No |
| **numpdv** | Identificação do terminal PDV | Alfanumérico | 1 -8 | - | Não |
| **codigo_cliente** | Customer code | Numeric | **1-19** | - | No* |
>\* The customer_code will only be used on SiTef GW/Express platform. Not used on costumers a SiTef-Conciliation 

>**Remark:**
> 
>The parameters ** start-time ** and ** end-time ** are not mandatory, but must always be together, otherwise an error will be returned.

>**Remark:**
>
>In addition to the transactions carried out, the service **Query transactions by date** searches for transactions whose pending issues were resolved on the search date, as well as transactions that were canceled on that date.