Advanced transaction search
curl --request POST \
--url https://test.paysight.io/api/transactions/search \
--header 'Authorization: <api-key>' \
--header 'ClientId: <clientid>' \
--header 'Content-Type: application/json' \
--header 'UserEmail: <useremail>' \
--data '
{
"pageNumber": 123,
"limit": 123,
"emails": [
"<string>"
],
"orderIds": [
123
],
"transactionIds": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"gatewayTransactionIds": [
"<string>"
],
"bin": "<string>",
"last4": "<string>",
"firstName": "<string>",
"lastName": "<string>",
"phoneNumbers": [
"<string>"
],
"authCodes": [
"<string>"
],
"currency": "<string>",
"dateFrom": "2023-12-25",
"dateTo": "2023-12-25",
"descriptorContains": "<string>",
"descriptorExactMatch": "<string>",
"mid": "<string>",
"sandbox": true,
"shopIds": [
123
],
"applicationIds": [
123
],
"productIds": [
123
],
"campaignIds": [
123
],
"merchantAccountIds": [
123
],
"companyIds": [
123
],
"amounts": [
123
],
"subscriptionIds": [
123
],
"affiliateIds": [
123
],
"mostRecentFirst": true,
"statusIds": [
123
],
"dateCompleted": true,
"gatewayIds": [
123
],
"paymentNumbers": [
123
],
"attempts": [
123
],
"cardBrandIds": [
123
]
}
'import requests
url = "https://test.paysight.io/api/transactions/search"
payload = {
"pageNumber": 123,
"limit": 123,
"emails": ["<string>"],
"orderIds": [123],
"transactionIds": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"gatewayTransactionIds": ["<string>"],
"bin": "<string>",
"last4": "<string>",
"firstName": "<string>",
"lastName": "<string>",
"phoneNumbers": ["<string>"],
"authCodes": ["<string>"],
"currency": "<string>",
"dateFrom": "2023-12-25",
"dateTo": "2023-12-25",
"descriptorContains": "<string>",
"descriptorExactMatch": "<string>",
"mid": "<string>",
"sandbox": True,
"shopIds": [123],
"applicationIds": [123],
"productIds": [123],
"campaignIds": [123],
"merchantAccountIds": [123],
"companyIds": [123],
"amounts": [123],
"subscriptionIds": [123],
"affiliateIds": [123],
"mostRecentFirst": True,
"statusIds": [123],
"dateCompleted": True,
"gatewayIds": [123],
"paymentNumbers": [123],
"attempts": [123],
"cardBrandIds": [123]
}
headers = {
"ClientId": "<clientid>",
"UserEmail": "<useremail>",
"Authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {
ClientId: '<clientid>',
UserEmail: '<useremail>',
Authorization: '<api-key>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
pageNumber: 123,
limit: 123,
emails: ['<string>'],
orderIds: [123],
transactionIds: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
gatewayTransactionIds: ['<string>'],
bin: '<string>',
last4: '<string>',
firstName: '<string>',
lastName: '<string>',
phoneNumbers: ['<string>'],
authCodes: ['<string>'],
currency: '<string>',
dateFrom: '2023-12-25',
dateTo: '2023-12-25',
descriptorContains: '<string>',
descriptorExactMatch: '<string>',
mid: '<string>',
sandbox: true,
shopIds: [123],
applicationIds: [123],
productIds: [123],
campaignIds: [123],
merchantAccountIds: [123],
companyIds: [123],
amounts: [123],
subscriptionIds: [123],
affiliateIds: [123],
mostRecentFirst: true,
statusIds: [123],
dateCompleted: true,
gatewayIds: [123],
paymentNumbers: [123],
attempts: [123],
cardBrandIds: [123]
})
};
fetch('https://test.paysight.io/api/transactions/search', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://test.paysight.io/api/transactions/search",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'pageNumber' => 123,
'limit' => 123,
'emails' => [
'<string>'
],
'orderIds' => [
123
],
'transactionIds' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'gatewayTransactionIds' => [
'<string>'
],
'bin' => '<string>',
'last4' => '<string>',
'firstName' => '<string>',
'lastName' => '<string>',
'phoneNumbers' => [
'<string>'
],
'authCodes' => [
'<string>'
],
'currency' => '<string>',
'dateFrom' => '2023-12-25',
'dateTo' => '2023-12-25',
'descriptorContains' => '<string>',
'descriptorExactMatch' => '<string>',
'mid' => '<string>',
'sandbox' => true,
'shopIds' => [
123
],
'applicationIds' => [
123
],
'productIds' => [
123
],
'campaignIds' => [
123
],
'merchantAccountIds' => [
123
],
'companyIds' => [
123
],
'amounts' => [
123
],
'subscriptionIds' => [
123
],
'affiliateIds' => [
123
],
'mostRecentFirst' => true,
'statusIds' => [
123
],
'dateCompleted' => true,
'gatewayIds' => [
123
],
'paymentNumbers' => [
123
],
'attempts' => [
123
],
'cardBrandIds' => [
123
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: <api-key>",
"ClientId: <clientid>",
"Content-Type: application/json",
"UserEmail: <useremail>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://test.paysight.io/api/transactions/search"
payload := strings.NewReader("{\n \"pageNumber\": 123,\n \"limit\": 123,\n \"emails\": [\n \"<string>\"\n ],\n \"orderIds\": [\n 123\n ],\n \"transactionIds\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"gatewayTransactionIds\": [\n \"<string>\"\n ],\n \"bin\": \"<string>\",\n \"last4\": \"<string>\",\n \"firstName\": \"<string>\",\n \"lastName\": \"<string>\",\n \"phoneNumbers\": [\n \"<string>\"\n ],\n \"authCodes\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"dateFrom\": \"2023-12-25\",\n \"dateTo\": \"2023-12-25\",\n \"descriptorContains\": \"<string>\",\n \"descriptorExactMatch\": \"<string>\",\n \"mid\": \"<string>\",\n \"sandbox\": true,\n \"shopIds\": [\n 123\n ],\n \"applicationIds\": [\n 123\n ],\n \"productIds\": [\n 123\n ],\n \"campaignIds\": [\n 123\n ],\n \"merchantAccountIds\": [\n 123\n ],\n \"companyIds\": [\n 123\n ],\n \"amounts\": [\n 123\n ],\n \"subscriptionIds\": [\n 123\n ],\n \"affiliateIds\": [\n 123\n ],\n \"mostRecentFirst\": true,\n \"statusIds\": [\n 123\n ],\n \"dateCompleted\": true,\n \"gatewayIds\": [\n 123\n ],\n \"paymentNumbers\": [\n 123\n ],\n \"attempts\": [\n 123\n ],\n \"cardBrandIds\": [\n 123\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("ClientId", "<clientid>")
req.Header.Add("UserEmail", "<useremail>")
req.Header.Add("Authorization", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://test.paysight.io/api/transactions/search")
.header("ClientId", "<clientid>")
.header("UserEmail", "<useremail>")
.header("Authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"pageNumber\": 123,\n \"limit\": 123,\n \"emails\": [\n \"<string>\"\n ],\n \"orderIds\": [\n 123\n ],\n \"transactionIds\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"gatewayTransactionIds\": [\n \"<string>\"\n ],\n \"bin\": \"<string>\",\n \"last4\": \"<string>\",\n \"firstName\": \"<string>\",\n \"lastName\": \"<string>\",\n \"phoneNumbers\": [\n \"<string>\"\n ],\n \"authCodes\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"dateFrom\": \"2023-12-25\",\n \"dateTo\": \"2023-12-25\",\n \"descriptorContains\": \"<string>\",\n \"descriptorExactMatch\": \"<string>\",\n \"mid\": \"<string>\",\n \"sandbox\": true,\n \"shopIds\": [\n 123\n ],\n \"applicationIds\": [\n 123\n ],\n \"productIds\": [\n 123\n ],\n \"campaignIds\": [\n 123\n ],\n \"merchantAccountIds\": [\n 123\n ],\n \"companyIds\": [\n 123\n ],\n \"amounts\": [\n 123\n ],\n \"subscriptionIds\": [\n 123\n ],\n \"affiliateIds\": [\n 123\n ],\n \"mostRecentFirst\": true,\n \"statusIds\": [\n 123\n ],\n \"dateCompleted\": true,\n \"gatewayIds\": [\n 123\n ],\n \"paymentNumbers\": [\n 123\n ],\n \"attempts\": [\n 123\n ],\n \"cardBrandIds\": [\n 123\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://test.paysight.io/api/transactions/search")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["ClientId"] = '<clientid>'
request["UserEmail"] = '<useremail>'
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"pageNumber\": 123,\n \"limit\": 123,\n \"emails\": [\n \"<string>\"\n ],\n \"orderIds\": [\n 123\n ],\n \"transactionIds\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"gatewayTransactionIds\": [\n \"<string>\"\n ],\n \"bin\": \"<string>\",\n \"last4\": \"<string>\",\n \"firstName\": \"<string>\",\n \"lastName\": \"<string>\",\n \"phoneNumbers\": [\n \"<string>\"\n ],\n \"authCodes\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"dateFrom\": \"2023-12-25\",\n \"dateTo\": \"2023-12-25\",\n \"descriptorContains\": \"<string>\",\n \"descriptorExactMatch\": \"<string>\",\n \"mid\": \"<string>\",\n \"sandbox\": true,\n \"shopIds\": [\n 123\n ],\n \"applicationIds\": [\n 123\n ],\n \"productIds\": [\n 123\n ],\n \"campaignIds\": [\n 123\n ],\n \"merchantAccountIds\": [\n 123\n ],\n \"companyIds\": [\n 123\n ],\n \"amounts\": [\n 123\n ],\n \"subscriptionIds\": [\n 123\n ],\n \"affiliateIds\": [\n 123\n ],\n \"mostRecentFirst\": true,\n \"statusIds\": [\n 123\n ],\n \"dateCompleted\": true,\n \"gatewayIds\": [\n 123\n ],\n \"paymentNumbers\": [\n 123\n ],\n \"attempts\": [\n 123\n ],\n \"cardBrandIds\": [\n 123\n ]\n}"
response = http.request(request)
puts response.read_body{
"success": true,
"message": "<string>",
"count": 123,
"pageNumber": 123,
"moreResults": true,
"transactions": [
{
"gateway": "<string>",
"transactionId": "<string>",
"orderId": 123,
"sent": "2023-11-07T05:31:56Z",
"email": "<string>",
"sandbox": true,
"applicationId": 123,
"status": "<string>",
"statusId": 123,
"success": true,
"completed": "2023-11-07T05:31:56Z",
"currency": "<string>",
"amount": 123,
"mid": "<string>",
"descriptor": "<string>",
"customerId": 123,
"authCode": "<string>",
"gatewayTransactionId": "<string>",
"firstName": "<string>",
"lastName": "<string>",
"bin": "<string>",
"last4": "<string>",
"refunded": true,
"refundable": true,
"hasAlert": true,
"chargedBack": true,
"originalTransactionId": "<string>",
"application": "<string>",
"applicationId2": 123,
"application2": "<string>",
"shopId": 123,
"storeName": "<string>",
"storeDomain": "<string>",
"storeRootDomain": "<string>",
"originalApplicationId": 123,
"originalApplication": "<string>",
"merchantAccountId": 123,
"midName": "<string>",
"companyId": 123,
"company": "<string>",
"parentCompanyId": 123,
"subId": 123,
"refundSourceId": 123,
"alertTypeId": 123,
"alertSourceId": 123,
"submitOrderId": 123,
"alertSource": "<string>",
"alertType": "<string>",
"refundSource": "<string>",
"binCountry": "<string>",
"ipCountry": "<string>",
"campaignId": 123,
"campaign": "<string>",
"affiliateId": 123,
"affiliate": "<string>",
"productId": 123,
"product": "<string>",
"paymentNumber": 123,
"attempt": 123,
"containsSalesStrategy": true,
"bin8": "<string>",
"eci": "<string>",
"networkTokenized": true,
"chargebackFee": 123,
"cardBrandId": 123,
"cardBrand": "<string>",
"applePay": true,
"googlePay": true
}
]
}Transactions
Advanced transaction search
Searches for transactions using expanded filters such as transactionId, gatewayTransactionId, bin, authCodes, product and campaign filters.
POST
/
api
/
transactions
/
search
Advanced transaction search
curl --request POST \
--url https://test.paysight.io/api/transactions/search \
--header 'Authorization: <api-key>' \
--header 'ClientId: <clientid>' \
--header 'Content-Type: application/json' \
--header 'UserEmail: <useremail>' \
--data '
{
"pageNumber": 123,
"limit": 123,
"emails": [
"<string>"
],
"orderIds": [
123
],
"transactionIds": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"gatewayTransactionIds": [
"<string>"
],
"bin": "<string>",
"last4": "<string>",
"firstName": "<string>",
"lastName": "<string>",
"phoneNumbers": [
"<string>"
],
"authCodes": [
"<string>"
],
"currency": "<string>",
"dateFrom": "2023-12-25",
"dateTo": "2023-12-25",
"descriptorContains": "<string>",
"descriptorExactMatch": "<string>",
"mid": "<string>",
"sandbox": true,
"shopIds": [
123
],
"applicationIds": [
123
],
"productIds": [
123
],
"campaignIds": [
123
],
"merchantAccountIds": [
123
],
"companyIds": [
123
],
"amounts": [
123
],
"subscriptionIds": [
123
],
"affiliateIds": [
123
],
"mostRecentFirst": true,
"statusIds": [
123
],
"dateCompleted": true,
"gatewayIds": [
123
],
"paymentNumbers": [
123
],
"attempts": [
123
],
"cardBrandIds": [
123
]
}
'import requests
url = "https://test.paysight.io/api/transactions/search"
payload = {
"pageNumber": 123,
"limit": 123,
"emails": ["<string>"],
"orderIds": [123],
"transactionIds": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"gatewayTransactionIds": ["<string>"],
"bin": "<string>",
"last4": "<string>",
"firstName": "<string>",
"lastName": "<string>",
"phoneNumbers": ["<string>"],
"authCodes": ["<string>"],
"currency": "<string>",
"dateFrom": "2023-12-25",
"dateTo": "2023-12-25",
"descriptorContains": "<string>",
"descriptorExactMatch": "<string>",
"mid": "<string>",
"sandbox": True,
"shopIds": [123],
"applicationIds": [123],
"productIds": [123],
"campaignIds": [123],
"merchantAccountIds": [123],
"companyIds": [123],
"amounts": [123],
"subscriptionIds": [123],
"affiliateIds": [123],
"mostRecentFirst": True,
"statusIds": [123],
"dateCompleted": True,
"gatewayIds": [123],
"paymentNumbers": [123],
"attempts": [123],
"cardBrandIds": [123]
}
headers = {
"ClientId": "<clientid>",
"UserEmail": "<useremail>",
"Authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {
ClientId: '<clientid>',
UserEmail: '<useremail>',
Authorization: '<api-key>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
pageNumber: 123,
limit: 123,
emails: ['<string>'],
orderIds: [123],
transactionIds: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
gatewayTransactionIds: ['<string>'],
bin: '<string>',
last4: '<string>',
firstName: '<string>',
lastName: '<string>',
phoneNumbers: ['<string>'],
authCodes: ['<string>'],
currency: '<string>',
dateFrom: '2023-12-25',
dateTo: '2023-12-25',
descriptorContains: '<string>',
descriptorExactMatch: '<string>',
mid: '<string>',
sandbox: true,
shopIds: [123],
applicationIds: [123],
productIds: [123],
campaignIds: [123],
merchantAccountIds: [123],
companyIds: [123],
amounts: [123],
subscriptionIds: [123],
affiliateIds: [123],
mostRecentFirst: true,
statusIds: [123],
dateCompleted: true,
gatewayIds: [123],
paymentNumbers: [123],
attempts: [123],
cardBrandIds: [123]
})
};
fetch('https://test.paysight.io/api/transactions/search', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://test.paysight.io/api/transactions/search",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'pageNumber' => 123,
'limit' => 123,
'emails' => [
'<string>'
],
'orderIds' => [
123
],
'transactionIds' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'gatewayTransactionIds' => [
'<string>'
],
'bin' => '<string>',
'last4' => '<string>',
'firstName' => '<string>',
'lastName' => '<string>',
'phoneNumbers' => [
'<string>'
],
'authCodes' => [
'<string>'
],
'currency' => '<string>',
'dateFrom' => '2023-12-25',
'dateTo' => '2023-12-25',
'descriptorContains' => '<string>',
'descriptorExactMatch' => '<string>',
'mid' => '<string>',
'sandbox' => true,
'shopIds' => [
123
],
'applicationIds' => [
123
],
'productIds' => [
123
],
'campaignIds' => [
123
],
'merchantAccountIds' => [
123
],
'companyIds' => [
123
],
'amounts' => [
123
],
'subscriptionIds' => [
123
],
'affiliateIds' => [
123
],
'mostRecentFirst' => true,
'statusIds' => [
123
],
'dateCompleted' => true,
'gatewayIds' => [
123
],
'paymentNumbers' => [
123
],
'attempts' => [
123
],
'cardBrandIds' => [
123
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: <api-key>",
"ClientId: <clientid>",
"Content-Type: application/json",
"UserEmail: <useremail>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://test.paysight.io/api/transactions/search"
payload := strings.NewReader("{\n \"pageNumber\": 123,\n \"limit\": 123,\n \"emails\": [\n \"<string>\"\n ],\n \"orderIds\": [\n 123\n ],\n \"transactionIds\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"gatewayTransactionIds\": [\n \"<string>\"\n ],\n \"bin\": \"<string>\",\n \"last4\": \"<string>\",\n \"firstName\": \"<string>\",\n \"lastName\": \"<string>\",\n \"phoneNumbers\": [\n \"<string>\"\n ],\n \"authCodes\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"dateFrom\": \"2023-12-25\",\n \"dateTo\": \"2023-12-25\",\n \"descriptorContains\": \"<string>\",\n \"descriptorExactMatch\": \"<string>\",\n \"mid\": \"<string>\",\n \"sandbox\": true,\n \"shopIds\": [\n 123\n ],\n \"applicationIds\": [\n 123\n ],\n \"productIds\": [\n 123\n ],\n \"campaignIds\": [\n 123\n ],\n \"merchantAccountIds\": [\n 123\n ],\n \"companyIds\": [\n 123\n ],\n \"amounts\": [\n 123\n ],\n \"subscriptionIds\": [\n 123\n ],\n \"affiliateIds\": [\n 123\n ],\n \"mostRecentFirst\": true,\n \"statusIds\": [\n 123\n ],\n \"dateCompleted\": true,\n \"gatewayIds\": [\n 123\n ],\n \"paymentNumbers\": [\n 123\n ],\n \"attempts\": [\n 123\n ],\n \"cardBrandIds\": [\n 123\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("ClientId", "<clientid>")
req.Header.Add("UserEmail", "<useremail>")
req.Header.Add("Authorization", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://test.paysight.io/api/transactions/search")
.header("ClientId", "<clientid>")
.header("UserEmail", "<useremail>")
.header("Authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"pageNumber\": 123,\n \"limit\": 123,\n \"emails\": [\n \"<string>\"\n ],\n \"orderIds\": [\n 123\n ],\n \"transactionIds\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"gatewayTransactionIds\": [\n \"<string>\"\n ],\n \"bin\": \"<string>\",\n \"last4\": \"<string>\",\n \"firstName\": \"<string>\",\n \"lastName\": \"<string>\",\n \"phoneNumbers\": [\n \"<string>\"\n ],\n \"authCodes\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"dateFrom\": \"2023-12-25\",\n \"dateTo\": \"2023-12-25\",\n \"descriptorContains\": \"<string>\",\n \"descriptorExactMatch\": \"<string>\",\n \"mid\": \"<string>\",\n \"sandbox\": true,\n \"shopIds\": [\n 123\n ],\n \"applicationIds\": [\n 123\n ],\n \"productIds\": [\n 123\n ],\n \"campaignIds\": [\n 123\n ],\n \"merchantAccountIds\": [\n 123\n ],\n \"companyIds\": [\n 123\n ],\n \"amounts\": [\n 123\n ],\n \"subscriptionIds\": [\n 123\n ],\n \"affiliateIds\": [\n 123\n ],\n \"mostRecentFirst\": true,\n \"statusIds\": [\n 123\n ],\n \"dateCompleted\": true,\n \"gatewayIds\": [\n 123\n ],\n \"paymentNumbers\": [\n 123\n ],\n \"attempts\": [\n 123\n ],\n \"cardBrandIds\": [\n 123\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://test.paysight.io/api/transactions/search")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["ClientId"] = '<clientid>'
request["UserEmail"] = '<useremail>'
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"pageNumber\": 123,\n \"limit\": 123,\n \"emails\": [\n \"<string>\"\n ],\n \"orderIds\": [\n 123\n ],\n \"transactionIds\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"gatewayTransactionIds\": [\n \"<string>\"\n ],\n \"bin\": \"<string>\",\n \"last4\": \"<string>\",\n \"firstName\": \"<string>\",\n \"lastName\": \"<string>\",\n \"phoneNumbers\": [\n \"<string>\"\n ],\n \"authCodes\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"dateFrom\": \"2023-12-25\",\n \"dateTo\": \"2023-12-25\",\n \"descriptorContains\": \"<string>\",\n \"descriptorExactMatch\": \"<string>\",\n \"mid\": \"<string>\",\n \"sandbox\": true,\n \"shopIds\": [\n 123\n ],\n \"applicationIds\": [\n 123\n ],\n \"productIds\": [\n 123\n ],\n \"campaignIds\": [\n 123\n ],\n \"merchantAccountIds\": [\n 123\n ],\n \"companyIds\": [\n 123\n ],\n \"amounts\": [\n 123\n ],\n \"subscriptionIds\": [\n 123\n ],\n \"affiliateIds\": [\n 123\n ],\n \"mostRecentFirst\": true,\n \"statusIds\": [\n 123\n ],\n \"dateCompleted\": true,\n \"gatewayIds\": [\n 123\n ],\n \"paymentNumbers\": [\n 123\n ],\n \"attempts\": [\n 123\n ],\n \"cardBrandIds\": [\n 123\n ]\n}"
response = http.request(request)
puts response.read_body{
"success": true,
"message": "<string>",
"count": 123,
"pageNumber": 123,
"moreResults": true,
"transactions": [
{
"gateway": "<string>",
"transactionId": "<string>",
"orderId": 123,
"sent": "2023-11-07T05:31:56Z",
"email": "<string>",
"sandbox": true,
"applicationId": 123,
"status": "<string>",
"statusId": 123,
"success": true,
"completed": "2023-11-07T05:31:56Z",
"currency": "<string>",
"amount": 123,
"mid": "<string>",
"descriptor": "<string>",
"customerId": 123,
"authCode": "<string>",
"gatewayTransactionId": "<string>",
"firstName": "<string>",
"lastName": "<string>",
"bin": "<string>",
"last4": "<string>",
"refunded": true,
"refundable": true,
"hasAlert": true,
"chargedBack": true,
"originalTransactionId": "<string>",
"application": "<string>",
"applicationId2": 123,
"application2": "<string>",
"shopId": 123,
"storeName": "<string>",
"storeDomain": "<string>",
"storeRootDomain": "<string>",
"originalApplicationId": 123,
"originalApplication": "<string>",
"merchantAccountId": 123,
"midName": "<string>",
"companyId": 123,
"company": "<string>",
"parentCompanyId": 123,
"subId": 123,
"refundSourceId": 123,
"alertTypeId": 123,
"alertSourceId": 123,
"submitOrderId": 123,
"alertSource": "<string>",
"alertType": "<string>",
"refundSource": "<string>",
"binCountry": "<string>",
"ipCountry": "<string>",
"campaignId": 123,
"campaign": "<string>",
"affiliateId": 123,
"affiliate": "<string>",
"productId": 123,
"product": "<string>",
"paymentNumber": 123,
"attempt": 123,
"containsSalesStrategy": true,
"bin8": "<string>",
"eci": "<string>",
"networkTokenized": true,
"chargebackFee": 123,
"cardBrandId": 123,
"cardBrand": "<string>",
"applePay": true,
"googlePay": true
}
]
}Authorizations
Your Paysight API key. You can find it in your Paysight account at https://app.paysight.io/settings/account
Headers
Your Paysight Tenant/Client Id. This is the id of the parent company listed in https://app.paysight.io/management/companies. Alternatively, this will be provided by Paysight
The email address of the party or group making the request
Body
application/json
Request body for transaction search with flexible filters
The current page number for results. Defaults to 1 when omitted or set to 0.
The maximum number of results to return per page. Default is 100. Maximum is 5000.
Filter transactions by one or more customer emails
Filter by one or more order IDs
Filter by transaction UUIDs
Gateway-specific transaction identifiers
Bank Identification Number (first 6 digits)
Last 4 digits of card
Customer first name
Customer last name
Filter by one or more customer phone numbers. Each phone number must contain at least 6 characters.
Authorization codes
Currency code (e.g., USD)
Start of transaction date range
End of transaction date range
Substring search on the descriptor
Exact match search on the descriptor
Filter by merchant ID (MID)
If true, only return sandbox transactions
Filter by shop IDs
Filter by application ID
Filter by product ID
Filter by campaign ID
Filter by specific merchant account IDs
Filter by company IDs
Filter by specific transaction amounts
Filter by subscription IDs
Filter Affiliate (Traffic Source) Ids
If true, results are sorted by most recent transactions first
Paysight Status Ids
If true, timestamp of completion is used for date range filtering instead of sent timestamp
Filter by gateway IDs
Filter by subscription payment numbers
Filter by payment attempt numbers
Filter by card brand IDs
Response
200 - application/json
List of matching transactions
The response payload for transaction search endpoint
⌘I