Get Purchase Bill

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"
    },