Getting StartedUsertaskOrganization APIFacility APIAsset APISales PerformancePurchase APISales APIInventory APICRM APIPayroll APIAccount APICalendar APICommunication APISupport API
User & Role API
Membership API
Payment APIAttendance and Visitlog APICustomer API
Service API
- Service API Overview
- POSTGet Job Order
- POSTGet Facilitie Service data
- POSTGet Appointment Service
- GETGet Specific Job Order
- GETGet Specific Facilitie Service
- GETGet Specific Appointment Service
- PUTUpdate Appointment Service
- POSTAdd Job Order
- POSTAdd Facilitie Service Data
- POSTAdd Appointment Service
- PUTUpdate Job Order
- PUTUpdate Facilitie Service
- DELETEDelete Appointment Service
- DELETEDelete Job Order
- DELETEDelete Facilitie Service Data
- Facility API Overview
- POSTGet Faciltiy Booking Data
- POSTGet Facilitie Data
- GETGet Specific Facilitie data
- GETGet Specific Faciltiy Booking Data
- PUTUpdate Facilitiy Booking Data
- PUTUpdate Facilitie Data
- POSTAdd Facilitiy Booking Data
- POSTAdd Facilitie Data
- DELETEDelete Facilitie Data
- DELETEDelete Facilitiy Booking Data
- Purchase API Overview
- POSTGet Expense Voucher
- POSTGet Vendor Credit Note
- POSTGet Purchase Request Data
- POSTGet Purchase Order
- POSTGet Purchase Vendor
- POSTGet Purchase Bill
- GETGet Specific Purchase Request Data
- GETGet Specific Expense Voucher
- GETGet Specific Vendor Credit Note
- GETGet Specific Purchase Order
- GETGet Specific Purchase Vendor
- GETGet Specific Purchase Bill
- POSTAdd Purchase Bill
- POSTAdd Purchase Request Data
- POSTAdd Expense Voucher
- POSTAdd Vendor Credit Note
- POSTAdd Purchase Order
- POSTAdd Purchase Vendor
- PUTUpdate Purchase Bill
- DELETEDelete Purchase Request Data
- DELETEDelete Expense Voucher
- DELETEDelete Vendor Credit Note
- DELETEDelete Purchase Order
- DELETEDelete Purchase Vendor
- DELETEDelete Purchase Bill
- PUTUpdate Expenxe Voucher
- PUTUpdate Vendor Credit Note
- PUTUpdate Purchase Request Data
- PUTUpdate Purchase Order
- PUTUpdate Purchase Vendor
- Sales API Overview
- POSTGet Quotation
- POSTGet Credit Note
- POSTGet Sales Bills
- POSTGet Sales Order
- GETGet Specific Quotation
- GETGet Specific Sales Order
- GETGet Specific Sales Bills
- GETGet Specific Credit Note
- POSTAdd Quotation
- POSTAdd Sales Order
- POSTAdd Credit Note
- POSTAdd Sales Bills
- DELETEDelete Quotation
- DELETEDelete Sales Order
- DELETEDelete Credit Note
- DELETEDelete Sales Bills
- PUTUpdate Quotation
- PUTUpdate Credit Note
- PUTUpdate Sales Bills
- PUTUpdate Sales Order
- Inventory API Overview
- POSTGet Product Category Items
- POSTGet product Inventory items
- GETGet Specific product Inventory items
- GETGet Specific Product Category Items
- POSTAdd product Inventory items
- POSTAdd Product Category Items
- DELETEDelete product Inventory items
- DELETEDelete Product Category Items
- PUTUpdate Product Category Items
- PUTUpdate product Inventory items
- Payroll API Overview
- POSTGet Employee Salary
- POSTGet Salary Component
- POSTGet Leave Request
- POSTGet Leave Type
- GETGet specific Employee Salary
- GETGet specific Salary Component
- GETGet specific Leave Request
- GETGet specific Leave Type
- POSTAdd Employee Salary
- POSTAdd Salary Component
- POSTAdd Leave Request
- POSTAdd Leave Type
- PUTUpdate Employee Salary
- PUTUpdate Salary Component
- PUTUpdate Leave Request
- PUTUpdate Leave Type
- DELETEDelete Employee Salary
- DELETEDelete Salary Component
- DELETEDelete Leave Request
- DELETEDelete Leave Type
Get Faciltiy Booking Data
Purpose
To get the Booking/Location of your Organization.
Booking API accept post request with filter conditions. Response include filter booking array with matching conditions.
API return JSON array of bookings.
Request URL
https://live.membroz.com/api/facilitybookings/filter
Request Method
POST
Note
- Send authkey in https header
- You must use only Field API names in the input. You can obtain the field API names from Fields metadata API
- Enterprise customer can replace domain name with their hosting Url. for example https://app.xyz.com/api/facilitybookings
- API will return matching records in array or error message.
Request JSON
Attribute | Data Type | Mandatory | Description |
---|---|---|---|
search | Array | yes | Add search fields to filter out return data.
Example: { "search":[{ "searchfield": "status", "searchvalue": "active", "criteria": "eq", "datattype": "text" }]} Only status = "active" records will return |
select | Array | Add select fields to restrict return data schema.
Example: Example: { "fieldname": "branchname", "value": 1 } Only branchname will return |
|
sort | object | Sort return array based on sort input
Example: { "branchname" : 1} |
|
limit | number | limit return array size
Example: limit: 10 only 10 records will return in the array |
Sample Request
curl --location --request POST 'https://live.membroz.com/api/facilitybookings/filter' \
--header 'authkey: XXXXXXXXXX' \
--header 'Content-Type: application/json' \
--data-raw '{
"search": [
{"searchfield": "status", "searchvalue": "active", "criteria": "eq"}
],
"select": [
{ "fieldname": "occupants", "value": 1 },
{ "fieldname": "host", "value": 1 },
{ "fieldname": "charges", "value": 1 },
{ "fieldname": "addons", "value": 1 },
{ "fieldname": "walletTxnIds", "value": 1 },
{ "fieldname": "bookingdate", "value": 1 },
{ "fieldname": "startdate", "value": 1 },
{ "fieldname": "enddate", "value": 1 },
{ "fieldname": "facilityid", "value": 1 },
{ "fieldname": "customerid", "value": 1 },
{ "fieldname": "onModel", "value": 1 },
{ "fieldname": "quantity", "value": 1 },
{ "fieldname": "markingid", "value": 1 },
{ "fieldname": "totalrooms", "value": 1 },
{ "fieldname": "timeslotid", "value": 1 },
{ "fieldname": "timeslot", "value": 1 },
{ "fieldname": "totalnights", "value": 1 },
{ "fieldname": "status", "value": 1 },
{ "fieldname": "branchid", "value": 1 },
{ "fieldname": "total", "value": 1 },
{ "fieldname": "totalPay", "value": 1 }
]
}'
OkHttpClient client = new OkHttpClient().newBuilder()
.build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\r\n\t\"search\": [\r\n\t\t{\"searchfield\": \"status\", \"searchvalue\": \"active\", \"criteria\": \"eq\"}\r\n\t],\r\n\t\"select\": [\r\n\t\t{ \"fieldname\": \"occupants\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"host\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"charges\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"addons\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"walletTxnIds\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"bookingdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"startdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"enddate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"facilityid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"customerid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"onModel\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"quantity\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"markingid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalrooms\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslotid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslot\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalnights\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"status\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"branchid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"total\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalPay\", \"value\": 1 }\r\n\t]\r\n}");
Request request = new Request.Builder()
.url("https://live.membroz.com/api/facilitybookings/filter")
.method("POST", body)
.addHeader("authkey", "XXXXXXXXXX")
.addHeader("Content-Type", "application/json")
.build();
Response response = client.newCall(request).execute();
"https://live.membroz.com/api/facilitybookings/filter",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS =>"{\r\n\t\"search\": [\r\n\t\t{\"searchfield\": \"status\", \"searchvalue\": \"active\", \"criteria\": \"eq\"}\r\n\t],\r\n\t\"select\": [\r\n\t\t{ \"fieldname\": \"occupants\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"host\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"charges\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"addons\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"walletTxnIds\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"bookingdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"startdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"enddate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"facilityid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"customerid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"onModel\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"quantity\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"markingid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalrooms\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslotid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslot\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalnights\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"status\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"branchid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"total\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalPay\", \"value\": 1 }\r\n\t]\r\n}",
CURLOPT_HTTPHEADER => array(
"authkey: XXXXXXXXXX",
"Content-Type: application/json"
),
));
$response = curl_exec($curl);
curl_close($curl);
echo $response;
import requests
url = "https://live.membroz.com/api/facilitybookings/filter"
payload = "{\r\n\t\"search\": [\r\n\t\t{\"searchfield\": \"status\", \"searchvalue\": \"active\", \"criteria\": \"eq\"}\r\n\t],\r\n\t\"select\": [\r\n\t\t{ \"fieldname\": \"occupants\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"host\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"charges\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"addons\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"walletTxnIds\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"bookingdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"startdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"enddate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"facilityid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"customerid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"onModel\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"quantity\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"markingid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalrooms\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslotid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslot\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalnights\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"status\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"branchid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"total\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalPay\", \"value\": 1 }\r\n\t]\r\n}"
headers = {
'authkey': 'XXXXXXXXXX',
'Content-Type': 'application/json'
}
response = requests.request("POST", url, headers=headers, data = payload)
print(response.text.encode('utf8'))
require "uri"
require "net/http"
url = URI("https://live.membroz.com/api/facilitybookings/filter")
https = Net::HTTP.new(url.host, url.port);
https.use_ssl = true
request = Net::HTTP::Post.new(url)
request["authkey"] = "XXXXXXXXXX"
request["Content-Type"] = "application/json"
request.body = "{\r\n\t\"search\": [\r\n\t\t{\"searchfield\": \"status\", \"searchvalue\": \"active\", \"criteria\": \"eq\"}\r\n\t],\r\n\t\"select\": [\r\n\t\t{ \"fieldname\": \"occupants\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"host\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"charges\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"addons\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"walletTxnIds\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"bookingdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"startdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"enddate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"facilityid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"customerid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"onModel\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"quantity\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"markingid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalrooms\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslotid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslot\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalnights\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"status\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"branchid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"total\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalPay\", \"value\": 1 }\r\n\t]\r\n}"
response = https.request(request)
puts response.read_body
var client = new RestClient("https://live.membroz.com/api/facilitybookings/filter");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
request.AddHeader("authkey", "XXXXXXXXXX");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json", "{\r\n\t\"search\": [\r\n\t\t{\"searchfield\": \"status\", \"searchvalue\": \"active\", \"criteria\": \"eq\"}\r\n\t],\r\n\t\"select\": [\r\n\t\t{ \"fieldname\": \"occupants\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"host\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"charges\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"addons\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"walletTxnIds\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"bookingdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"startdate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"enddate\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"facilityid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"customerid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"onModel\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"quantity\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"markingid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalrooms\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslotid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"timeslot\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalnights\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"status\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"branchid\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"total\", \"value\": 1 },\r\n\t\t{ \"fieldname\": \"totalPay\", \"value\": 1 }\r\n\t]\r\n}", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);
Possible Errors
HTTP Status | Error Code | Message | Reason |
---|---|---|---|
permission denied | 403 | You do not have permission |
Sample Response
{
"_id": "5f240bf16df10f60d3356656",
"marking": {
"data": [
{
"staffcommission": 0,
"facility-type": "Workout",
"starttime": "08:00",
"endtime": "10:00",
"user_minute": 60,
"availability_duration": [
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday"
],
"availability_type": "timeslot_bases",
"price": "5f240bf26df10f60d335665c",
"user_facilitator": [
"5ef9faad91495422f0432999",
"5ed5011caaedf21d9092c9bb"
],
"id": "3557425e-de63-48db-b553-383297b9f42f",
"availability-timeslot": [
{
"id": "ff8f26d1-4a56-43ec-a43d-21391427359c",
"day": "Monday",
"starttime": "8:00",
"endtime": "9:00"
}
]
}
],
"subformid": "5bcff3a9f6955e00c8fba4d5"
},
"paymentmode": [],
"status": "active",
"title": "Weight loss session",
"facilitytype": "User",
"quantity": 1,
"branchid":"5e954c7b9df11624f81e7859",
"isInventory": true,
"createdAt": "2020-07-31T12:17:53.528Z",
"updatedAt": "2020-09-22T11:55:30.599Z",
"updatedby": "5e954c7b9df11624f81e785b"
}