Differences

This shows you the differences between two versions of the page.

--- en:db_api [2026/06/03 09:50] – administrator
+++ en:db_api [2026/06/05 07:14] (current) – administrator
@@ Line 1: / Line 1: @@
-====== Datebase API ======
+====== Database API ======
 ===== iGarment API: Query =====
@@ Line 36: / Line 36: @@
 Example, single SQL
- {
    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;
    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo
- }
 Return data
@@ Line 93: / Line 91: @@
   DROP INDEX T_A_KEY1;
+===== iGarment API: Get file =====
-iGarment API: Get file
 API to download file. Supported method is GET.
@@ Line 101: / Line 98: @@
 <file_name> is real file name saved in system, can query it from attach table or system image table.
-Request Example
+**Request Example**
 eg: get style image (example with trial505, https://trial505.igx.biz/api)
 step 1. get real file name from system image table: ~/db/query
-sql: select b.ImageType, b.RealFileName from SAYSKTCH a inner join SYIMAGE b on b.ImageID = a.ImageID where a.OrderNo = 'BEI-TEST24-001'
+  sql: select b.ImageType, b.RealFileName from SAYSKTCH a inner join SYIMAGE b on b.ImageID = a.ImageID where a.OrderNo = 'BEI-TEST24-001'
 return:
    [{
@@ Line 113: / Line 112: @@
         "records":  [["JPG","b9b957b159d66ceec231a26c776dd9d390"]]
     }]
 step 2. url: ~/db/get_file/b9b957b159d66ceec231a26c776dd9d390
-Return Example
+**Return Example**
-{
+  {
   "file_name": "b9b957b159d66ceec231a26c776dd9d390",  #file name, same as query param
   "file_type": "",   #file suffix
   "data": "iVBORw0KGgoAAAANSUhEUgAAAPoAAAD6CAIAAAAHjs1qAAAACXBIWXMAAAsSAAALEgHS3X78AAAgAElEQVR4nOy9WZckSXYedu...... sfuTm4f5Wv8uXknobmV/kqf6N8hftX+Q3JV7h/ld+QfIX7V/kNyVe4f5XfkHyF+1f5DclXuH+V35B8hftX+Q3J/w+JbeR8InngWAAAAABJRU5ErkJggg=="
    # file data, encoded in Base64
-}
+  }
-If file_type is blank, can get file type from system image table.
+''If file_type is blank, can get file type from system image table.''