Query Data Table values with a request body

POST/lokta-lms/api/v1/datatables/{datatable}/query

Queries a registered data table using the filters supplied in the request body.

Query values from a registered data table.

Path parameters

datatablepath · string · required

datatable

Request body application/json

dateFormatstring · optional

dateTimeFormatstring · optional

localestring · optional

localeObjectobject · optional

pageinteger · int32 · optional

requestAdvancedQueryData · optional

sizeinteger · int32 · optional

sortsarray of SortOrder · optional

Responses

200OK

Every request authenticates with HTTP Basic and carries a Tenant-Identifier header. See the conventions for dates, commands, pagination and errors. Open this operation in the interactive explorer, or read it as Markdown.

This is the API reference for Lokta, the agentic loan servicing platform. Go to lokta.ai

curl -X POST \ 'https://default.lokta.tech/lokta-lms/api/v1/datatables/{datatable}/query' \ -u '{username}:{password}' \ -H 'Tenant-Identifier: default' \ -H 'Content-Type: application/json' \ -d '{ "dateFormat": "dd MMMM yyyy", "dateTimeFormat": "19 August 2026", "locale": "en", "localeObject": { "country": "string", "displayCountry": "string", "displayLanguage": "string", "displayName": "string" }, "page": 1, "request": { "columnFilters": [ {} ], "nonNullFilters": [ {} ], "nonNullResultColumns": [ "string" ], "resultColumns": [ "string" ] }, "size": 1, "sorts": [ { "direction": "ASC", "property": "string" } ] }'

import requests response = requests.post( "https://default.lokta.tech/lokta-lms/api/v1/datatables/{datatable}/query", auth=("{username}", "{password}"), headers={"Tenant-Identifier": "default"}, json={ "dateFormat": "dd MMMM yyyy", "dateTimeFormat": "19 August 2026", "locale": "en", "localeObject": { "country": "string", "displayCountry": "string", "displayLanguage": "string", "displayName": "string" }, "page": 1, "request": { "columnFilters": [ {} ], "nonNullFilters": [ {} ], "nonNullResultColumns": [ "string" ], "resultColumns": [ "string" ] }, "size": 1, "sorts": [ { "direction": "ASC", "property": "string" } ] }, ) print(response.json())

const response = await fetch("https://default.lokta.tech/lokta-lms/api/v1/datatables/{datatable}/query", { method: "POST", headers: { Authorization: "Basic " + Buffer.from("{username}:{password}").toString("base64"), "Tenant-Identifier": "default", "Content-Type": "application/json", }, body: JSON.stringify({ "dateFormat": "dd MMMM yyyy", "dateTimeFormat": "19 August 2026", "locale": "en", "localeObject": { "country": "string", "displayCountry": "string", "displayLanguage": "string", "displayName": "string" }, "page": 1, "request": { "columnFilters": [ {} ], "nonNullFilters": [ {} ], "nonNullResultColumns": [ "string" ], "resultColumns": [ "string" ] }, "size": 1, "sorts": [ { "direction": "ASC", "property": "string" } ] }), }); console.log(await response.json());

HttpClient client = HttpClient.newHttpClient(); HttpRequest request = HttpRequest.newBuilder() .uri(URI.create("https://default.lokta.tech/lokta-lms/api/v1/datatables/{datatable}/query")) .header("Authorization", "Basic " + Base64.getEncoder().encodeToString("{username}:{password}".getBytes())) .header("Tenant-Identifier", "default") .header("Content-Type", "application/json") .method("POST", HttpRequest.BodyPublishers.ofString(""" { "dateFormat": "dd MMMM yyyy", "dateTimeFormat": "19 August 2026", "locale": "en", "localeObject": { "country": "string", "displayCountry": "string", "displayLanguage": "string", "displayName": "string" }, "page": 1, "request": { "columnFilters": [ {} ], "nonNullFilters": [ {} ], "nonNullResultColumns": [ "string" ], "resultColumns": [ "string" ] }, "size": 1, "sorts": [ { "direction": "ASC", "property": "string" } ] } """)) .build(); HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString()); System.out.println(response.body());

payload := strings.NewReader(`{ "dateFormat": "dd MMMM yyyy", "dateTimeFormat": "19 August 2026", "locale": "en", "localeObject": { "country": "string", "displayCountry": "string", "displayLanguage": "string", "displayName": "string" }, "page": 1, "request": { "columnFilters": [ {} ], "nonNullFilters": [ {} ], "nonNullResultColumns": [ "string" ], "resultColumns": [ "string" ] }, "size": 1, "sorts": [ { "direction": "ASC", "property": "string" } ] }`) req, _ := http.NewRequest("POST", "https://default.lokta.tech/lokta-lms/api/v1/datatables/{datatable}/query", payload) req.SetBasicAuth("{username}", "{password}") req.Header.Set("Tenant-Identifier", "default") req.Header.Set("Content-Type", "application/json") res, _ := http.DefaultClient.Do(req) defer res.Body.Close() data, _ := io.ReadAll(res.Body) fmt.Println(string(data))