API Reference

Flexible Query Records in a Form

post
https://embarc-api-qa.lendapi.com/embarc-core/api/v1/datatables//query

This endpoint allows performing advanced queries on a registered custom form, supporting pagination, sorting, and locale/date formatting. It is useful when filtering or retrieving large datasets with complex conditions.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required
Defaults to Extension

Accepted a created form name.

Example: Extension

Body Params
string
Defaults to dd MMMM yyyy

mandatory date format when a date field is used

Example: dd MMMM yyyy

string
Defaults to en

The locale of the customer. en will be passed as default .

Example: en

string
Defaults to 0

The first position of the pagination list start from 0.

Regex: ^\d+$

Example: 0

string
Defaults to 50

The number of items in the pagination list that being queried.

Regex: ^\d+$

Example: 20

sorts
array of objects

sort by ascending or descending and order by any available searching query parameters.

sorts
request
object
Headers
string
required
Defaults to default
Response

Updated 7 months ago

Did this page help you?
Language
Credentials
Bearer
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 7 months ago

Did this page help you?