---
title: "Get List of Transaction Queries"
slug: "fetch-list-of-transaction-queries-for-a-given-publisher"
updated: 2024-07-16T17:09:53Z
published: 2024-07-16T17:09:53Z
canonical: "help.awin.com/fetch-list-of-transaction-queries-for-a-given-publisher"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.awin.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get List of Transaction Queries

Get/publisher/{publisherId}/transactionqueries

		
			

**GET transaction queries (list)**

Publishers can pull individual transaction queries, to check the status of the transaction query, create own reports, and pull additional information that can be shared between publishers and advertisers via clickref (from publisher to advertiser).

**Who can use it**

Publishers

		
		

Header parametersAuthorizationstring

accessToken

Path parameterspublisherIdinteger (int64) Required

publisherId

Query parametersadvertiserIdsarray of integer

A list of advertiser ids. 708226738,708226739,708226740...

clickRefsarray of string

A list of click refs. clickRef1,clickRef2,clickRef3...

dateTypestring

The date field to search date times on. If not supplied will default to transactionDate

Valid values[
  "\"enquiryDate\"",
  "\"transactionDate\"",
  "\"validationDate\""
]
endDatestring (date-time) Required

end date

Default"2021-03-15T01:59:59Z"
pageNumberinteger (int32) 

The page number to return. Defaults to 1 if not supplied

Minimum1
pageSizeinteger (int32) 

The number of results per page. Defaults to 100 if not supplied

Maximum500Minimum1
startDatestring (date-time) Required

start date

Default"2021-01-01T12:00:00Z"
statusesarray of string

A list of transaction query statuses to search for

Valid values[
  "\"pending\"",
  "\"approved\"",
  "\"declined\""
]
timezonestring

		
			

**Further details on query parameter** **Please note**: the maximum date range between startDate and endDate currently supported is 31 days.

| Parameter | Format | Mandatory/optional | Data Type |
| --- | --- | --- | --- |
| startDate | yyyy-MM-ddThh:mm:ss | mandatory | date-time |
| endDate | yyyy-MM-ddThh:mm:ss | mandatory | date-time |
| dateType | enquiryDate transactionDate validationDate | optional (falls back to "transactionDate" if not set) | string |
| timezone | Europe/Berlin Europe/Paris Europe/London Europe/Dublin Canada/Eastern Canada/Central Canada/Mountain Canada/Pacific US/Eastern US/Central US/Mountain US/Pacific UTC | mandatory | string |
| publisherId | 12345 | mandatory | integer(64) |
| advertiserId | 12345 or 12345,67890 for multiple ones | optional, available for publishers | array[integer] |
| statuses | pending approved declined pending,declined for multiple ones | optional | array[string] |
| clickRefs | clickRef1 or clickRef1 (value2),clickRef1 (value3 )for multiple ones | optional | array[string] |
| pageNumber | 3 | optional (Defaults to 1 if not supplied) | integer(32) |
| pageSize | 20 | optional (Defaults to 100 if not supplied) | integer(32) |

		
		

Responses200

OK

<select class='api-response-data' aria-label='Media type'><option value='5cc58883-75bb-46a9-97f2-839e7c7bec18'>application/json</option>
</select>Expand AllobjectpageItems Array of object (TransactionQuery) objectadvertiserIdinteger  (int32)   
advertiserNamestring   
clickRefstring   
commissionAmountobject (Amount)amountnumber   
currencystring   

declineReasonstring   
descriptionstring   
enquiryDatestring   
enquiryIdinteger   
enquiryStatusstring   Valid values[
  "\"pending\"",
  "\"approved\"",
  "\"declined\""
]
enquiryTypestring   Valid values[
  "\"declined\"",
  "\"incorrect\"",
  "\"untracked\""
]
orderRefstring   
saleAmountobject (Amount)amountnumber   
currencystring   

transactionDatestring   
validationDatestring   

pageNumberinteger  (int32)   
pageSizeinteger  (int32)   
totalPagesAvailableinteger  (int32)   
totalRowsAvailableinteger  (int32)   

		
			

**Common Error Messages**

Some errors appear when incorrect API values are parsed.

| Error Scenario | Error Message |
| --- | --- |
| Start date after end date | endDate cannot be before startDate |
| Start date greater than 31days | This endpoint only supports a date range of 31 days. Please adjust your startDate or endDate. |
| Using an invalid date type | Wrong data type for parameter 'dateType' |
| Using an invalid status type | Wrong data type for parameter 'statuses' |