...
| Code Block |
|---|
{
"data": {
"Inventories": [
{
"id": "42289",
"name": "neon genesis evangelion",
"Category": {
"id": "8",
"name": "Modules"
},
"series_and_model": "RSM72-6-315P",
"inventory_currency": "$",
"brand_name": "Risen",
"kit_value": false,
"archived": false,
"InventoryPricingDefault": {
"id": "24466",
"code": "neon genesis evangelion",
"markup_is_percentage": "1",
"markup_is_percentage_text": "%",
"markup_value": 12,
"unit_price": 0,
"retail_price": 0,
"Supplier": {
"id": "2848",
"name": "sdwewewew"
},
"item_variation_suffix": "test2"
}
},
]
}
} |
Search Inventory Pricing
Stock code- varchar
Supplier_name - varchar
Supplier_id - numeric
Buy Price - numeric
inventory_id - numeric
is default - boolean value 0( false) or 1( true)
buy price - numerical value
unit_of_measure - numeric ( check end of the post for possible values )
markup value - numerical value
markup value is percent - boolean value 0( false) or 1( true)
Order_by - column or columns to order the entries ( default is updated_date)
Order_type - DESC or ASC
Get specific inventory item
Inventory_id - required field
Get specific pricing
Pricing_id - required field
Brand query
Category_id - optional
Model query
Category_id - required
Brand_id - required
VARIABLES FOR INPUT (ARGUMENTS) :
...
VARIABLES FOR OUTPUT(DATA):
...
SAMPLE QUERY:
...
QUERY:
| Code Block |
|---|
query InventoryPricings(
$inventoryId: ID
) {
InventoryPricings(
inventoryId: $inventoryId
) {
id
inventory_id
supplier_id
code
unit_price
markup_value
markup_is_percentage
unit_of_measure_string
unit_of_measure
item_variation_suffix
spare_qty
quantity
}
} |
SAMPLE INPUT :
| Code Block |
|---|
{
"inventoryId": 29505
} |
SAMPLE OUTPUT:
| Code Block |
|---|
{
"data": {
"InventoryPricings": [
{
"id": "24399",
"inventory_id": "29505",
"supplier_id": "293",
"code": "ET Solar ET-M572190",
"unit_price": 2,
"markup_value": 12,
"markup_is_percentage": "1",
"unit_of_measure_string": "/ kW Solar PV",
"unit_of_measure": "2",
"item_variation_suffix": "",
"spare_qty": 0,
"quantity": 0
},
{
"id": "15459",
"inventory_id": "29505",
"supplier_id": null,
"code": "ET-M572190",
"unit_price": 200,
"markup_value": 12,
"markup_is_percentage": "1",
"unit_of_measure_string": "/ item",
"unit_of_measure": "0",
"item_variation_suffix": "",
"spare_qty": 0,
"quantity": 0
}
]
}
} |
CATEGORY VALUES
1 Mounting
...
7 Inverters
8 Modules
17 Battery
CATEGORIES
...
THAT ACCEPT BRAND AND MODEL BUT DO NOT REQUIRE IT :
5 Accessories
20 Battery Access
...