POST

Find Items


Get a list of items based on a filter

Body Params
skipinteger

The number of items to skip from the first item.


collectionNamestring

The collection or table to be queried.


limitinteger

The maximum number of items to retrieve

Response Object
itemsArray <struct>

A list of objects containing the retrieved items.


totalCountinteger

The total number of items matching the query filter.

Get data matching a filter from a collection
Request
cURL
curl -X POST 'https://mysql-adapter.com/data/find' \ --header 'Content-Type: application/json' \ --data-raw '{ "requestContext": { "settings": { "secretKey": "mySecureSecret" }, "instanceId": "12a345b6-7890-98d7-65e4-f321abc1de23", "installationId": "987fe654-3d21-4def-ab5c-6d78e90f123a", "memberId": "77aa88bb-2c2c-d3d3-4e4e-ff55aa66bb77", "role": "OWNER" }, "collectionName": "car", "filter": { "operator": "$and", "value": [ { "operator": "$contains", "fieldName": "make", "value": "a" }, { "operator": "$gt", "fieldName": "year", "value": 2018 } ] }, "sort": [ { "fieldName": "year", "direction": "asc" } ], "skip": 0, "limit": 10000 }'
Response
JSON
{ "items": [ { "_id": "95953ca3-5fe5-4ce7-9cca-9bcc1ba64ba6", "_owner": "77aa88bb-2c2c-d3d3-4e4e-ff55aa66bb77", "make": "Toyota", "model": "Corolla", "year": 2019, "date_added": { "$date": "2020-09-30T21:30:00.000Z" } }, { "_id": "20cd8f8d-1a0f-4530-91df-6d31fe9e83a5", "_owner": "77aa88bb-2c2c-d3d3-4e4e-ff55aa66bb77", "make": "Ferrari", "model": "812GTS", "year": 2020, "date_added": { "$date": "2020-03-31T21:00:00.000Z" } } ], "totalCount": 2 }
Errors

This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.

Did this help?