Get Many Pricelist Items

Endpoint Overview

This API endpoint is designed to retrieve information about multiple pricelist items from the Juleb ERP system. It allows you to efficiently fetch data for a group of pricelist items in a single request, rather than making individual requests for each pricelist item.

Endpoint Details

• Method: GET
• URL: /api/v1/pos/pricelist/item

Parameters

• Path Parameters: None
• Query Parameters:
  • fields (string, not required): Fields to include in the response separated by comma. If not provided, all fields are returned.
  • filter (string, not required): Apply conditions to filter the data returned
  • limit (integer, not required): Limit the number of records returned. Default is 10, Max is 1000.
  • page (integer, not required): Page the records returned. Default is 1.

Response

• 200 OK: Successfully retrieved the record.
• 400 Bad Request: Invalid parameters.
• 401 Unauthorized: Authentication required.

Response Body

{
  "data": [
    ...records
  ],
  "meta": {
    "count": integer,
    "total": integer
  },
  "pagination": {
    "previousPage": integer | null,
    "currentPage": integer,
    "nextPage": integer | null,
    "totalPages": integer
  }
}

Example

Request

NodeJS

curl -X GET \
-H "accept: */*" \
-H "Authorization: Bearer $API_KEY" \
"https://$ACCOUNT_NAME.juleb.com/api/v1/pos/pricelist/item?fields=id%2Cpricelist_id%2Cproduct_tmpl_id%2Cmin_quantity%2Cfixed_price&filter=pricelist_id%3D2%26fixed_price%3E100&page=1&limit=10"

curl

const axios = require('axios');
const accountName = process.env.ACCOUNT_NAME;
const apiKey = process.env.API_KEY;

axios.get(`https://${accountName}.juleb.com/api/v1/pos/pricelist/item`, {
  headers: {
    'accept': '*/*',
    'Authorization': `Bearer ${apiKey}`
  },
  params: {
    fields: 'id,pricelist_id,product_tmpl_id,min_quantity,fixed_price',
    filter: 'pricelist_id=2&fixed_price>100',
    page: 1,
    limit: 10
  }
})
.then(response => {
  console.log(response.data);
})
.catch(error => {
  console.error('Error:', error);
});

python

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.net.http.HttpResponse.BodyHandlers;

public class Main {
    public static void main(String[] args) throws Exception {
        String accountName = System.getenv("ACCOUNT_NAME");
        String apiKey = System.getenv("API_KEY");

        HttpClient client = HttpClient.newHttpClient();
        HttpRequest request = HttpRequest.newBuilder()
            .uri(new URI("https://" + accountName + ".juleb.com/api/v1/pos/pricelist/item?fields=id,pricelist_id,product_tmpl_id,min_quantity,fixed_price&filter=pricelist_id=2&fixed_price>100&page=1&limit=10"))
            .header("accept", "*/*")
            .header("Authorization", "Bearer " + apiKey)
            .GET()
            .build();

        HttpResponse<String> response = client.send(request, BodyHandlers.ofString());
        if (response.statusCode() == 200) {
            System.out.println(response.body());
        } else {
            System.out.println("Error: " + response.statusCode() + ", " + response.body());
        }
    }
}

java

import os
import requests

account_name = os.getenv('ACCOUNT_NAME')
api_key = os.getenv('API_KEY')

url = f'https://{account_name}.juleb.com/api/v1/pos/pricelist/item'
headers = {
    'accept': '*/*',
    'Authorization': f'Bearer {api_key}'
}
params = {
    'fields': 'id,pricelist_id,product_tmpl_id,min_quantity,fixed_price',
    'filter': 'pricelist_id=2&fixed_price>100',
    'page': 1,
    'limit': 10
}

response = requests.get(url, headers=headers, params=params)
if response.status_code == 200:
    print(response.json())
else:
    print(f'Error: {response.status_code}', response.text)

Response

{
  "data": [
    {
      "id": 34861,
      "pricelist_id": 2,
      "product_tmpl_id": 13,
      "min_quantity": 0,
      "fixed_price": 198
    },
    {
      "id": 34863,
      "pricelist_id": 2,
      "product_tmpl_id": 15,
      "min_quantity": 0,
      "fixed_price": 160
    },
    {
      "id": 34865,
      "pricelist_id": 2,
      "product_tmpl_id": 17,
      "min_quantity": 0,
      "fixed_price": 140
    },
    {
      "id": 34866,
      "pricelist_id": 2,
      "product_tmpl_id": 18,
      "min_quantity": 0,
      "fixed_price": 224.95
    },
    {
      "id": 34869,
      "pricelist_id": 2,
      "product_tmpl_id": 21,
      "min_quantity": 0,
      "fixed_price": 220
    },
    {
      "id": 34909,
      "pricelist_id": 2,
      "product_tmpl_id": 65,
      "min_quantity": 0,
      "fixed_price": 115.4
    },
    {
      "id": 34910,
      "pricelist_id": 2,
      "product_tmpl_id": 66,
      "min_quantity": 0,
      "fixed_price": 134
    },
    {
      "id": 34911,
      "pricelist_id": 2,
      "product_tmpl_id": 67,
      "min_quantity": 0,
      "fixed_price": 150
    },
    {
      "id": 34912,
      "pricelist_id": 2,
      "product_tmpl_id": 68,
      "min_quantity": 0,
      "fixed_price": 150
    },
    {
      "id": 34913,
      "pricelist_id": 2,
      "product_tmpl_id": 69,
      "min_quantity": 0,
      "fixed_price": 190
    }
  ],
  "meta": {
    "count": 10,
    "total": 7519
  },
  "pagination": {
    "previousPage": null,
    "currentPage": 1,
    "nextPage": 2,
    "totalPages": 752
  }
}