curl --request POST \
  --url https://sandbox.tight.com/v6/payroll/query \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "cursor": "<string>",
  "limit": 123,
  "sort": {
    "orderBy": "DATE"
  },
  "filter": {
    "date": {
      "equal": "2023-12-25",
      "notEqual": "2023-12-25",
      "greaterThan": "2023-12-25",
      "greaterThanEqual": "2023-12-25",
      "lessThan": "2023-12-25",
      "lessThanEqual": "2023-12-25"
    },
    "amount": {
      "equal": 123,
      "notEqual": 123,
      "greaterThan": 123,
      "greaterThanEqual": 123,
      "lessThan": 123,
      "lessThanEqual": 123
    },
    "description": {
      "equal": "<string>",
      "notEqual": "<string>",
      "greaterThan": "<string>",
      "greaterThanEqual": "<string>",
      "lessThan": "<string>",
      "lessThanEqual": "<string>",
      "contain": "<string>"
    },
    "status": {
      "in": [],
      "notIn": []
    },
    "apiName": {
      "in": [],
      "notIn": []
    },
    "glAccount": {
      "expand": true
    },
    "dimensionValues": {
      "expand": true
    },
    "reconciliationMatch": {
      "expand": true
    },
    "company": {
      "in": [
        "co_123",
        "co_456"
      ]
    }
  }
}
'

import requests

url = "https://sandbox.tight.com/v6/payroll/query"

payload = {
    "cursor": "<string>",
    "limit": 123,
    "sort": { "orderBy": "DATE" },
    "filter": {
        "date": {
            "equal": "2023-12-25",
            "notEqual": "2023-12-25",
            "greaterThan": "2023-12-25",
            "greaterThanEqual": "2023-12-25",
            "lessThan": "2023-12-25",
            "lessThanEqual": "2023-12-25"
        },
        "amount": {
            "equal": 123,
            "notEqual": 123,
            "greaterThan": 123,
            "greaterThanEqual": 123,
            "lessThan": 123,
            "lessThanEqual": 123
        },
        "description": {
            "equal": "<string>",
            "notEqual": "<string>",
            "greaterThan": "<string>",
            "greaterThanEqual": "<string>",
            "lessThan": "<string>",
            "lessThanEqual": "<string>",
            "contain": "<string>"
        },
        "status": {
            "in": [],
            "notIn": []
        },
        "apiName": {
            "in": [],
            "notIn": []
        },
        "glAccount": { "expand": True },
        "dimensionValues": { "expand": True },
        "reconciliationMatch": { "expand": True },
        "company": { "in": ["co_123", "co_456"] }
    }
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    cursor: '<string>',
    limit: 123,
    sort: {orderBy: 'DATE'},
    filter: {
      date: {
        equal: '2023-12-25',
        notEqual: '2023-12-25',
        greaterThan: '2023-12-25',
        greaterThanEqual: '2023-12-25',
        lessThan: '2023-12-25',
        lessThanEqual: '2023-12-25'
      },
      amount: {
        equal: 123,
        notEqual: 123,
        greaterThan: 123,
        greaterThanEqual: 123,
        lessThan: 123,
        lessThanEqual: 123
      },
      description: {
        equal: '<string>',
        notEqual: '<string>',
        greaterThan: '<string>',
        greaterThanEqual: '<string>',
        lessThan: '<string>',
        lessThanEqual: '<string>',
        contain: '<string>'
      },
      status: {in: [], notIn: []},
      apiName: {in: [], notIn: []},
      glAccount: {expand: true},
      dimensionValues: {expand: true},
      reconciliationMatch: {expand: true},
      company: {in: ['co_123', 'co_456']}
    }
  })
};

fetch('https://sandbox.tight.com/v6/payroll/query', 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://sandbox.tight.com/v6/payroll/query",
  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([
    'cursor' => '<string>',
    'limit' => 123,
    'sort' => [
        'orderBy' => 'DATE'
    ],
    'filter' => [
        'date' => [
                'equal' => '2023-12-25',
                'notEqual' => '2023-12-25',
                'greaterThan' => '2023-12-25',
                'greaterThanEqual' => '2023-12-25',
                'lessThan' => '2023-12-25',
                'lessThanEqual' => '2023-12-25'
        ],
        'amount' => [
                'equal' => 123,
                'notEqual' => 123,
                'greaterThan' => 123,
                'greaterThanEqual' => 123,
                'lessThan' => 123,
                'lessThanEqual' => 123
        ],
        'description' => [
                'equal' => '<string>',
                'notEqual' => '<string>',
                'greaterThan' => '<string>',
                'greaterThanEqual' => '<string>',
                'lessThan' => '<string>',
                'lessThanEqual' => '<string>',
                'contain' => '<string>'
        ],
        'status' => [
                'in' => [
                                
                ],
                'notIn' => [
                                
                ]
        ],
        'apiName' => [
                'in' => [
                                
                ],
                'notIn' => [
                                
                ]
        ],
        'glAccount' => [
                'expand' => true
        ],
        'dimensionValues' => [
                'expand' => true
        ],
        'reconciliationMatch' => [
                'expand' => true
        ],
        'company' => [
                'in' => [
                                'co_123',
                                'co_456'
                ]
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$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://sandbox.tight.com/v6/payroll/query"

	payload := strings.NewReader("{\n  \"cursor\": \"<string>\",\n  \"limit\": 123,\n  \"sort\": {\n    \"orderBy\": \"DATE\"\n  },\n  \"filter\": {\n    \"date\": {\n      \"equal\": \"2023-12-25\",\n      \"notEqual\": \"2023-12-25\",\n      \"greaterThan\": \"2023-12-25\",\n      \"greaterThanEqual\": \"2023-12-25\",\n      \"lessThan\": \"2023-12-25\",\n      \"lessThanEqual\": \"2023-12-25\"\n    },\n    \"amount\": {\n      \"equal\": 123,\n      \"notEqual\": 123,\n      \"greaterThan\": 123,\n      \"greaterThanEqual\": 123,\n      \"lessThan\": 123,\n      \"lessThanEqual\": 123\n    },\n    \"description\": {\n      \"equal\": \"<string>\",\n      \"notEqual\": \"<string>\",\n      \"greaterThan\": \"<string>\",\n      \"greaterThanEqual\": \"<string>\",\n      \"lessThan\": \"<string>\",\n      \"lessThanEqual\": \"<string>\",\n      \"contain\": \"<string>\"\n    },\n    \"status\": {\n      \"in\": [],\n      \"notIn\": []\n    },\n    \"apiName\": {\n      \"in\": [],\n      \"notIn\": []\n    },\n    \"glAccount\": {\n      \"expand\": true\n    },\n    \"dimensionValues\": {\n      \"expand\": true\n    },\n    \"reconciliationMatch\": {\n      \"expand\": true\n    },\n    \"company\": {\n      \"in\": [\n        \"co_123\",\n        \"co_456\"\n      ]\n    }\n  }\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	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://sandbox.tight.com/v6/payroll/query")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"cursor\": \"<string>\",\n  \"limit\": 123,\n  \"sort\": {\n    \"orderBy\": \"DATE\"\n  },\n  \"filter\": {\n    \"date\": {\n      \"equal\": \"2023-12-25\",\n      \"notEqual\": \"2023-12-25\",\n      \"greaterThan\": \"2023-12-25\",\n      \"greaterThanEqual\": \"2023-12-25\",\n      \"lessThan\": \"2023-12-25\",\n      \"lessThanEqual\": \"2023-12-25\"\n    },\n    \"amount\": {\n      \"equal\": 123,\n      \"notEqual\": 123,\n      \"greaterThan\": 123,\n      \"greaterThanEqual\": 123,\n      \"lessThan\": 123,\n      \"lessThanEqual\": 123\n    },\n    \"description\": {\n      \"equal\": \"<string>\",\n      \"notEqual\": \"<string>\",\n      \"greaterThan\": \"<string>\",\n      \"greaterThanEqual\": \"<string>\",\n      \"lessThan\": \"<string>\",\n      \"lessThanEqual\": \"<string>\",\n      \"contain\": \"<string>\"\n    },\n    \"status\": {\n      \"in\": [],\n      \"notIn\": []\n    },\n    \"apiName\": {\n      \"in\": [],\n      \"notIn\": []\n    },\n    \"glAccount\": {\n      \"expand\": true\n    },\n    \"dimensionValues\": {\n      \"expand\": true\n    },\n    \"reconciliationMatch\": {\n      \"expand\": true\n    },\n    \"company\": {\n      \"in\": [\n        \"co_123\",\n        \"co_456\"\n      ]\n    }\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://sandbox.tight.com/v6/payroll/query")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"cursor\": \"<string>\",\n  \"limit\": 123,\n  \"sort\": {\n    \"orderBy\": \"DATE\"\n  },\n  \"filter\": {\n    \"date\": {\n      \"equal\": \"2023-12-25\",\n      \"notEqual\": \"2023-12-25\",\n      \"greaterThan\": \"2023-12-25\",\n      \"greaterThanEqual\": \"2023-12-25\",\n      \"lessThan\": \"2023-12-25\",\n      \"lessThanEqual\": \"2023-12-25\"\n    },\n    \"amount\": {\n      \"equal\": 123,\n      \"notEqual\": 123,\n      \"greaterThan\": 123,\n      \"greaterThanEqual\": 123,\n      \"lessThan\": 123,\n      \"lessThanEqual\": 123\n    },\n    \"description\": {\n      \"equal\": \"<string>\",\n      \"notEqual\": \"<string>\",\n      \"greaterThan\": \"<string>\",\n      \"greaterThanEqual\": \"<string>\",\n      \"lessThan\": \"<string>\",\n      \"lessThanEqual\": \"<string>\",\n      \"contain\": \"<string>\"\n    },\n    \"status\": {\n      \"in\": [],\n      \"notIn\": []\n    },\n    \"apiName\": {\n      \"in\": [],\n      \"notIn\": []\n    },\n    \"glAccount\": {\n      \"expand\": true\n    },\n    \"dimensionValues\": {\n      \"expand\": true\n    },\n    \"reconciliationMatch\": {\n      \"expand\": true\n    },\n    \"company\": {\n      \"in\": [\n        \"co_123\",\n        \"co_456\"\n      ]\n    }\n  }\n}"

response = http.request(request)
puts response.read_body

{
  "result": "SUCCESS",
  "data": [
    {
      "id": "prl_12345",
      "status": "ACTIVE",
      "reviewStatus": "RECONCILED",
      "date": "2024-01-15",
      "checkDate": "2024-01-18",
      "processedDate": "2024-01-15",
      "amount": 3000000,
      "description": "Payroll Period 01/01/2024 - 01/15/2024",
      "notes": "Check #1234 issued 2024-01-15",
      "apiName": "GUSTO",
      "apiSourceId": "gst_payroll_20240115",
      "children": [
        {
          "id": "pli_12345",
          "apiItemId": "item_123",
          "type": "OFFICER_EMPLOYEE_NET_PAY",
          "liabilityGlAccount": {
            "id": "gla_38560327",
            "name": "Officer(s) Salaries and Wages",
            "accountNo": "60210",
            "type": "EXPENSE",
            "iconUrl": "https://cdn.sandbox.tight.com/icons/glAccountTypes/expense.png",
            "displayName": "#60210 Officer(s) Salaries and Wages"
          },
          "expenseGlAccount": {
            "id": "gla_38560327",
            "name": "Officer(s) Salaries and Wages",
            "accountNo": "60210",
            "type": "EXPENSE",
            "iconUrl": "https://cdn.sandbox.tight.com/icons/glAccountTypes/expense.png",
            "displayName": "#60210 Officer(s) Salaries and Wages"
          },
          "dimensionValues": [
            {
              "id": "dv_593051",
              "dimension": {
                "id": "dim_4521",
                "name": "Region",
                "requiredness": "NOT_REQUIRED"
              },
              "name": "Mid-Atlantic",
              "child": {
                "id": "dv_593052",
                "dimension": {
                  "id": "dim_4521",
                  "name": "Region",
                  "requiredness": "NOT_REQUIRED"
                },
                "name": "Washington DC",
                "child": "<unknown>"
              }
            }
          ],
          "description": "Officer net pay",
          "amount": 500000,
          "reconciliationMatch": {
            "id": "<string>",
            "apiSourceId": "<string>",
            "amount": 123,
            "date": "2023-12-25",
            "description": "<string>",
            "apiName": "BOX",
            "apiInstitutionId": "<string>",
            "bankAccount": {
              "id": "bka_7542850",
              "name": "Business Checking",
              "displayName": "Business Checking *1687"
            }
          }
        }
      ],
      "customData": {
        "internal_key": "some_internal_key",
        "some_other_field": 23434
      }
    }
  ],
  "cursor": {
    "after": "<string>",
    "before": "<string>"
  }
}

{
  "result": "FAILURE",
  "error": [
    {
      "type": "REQUIRED",
      "message": "Amount is required",
      "param": "amount"
    }
  ]
}

{
  "result": "FAILURE",
  "error": [
    {
      "type": "INVALID_TOKEN",
      "message": "Invalid access token"
    }
  ]
}

{
  "result": "FAILURE",
  "error": [
    {
      "type": "FORBIDDEN",
      "message": "Expired access token"
    }
  ]
}

{
  "result": "FAILURE",
  "error": [
    {
      "type": "BAD_REQUEST",
      "message": "Resource not found"
    }
  ]
}

{
  "result": "FAILURE",
  "error": [
    {
      "type": "UNKNOWN_ERROR",
      "message": "Something went wrong. Please try again later."
    }
  ]
}