Get Many Products

Endpoint Overview

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

Endpoint Details

• Method: GET
• URL: /api/v1/inventory/product

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 "Content-Type: application/json" \
-H "Authorization: Bearer $API_KEY" \
https://demo.juleb.com/api/v1/inventory/product?fields=id%2Cdefault_code%2Cactive%2Cproduct_tmpl_id%2Cis_rsd_product&filter=default_code%2AMED&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/inventory/product`, {
  headers: {
    'Content-Type': 'application/json',
    'Authorization': `Bearer ${apiKey}`
  },
  params: {
    fields: 'id,default_code,active,product_tmpl_id,is_rsd_product',
    filter: 'default_code*MED',
    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/inventory/product?fields=id,default_code,active,product_tmpl_id,is_rsd_product&filter=default_code*MED&page=1&limit=10"))
            .header("Content-Type", "application/json")
            .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/inventory/product'
headers = {
    'Content-Type': 'application/json',
    'Authorization': f'Bearer {api_key}'
}
params = {
    'fields': 'id,default_code,active,product_tmpl_id,is_rsd_product',
    'filter': 'default_code*MED',
    '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": 3618,
      "default_code": "MED_7961",
      "active": true,
      "product_tmpl_id": 3618,
      "is_rsd_product": null
    },
    {
      "id": 222,
      "default_code": "MED_7897",
      "active": true,
      "product_tmpl_id": 222,
      "is_rsd_product": null
    },
    {
      "id": 785,
      "default_code": "MED_5849",
      "active": true,
      "product_tmpl_id": 785,
      "is_rsd_product": null
    },
    {
      "id": 5963,
      "default_code": "MED_8396",
      "active": true,
      "product_tmpl_id": 5963,
      "is_rsd_product": null
    },
    {
      "id": 1032,
      "default_code": "MED_6961",
      "active": true,
      "product_tmpl_id": 1032,
      "is_rsd_product": null
    },
    {
      "id": 1119,
      "default_code": "MED_447",
      "active": true,
      "product_tmpl_id": 1119,
      "is_rsd_product": null
    },
    {
      "id": 1143,
      "default_code": "MED_7972",
      "active": true,
      "product_tmpl_id": 1143,
      "is_rsd_product": null
    },
    {
      "id": 1489,
      "default_code": "MED_7675",
      "active": true,
      "product_tmpl_id": 1489,
      "is_rsd_product": null
    },
    {
      "id": 5941,
      "default_code": "MED_8430",
      "active": true,
      "product_tmpl_id": 5941,
      "is_rsd_product": null
    },
    {
      "id": 5958,
      "default_code": "MED_8408",
      "active": true,
      "product_tmpl_id": 5958,
      "is_rsd_product": null
    }
  ],
  "meta": {
    "count": 10,
    "total": 8436
  },
  "pagination": {
    "previousPage": null,
    "currentPage": 1,
    "nextPage": 2,
    "totalPages": 844
  }
}