Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.48k stars 2.8k forks source link

Issue with Supplier Price Creation via Dolibarr API #32039

Open ElaaxMarketing opened 20 hours ago

ElaaxMarketing commented 20 hours ago

Bug

Attempting to create or update supplier prices via the Dolibarr 20.0.1 API results in a 500 Internal Server Error. Manual entry via the Dolibarr interface works correctly, but API calls with valid payload data fail consistently.

The API responds with an HTTP 500 Internal Server Error when a POST request with the payload is sent to the endpoint /products/{PRODUCT_ID}/purchase_prices.

Dolibarr Version

20.0.1

Environment PHP

8.2

Environment Database

MariaDB 11.3.2-MariaDB-1:11.3.2+maria

Steps to reproduce the behavior and expected behavior

import requests import json

API Configuration

api_url = "https://xxxx/api/index.php/" api_key = "xxxxxxxxxxxxxxxx"

PRODUCT_ID = 68198 # Example product ID url = f"{api_url}products/{PRODUCT_ID}/purchase_prices"

Payload

payload = { "qty": 1, "buyprice": 15.99, "price_base_type": "HT", "fourn_id": 3, "availability": 7, "ref_fourn": "449452", "tva_tx": 19.00, "charges": "SU2411-00030", "delivery_time_days": 2, "supplier_reputation": "Favorit", "desc_fourn": "string", "barcode": "string", "fk_barcode_type": 0 }

Headers

headers = { "DOLAPIKEY": api_key, "Content-Type": "application/json", "Accept": "application/json", }

Send POST request

response = requests.post(url, json=payload, headers=headers)

Check result

if response.status_code == 200: print("Supplier price successfully updated.") print(response.json()) else: print(f"Error {response.status_code}: {response.text}") print("Payload:") print(json.dumps(payload, indent=4))

Attached files

Bildschirmfoto vom 2024-11-21 17-25-17 Bildschirmfoto vom 2024-11-21 17-25-32