Kasutaja tarvikud

Lehe tööriistad



et:api_direct

Erinevused

Siin näed erinevusi valitud versiooni ja hetkel kehtiva lehekülje vahel.

Lõlita võrdlemise vaatele

Both sides previous revisionPrevious revision
Next revision
Previous revision
et:api_direct [2026/02/04 11:49] – [Prerequisites] toomaset:api_direct [2026/05/05 13:56] (Hetkel kehtiv) – [📦 API Resources & Endpoints] toomas
Rida 10: Rida 10:
   * API key (obtain from your Directo administrator)   * API key (obtain from your Directo administrator)
   * Basic understanding of REST APIs and HTTP methods   * Basic understanding of REST APIs and HTTP methods
-  * API Resources and Endpint can be found in Postman collection. Response field list managed in Directo ERP. Postman collection can be downloaded here: {{:et:toomas20260204-114827.json|POSTMAN}}+  * API Resources and Endpint can be found in Postman collection. Response field list managed in Directo ERP. Postman collection can be downloaded here: {{:et:toomas20260401-145732.json|POSTMAN}}
 ==== Quick Start Guide ==== ==== Quick Start Guide ====
  
Rida 172: Rida 172:
 </code> </code>
 **Key Principle:** Use the exact field name as it appears in the API response (or as you see it in the ERP system). **Key Principle:** Use the exact field name as it appears in the API response (or as you see it in the ERP system).
 +
 +====Contains Filtering ====
 +This filtering allows you to search for values containing a specific substring.
 +
 +This works like SQL LIKE'' '%text%' ''logic.
 +Use it when you need flexible filtering for names, codes, descriptions, or any other text fields
 +
 +<code>
 +GET {{baseUrl}}/v{{version}}/customers?name=%john%
 +</code>
 +
  
 ==== Comparison Operators ==== ==== Comparison Operators ====
Rida 188: Rida 199:
 <code>GET {{baseUrl}}/v{{version}}/orders?status=!CLOSED</code> <code>GET {{baseUrl}}/v{{version}}/orders?status=!CLOSED</code>
  
-**Greater Than or Equal (>=)** +**Greater Than or Equal (>= )** 
-<code>GET {{baseUrl}}/v{{version}}/items?price=>=100</code> +<code>GET {{baseUrl}}/v{{version}}/items?price=>100</code> 
-<code>GET {{baseUrl}}/v{{version}}/orders?date=>=2025-01-01T00:00:00</code>+<code>GET {{baseUrl}}/v{{version}}/orders?date=>2025-01-01T00:00:00</code>
  
-**Less Than or Equal (<=)** +**Less Than or Equal (< = )** 
-<code>GET {{baseUrl}}/v{{version}}/items?weight=<=5.5</code> +<code>GET {{baseUrl}}/v{{version}}/items?weight=<5.5</code> 
-<code>GET {{baseUrl}}/v{{version}}/orders?date=<=2025-12-31T23:59:59</code>+<code>GET {{baseUrl}}/v{{version}}/orders?date=<2025-12-31T23:59:59</code>
  
 ==== Range Filtering ==== ==== Range Filtering ====
Rida 230: Rida 241:
 If you have custom fields defined in your ERP system (visible in the datafields array), you can filter by them: If you have custom fields defined in your ERP system (visible in the datafields array), you can filter by them:
 <code> <code>
-GET {{baseUrl}}/v{{version}}/items?IS_WEIGHT=1 +GET {{baseUrl}}/v{{version}}/items?data_row_code=ART_PROJ 
-GET {{baseUrl}}/v{{version}}/items?VISUAL_VERIFICATION=1+GET {{baseUrl}}/v{{version}}/items?data_row_code=ART_PROJ,BRAND
 </code> </code>
 **How to Find Custom Field Names:** Make a request without filters and examine the datafields array in the response. **How to Find Custom Field Names:** Make a request without filters and examine the datafields array in the response.
Rida 291: Rida 302:
 Response field list managed in Directo ERP. Response field list managed in Directo ERP.
  
-Postman collection can be downloaded here:{{ :mustand:toomas:directo_api.postman_collection.json |POSTMAN}}+<code> 
 +GET {{baseUrl}}/v{{version}}/sales_quotations 
 +GET {{baseUrl}}/v{{version}}/orders 
 +GET {{baseUrl}}/v{{version}}/invoices 
 +GET {{baseUrl}}/v{{version}}/purchase_orders 
 +GET {{baseUrl}}/v{{version}}/stock_receipts 
 +GET {{baseUrl}}/v{{version}}/purchase_invoices 
 +GET {{baseUrl}}/v{{version}}/purchase_payments 
 +GET {{baseUrl}}/v{{version}}/customers 
 +GET {{baseUrl}}/v{{version}}/suppliers 
 +GET {{baseUrl}}/v{{version}}/contacts 
 +GET {{baseUrl}}/v{{version}}/items 
 +GET {{baseUrl}}/v{{version}}/itemclasses 
 +GET {{baseUrl}}/v{{version}}/priceformulas 
 +GET {{baseUrl}}/v{{version}}/stocklevels 
 +GET {{baseUrl}}/v{{version}}/stocklevels_sn 
 +GET {{baseUrl}}/v{{version}}/allocations 
 +GET {{baseUrl}}/v{{version}}/accounts 
 +GET {{baseUrl}}/v{{version}}/transactions 
 +GET {{baseUrl}}/v{{version}}/deleted 
 +GET {{baseUrl}}/v{{version}}/financial_budgets 
 +GET {{baseUrl}}/v{{version}}/events 
 +GET {{baseUrl}}/v{{version}}/receipts 
 +GET {{baseUrl}}/v{{version}}/deliveries 
 +GET {{baseUrl}}/v{{version}}/movements 
 +GET {{baseUrl}}/v{{version}}/objects 
 +GET {{baseUrl}}/v{{version}}/projects 
 +GET {{baseUrl}}/v{{version}}/resources 
 +GET {{baseUrl}}/v{{version}}/sales_contracts 
 +GET {{baseUrl}}/v{{version}}/replacementlogs 
 +GET {{baseUrl}}/v{{version}}/users 
 +GET {{baseUrl}}/v{{version}}/recipes 
 + 
 + 
 +</code> 
 + 
 +Postman collection can be downloaded here: e: {{:et:toomas20260401-145732.json|Directo API postman collection}}
  
  
et/api_direct.1770198557.txt.gz · Viimati muutnud: 2026/02/04 11:49 persoon toomas

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki