Getting Product Stock Data

$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => "https://easycms.fi/public_api/get_products_stock",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_POST => true,
  CURLOPT_POSTFIELDS => http_build_query([
    'username' => 'USERNAME', 
    'password' => 'PASSWORD', 
    'account' => 'ACCOUNT_ID',
    'pid' => [12345, 67890],         // multiple products
    'location_id' => [1, 2],         // multiple locations (optional)
    'shelf_id' => [3, 5]             // multiple shelves (optional)
  ]),
  CURLOPT_HTTPHEADER => array("Authorization1: TOKEN"),
));
$response = curl_exec($curl);
curl_close($curl);
echo $response;

import requests
url = "https://easycms.fi/public_api/get_products_stock"
headers = {"Authorization1": "TOKEN"}
payload = {
    'username': 'USERNAME', 
    'password': 'PASSWORD', 
    'account': 'ACCOUNT_ID',
    'pid[]': [12345, 67890],           # multiple products (array format)
    'location_id[]': [1, 2],           # multiple locations (optional)
    'shelf_id[]': [3, 5]               # multiple shelves (optional)
}
response = requests.post(url, headers=headers, data=payload)
print(response.text)

HttpClient client = HttpClient.newHttpClient();
// Multiple products and locations using array format
String formData = "username=USERNAME&password=PASSWORD&account=ACCOUNT_ID"
    + "&pid[]=12345&pid[]=67890"
    + "&location_id[]=1&location_id[]=2";
HttpRequest request = HttpRequest.newBuilder()
    .uri(URI.create("https://easycms.fi/public_api/get_products_stock"))
    .headers("Authorization1", "TOKEN")
    .POST(HttpRequest.BodyPublishers.ofString(formData))
    .build();
HttpResponse response = client.send(request, HttpResponse.BodyHandlers.ofString());
System.out.println(response.body());

const https = require('https');
const params = new URLSearchParams({
  username: 'USERNAME', 
  password: 'PASSWORD', 
  account: 'ACCOUNT_ID',
  // Multiple products as JSON array
  pid: JSON.stringify([12345, 67890]),
  // Multiple locations as JSON array
  location_id: JSON.stringify([1, 2])
});
const options = {
  hostname: 'easycms.fi',
  path: '/public_api/get_products_stock',
  method: 'POST',
  headers: {
    'Authorization1': 'TOKEN',
    'Content-Type': 'application/x-www-form-urlencoded',
    'Content-Length': Buffer.byteLength(params.toString())
  }
};
const req = https.request(options, (res) => {
  let data = '';
  res.on('data', (chunk) => { data += chunk; });
  res.on('end', () => { console.log(data); });
});
req.on('error', (e) => { console.error(e); });
req.write(params.toString());
req.end();

import React, { useEffect, useState } from 'react';
function App() {
  const [stockData, setStockData] = useState('');
  useEffect(() => {
    const fetchData = async () => {
      try {
        const response = await fetch('https://easycms.fi/public_api/get_products_stock', {
          method: 'POST',
          headers: {'Authorization1': 'TOKEN', 'Content-Type': 'application/x-www-form-urlencoded'},
          body: new URLSearchParams({
            username: 'USERNAME', 
            password: 'PASSWORD', 
            account: 'ACCOUNT_ID',
            pid: JSON.stringify([12345, 67890]),
            location_id: JSON.stringify([1, 2])
          }).toString()
        });
        const data = await response.text();
        setStockData(data);
      } catch (error) {
        console.error(error);
      }
    };
    fetchData();
  }, []);
  return (<div>{stockData}</div>);
}
export default App;

import okhttp3.OkHttpClient
import okhttp3.FormBody
import okhttp3.Request

fun main() {
    val client = OkHttpClient()

    // Multiple products using array format
    val formBody = FormBody.Builder()
        .add("username", "USERNAME")
        .add("password", "PASSWORD")
        .add("account", "ACCOUNT_ID")
        .add("pid[]", "12345")
        .add("pid[]", "67890")
        .add("location_id[]", "1")
        .add("location_id[]", "2")
        .build()

    val request = Request.Builder()
        .url("https://easycms.fi/public_api/get_products_stock")
        .post(formBody)
        .addHeader("Authorization1", "TOKEN")
        .build()

    client.newCall(request).execute().use { response ->
        if (!response.isSuccessful) throw IOException("Unexpected code $response")
        println(response.body?.string())
    }
}

using System;
using System.Net.Http;
using System.Threading.Tasks;
class Program
{
    static async Task Main()
    {
        var token = "TOKEN";
        // Multiple products and locations
        var content = new FormUrlEncodedContent(new[]
        {
            new KeyValuePair("username", "USERNAME"),
            new KeyValuePair("password", "PASSWORD"),
            new KeyValuePair("account", "ACCOUNT_ID"),
            new KeyValuePair("pid[]", "12345"),
            new KeyValuePair("pid[]", "67890"),
            new KeyValuePair("location_id[]", "1"),
            new KeyValuePair("location_id[]", "2")
        });
        using (var httpClient = new HttpClient())
        {
            httpClient.DefaultRequestHeaders.Add("Authorization1", token);
            var response = await httpClient.PostAsync("https://easycms.fi/public_api/get_products_stock", content);
            if (response.IsSuccessStatusCode)
            {
                var responseData = await response.Content.ReadAsStringAsync();
                Console.WriteLine(responseData);
            }
            else
            {
                Console.WriteLine($"Error: {response.StatusCode}");
            }
        }
    }
}

- `pid`: The product ID for this stock entry.
- `location_id`: The unique identifier for the location/warehouse.
- `location_name`: The name of the location/warehouse.
- `shelf_id`: The unique identifier for the shelf within the location.
- `shelf_name`: The name of the shelf.
- `stock`: The current stock quantity at this location/shelf combination.
- `best_before_date`: The best before date for the stock at this location (YYYY-MM-DD format, null if not set).
- `default_location`: Flag indicating if this is the default location for the product (1 = yes, 0 = no).
- `location_shelf_combo_id`: A combined identifier in format "location_id-shelf_id" for easy reference.

These key-value pairs provide comprehensive information about the product stock across all locations and can be used for inventory management in your application.
    

{
  "INFO": {
    "start": 0,
    "limit": 50,
    "count": 4,
    "total_count": 4,
    "WHERE": "pid IN (12345, 67890) AND location_id IN (1, 2)"
  },
  "OUTPUT": [
    {
      "pid": 12345,
      "location_id": 1,
      "location_name": "Main Warehouse",
      "shelf_id": 5,
      "shelf_name": "Shelf A1",
      "stock": 150.5,
      "best_before_date": "2025-12-31",
      "default_location": 1,
      "location_shelf_combo_id": "1-5"
    },
    {
      "pid": 12345,
      "location_id": 2,
      "location_name": "Secondary Warehouse",
      "shelf_id": 3,
      "shelf_name": "Shelf B2",
      "stock": 50.0,
      "best_before_date": "2025-06-30",
      "default_location": 0,
      "location_shelf_combo_id": "2-3"
    },
    {
      "pid": 67890,
      "location_id": 1,
      "location_name": "Main Warehouse",
      "shelf_id": 2,
      "shelf_name": "Shelf A2",
      "stock": 200.0,
      "best_before_date": null,
      "default_location": 1,
      "location_shelf_combo_id": "1-2"
    },
    {
      "pid": 67890,
      "location_id": 2,
      "location_name": "Secondary Warehouse",
      "shelf_id": 1,
      "shelf_name": "Shelf B1",
      "stock": 75.0,
      "best_before_date": "2026-03-15",
      "default_location": 0,
      "location_shelf_combo_id": "2-1"
    }
  ]
}