Find a document number, order number, supplier number, name or keyword in a list and return the matching rows
find_in_listAICTIONBOT™ Status Answer by KULIC Advisory. Searches a list the user provides, for example open items, open purchase orders or a supplier list, for a document number, order number, supplier number, name or keyword and returns the matching rows with their column names. Number spellings are normalised: RE-01042, re 1042 and 1042 are the same number, and an exact number wins over partial hits. All columns are searched. Use it to answer where an invoice or an order stands. Deterministic, no AI, nothing stored. Needs sign-in: runs with an AICTIONBOT™ Werkbank licence; without a licence one check per connection every 30 days is free (sign in with “Connect without a licence”).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query": "<query>"
},
"name": "find_in_list"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | No | Alternative to rows: the list as CSV or tab-separated text. The first line is the header. | |
| rows | No | The list as rows: one object per row, column name to value. | |
| limit | No | Maximum number of rows returned. Default 10. | |
| query | Yes | What to look for: a number in any spelling, a name or a keyword. | |
| language | No | Language of the answer. Default de. |