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 Purchase Bill
Purpose
To get the purchasebill/Location of your Organization.
Purchasebill API accept post request with filter conditions. Response include filter purchasebills array with matching conditions.
API return JSON array of purchasebills.
Request URL
https://live.membroz.com/api/purchasebills/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/purchasebills
- 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/purchasebills/filter' \
--header 'authkey: XXXXXXXXXX' \
--header 'Content-Type: application/json' \
--data-raw '{
"search": [
{ "searchfield": "status", "searchvalue": "Paid", "criteria": "eq", "datatype": "text" }
]
}
'
OkHttpClient client = new OkHttpClient().newBuilder()
.build();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{ \r\n \"search\": [\r\n { \"searchfield\": \"status\", \"searchvalue\": \"Paid\", \"criteria\": \"eq\", \"datatype\": \"text\" }\r\n ]\r\n}\r\n");
Request request = new Request.Builder()
.url("https://live.membroz.com/api/purchasebills/filter")
.method("POST", body)
.addHeader("authkey", " XXXXXXXXXX'")
.addHeader("Content-Type", "application/json")
.build();
Response response = client.newCall(request).execute();
"https://live.membroz.com/api/purchasebills/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 \"search\": [\r\n { \"searchfield\": \"status\", \"searchvalue\": \"Paid\", \"criteria\": \"eq\", \"datatype\": \"text\" }\r\n ]\r\n}\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/purchasebills/filter"
payload = "{ \r\n \"search\": [\r\n { \"searchfield\": \"status\", \"searchvalue\": \"Paid\", \"criteria\": \"eq\", \"datatype\": \"text\" }\r\n ]\r\n}\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/purchasebills/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 \"search\": [\r\n { \"searchfield\": \"status\", \"searchvalue\": \"Paid\", \"criteria\": \"eq\", \"datatype\": \"text\" }\r\n ]\r\n}\r\n"
response = https.request(request)
puts response.read_body
var client = new RestClient("https://live.membroz.com/api/purchasebills/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 \"search\": [\r\n { \"searchfield\": \"status\", \"searchvalue\": \"Paid\", \"criteria\": \"eq\", \"datatype\": \"text\" }\r\n ]\r\n}\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": "5f717013d0835e0aac69e178",
"paidamount": 1750,
"status": "Paid",
"billnumber": 6,
"ordernumber": 6,
"vendorid": {
"_id": "5f0305674ba62e380e5b26bd",
"status": "active",
"vendorname": "Protein Plus Nutrition",
"branchid": "5ee9db1683e5d3898bd66133",
"property": {
"address": "Surat",
"contact_number": "9861734520",
"email": null,
"vendorname": "Protein Plus Nutrition"
},
"createdAt": "2020-07-06T11:05:11.251Z",
"updatedAt": "2020-08-15T16:10:47.803Z"
},
"totalamount": 1750,
"balance": 0,
"billdate": "2020-07-13T09:41:51.369Z",
"items": [
{
"_id": "5f0c2c8254c1125e83500b29",
"item":"5f0301dc4ba62e380e5b26a8",
"quantity": 5,
"cost": 350,
"discount": 0,
"totalcost": 1750,
"tax": []
}
],
"branchid": "5e954c7b9df11624f81e7859",
"draccount": "5d5d4fdb93b7a12dfcfea7ee",
"craccount": "5d5d4cfe93b7a12dfcfea7b1",
"createdAt": "2020-07-13T09:42:26.527Z",
"updatedAt": "2020-08-15T16:30:40.781Z",
"wfroleid": [],
"wfuserid": [],
"docnumber": "undefined-6"
},