Skip to main content

NetSuite Query

本文档记录一些常用的 query 请求的示例

查询 PO 列表​

POST /api/netsuite/query/suiteql?limit=10&offset=0 HTTP/1.1
Host: bsg-wm-api.icerun.dev
Content-Type: application/json
Authorization: Bearer 38aeef56-f1f7-43a3-99d4-5a6dba847a5f

{
    "param": {
        "q": "SELECT * FROM purchaseorder WHERE status = 'B' ORDER BY createdDate DESC"
    }
}

PO 列表 SQL 示例​

关联 purchaseorder ，location 和 entity 三张表，查询状态为 'B' 的 PO 列表，并按照创建时间降序排序

SELECT purchaseorder.id     AS purchaseorder__id,
       purchaseorder.tranid AS purchaseorder__tranid,
       location.id          AS location__id,
       location.name        AS location__name,
       entity.id            as entity__id,
       entity.entityid      as entity__entityid
FROM purchaseorder
         JOIN location ON purchaseorder.location = location.id
         JOIN entity ON purchaseorder.entity = entity.id
WHERE purchaseorder.status = 'B'
ORDER BY purchaseorder.createdDate DESC

查询 PO 详情​

POST /api/netsuite/query/suiteql HTTP/1.1
Host: bsg-wm-api.icerun.dev
Content-Type: application/json
Authorization: Bearer 38aeef56-f1f7-43a3-99d4-5a6dba847a5f

{
    "param": {
        "q": "SELECT * FROM purchaseorder WHERE id = 741006"
    }
}

查询 PO 商品列表​

POST /api/netsuite/query/suiteql HTTP/1.1
Host: bsg-wm-api.icerun.dev
Content-Type: application/json
Authorization: Bearer 38aeef56-f1f7-43a3-99d4-5a6dba847a5f

{
    "param": {
        "q": "SELECT * FROM purchaseorderitem WHERE purchaseorder = 741006"
    }
}