Query template rules
curl --request POST \
--url https://sandbox.tight.com/v6/templates/rules/query \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"cursor": "<string>",
"limit": 123,
"sort": {},
"filter": {
"status": {
"in": [],
"notIn": []
},
"filter": {
"description": {
"equal": "<string>",
"notEqual": "<string>",
"greaterThan": "<string>",
"greaterThanEqual": "<string>",
"lessThan": "<string>",
"lessThanEqual": "<string>",
"contain": "<string>"
},
"amount": {
"equal": 123,
"notEqual": 123,
"greaterThan": 123,
"greaterThanEqual": 123,
"lessThan": 123,
"lessThanEqual": 123
},
"businessType": {
"id": {
"in": [
"<string>"
]
}
},
"templateGlAccount": {
"id": {
"in": [
"<string>"
]
}
},
"vendor": {
"equal": "<string>",
"notEqual": "<string>"
}
},
"update": {
"reviewStatus": {
"in": [],
"notIn": []
},
"templateGlAccount": {
"id": {
"in": [
"<string>"
]
}
},
"vendor": {
"equal": "<string>",
"notEqual": "<string>"
}
},
"lastAppliedDate": {
"equal": "2023-11-07T05:31:56Z",
"notEqual": "2023-11-07T05:31:56Z",
"greaterThan": "2023-11-07T05:31:56Z",
"greaterThanEqual": "2023-11-07T05:31:56Z",
"lessThan": "2023-11-07T05:31:56Z",
"lessThanEqual": "2023-11-07T05:31:56Z"
},
"matchCount": {
"equal": 123,
"notEqual": 123,
"greaterThan": 123,
"greaterThanEqual": 123,
"lessThan": 123,
"lessThanEqual": 123
}
}
}
'{
"data": [
{
"id": "ttrl_12345678",
"status": "ACTIVE",
"filter": {
"amount": {
"equal": 123,
"greaterThan": 123,
"greaterThanEqual": 123,
"lessThan": 123,
"lessThanEqual": 123
},
"description": {
"equal": "Office Supplies",
"contain": "Supplies"
},
"businessType": {
"id": {
"equal": "tgla_324231"
}
},
"templateGlAccount": {
"id": {
"equal": "tgla_324231"
}
},
"vendorName": {
"name": "Office Depot"
}
},
"update": {
"reviewStatus": "RECONCILED",
"templateGlAccountId": "tgla_324231",
"vendorName": "Office Depot"
},
"customData": {
"internal_key": "some_internal_key",
"some_other_field": 23434
}
}
],
"cursor": {
"after": "<string>",
"before": "<string>"
}
}Transaction Rules
Query template rules
Query template rules for the authenticated user
POST
/
v6
/
templates
/
rules
/
query
Query template rules
curl --request POST \
--url https://sandbox.tight.com/v6/templates/rules/query \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"cursor": "<string>",
"limit": 123,
"sort": {},
"filter": {
"status": {
"in": [],
"notIn": []
},
"filter": {
"description": {
"equal": "<string>",
"notEqual": "<string>",
"greaterThan": "<string>",
"greaterThanEqual": "<string>",
"lessThan": "<string>",
"lessThanEqual": "<string>",
"contain": "<string>"
},
"amount": {
"equal": 123,
"notEqual": 123,
"greaterThan": 123,
"greaterThanEqual": 123,
"lessThan": 123,
"lessThanEqual": 123
},
"businessType": {
"id": {
"in": [
"<string>"
]
}
},
"templateGlAccount": {
"id": {
"in": [
"<string>"
]
}
},
"vendor": {
"equal": "<string>",
"notEqual": "<string>"
}
},
"update": {
"reviewStatus": {
"in": [],
"notIn": []
},
"templateGlAccount": {
"id": {
"in": [
"<string>"
]
}
},
"vendor": {
"equal": "<string>",
"notEqual": "<string>"
}
},
"lastAppliedDate": {
"equal": "2023-11-07T05:31:56Z",
"notEqual": "2023-11-07T05:31:56Z",
"greaterThan": "2023-11-07T05:31:56Z",
"greaterThanEqual": "2023-11-07T05:31:56Z",
"lessThan": "2023-11-07T05:31:56Z",
"lessThanEqual": "2023-11-07T05:31:56Z"
},
"matchCount": {
"equal": 123,
"notEqual": 123,
"greaterThan": 123,
"greaterThanEqual": 123,
"lessThan": 123,
"lessThanEqual": 123
}
}
}
'{
"data": [
{
"id": "ttrl_12345678",
"status": "ACTIVE",
"filter": {
"amount": {
"equal": 123,
"greaterThan": 123,
"greaterThanEqual": 123,
"lessThan": 123,
"lessThanEqual": 123
},
"description": {
"equal": "Office Supplies",
"contain": "Supplies"
},
"businessType": {
"id": {
"equal": "tgla_324231"
}
},
"templateGlAccount": {
"id": {
"equal": "tgla_324231"
}
},
"vendorName": {
"name": "Office Depot"
}
},
"update": {
"reviewStatus": "RECONCILED",
"templateGlAccountId": "tgla_324231",
"vendorName": "Office Depot"
},
"customData": {
"internal_key": "some_internal_key",
"some_other_field": 23434
}
}
],
"cursor": {
"after": "<string>",
"before": "<string>"
}
}Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is a partner-level token.
Body
application/json
Response
Success
The result of the action performed.
Available options:
SUCCESS, FAILURE The data generated by the action performed.
Show child attributes
Show child attributes
Cursor to be used in your subsequent paginated request. Only populated if there are more pages available.
Show child attributes
Show child attributes
⌘I