I’ve been using the API called ‘Get a list of Inv’ and when I try to use prcpart and location query parameters at the same time, the API crashes and doesn’t return any data. Have this happened to anyone else? Can it be fixed?
Hi,
I am using that endpoint too from time to time and it works fine for me.
This is the endpoint I am using:
https://YourDomain/goapis/api/v1/bin/list?prcpart=pch%25&rows=500
Is it the same?
Here are the params that I use in Postman when I test it.
Here is an exerpt of the result I get.
Since you did not post the API endpoint url I am not sure I am of any help here but maybe.
//H
AFter searching the API I realize that you use
https://YourDomain/goapis/api/v1/inv?prcpart=%PCH%&rows=500&like=true&location=SB&page=1
So I tested that also.
With these params
Un fortunately it seems that the filter does not work.
It just dumps all the data in the DB
Here is an exerpt of the response
[
{
"prcpart": "130",
"location": "SB",
"qoh": 0,
"description": "SNCTHE CLUB LEMON 0.5G 4.5MGP ZW",
"commodity_code": "",
"leadtime": 0,
"avg_purchase_leadtime": 0,
"avg_sales_leadtime": 0,
"rop": 0,
"rop_adder": 0,
"qoo": 0,
"qr": 0,
"uom": "",
"moq": 0,
"stdpack": "",
"tech_desc": "THE CLUB LEMON ZW",
"default_resale": 0,
"default_cost": 0,
"bookcost": 0,
"stdcost": 0,
"avgcost": 0,
"pm_initials": "",
"last_updated": "0001-01-01T00:00:00Z",
"last_receive_date": "0001-01-01T00:00:00Z",
"last_ship_date": "0001-01-01T00:00:00Z",
"last_buy_date": "0001-01-01T00:00:00Z",
"last_buy_cost": 0,
"eoq": 0,
"rohs": "0",
"lead_free": "",
"abc_code": "",
"country_origin": "",
"country_origin_id": 0,
"preferred_bins": "",
"eccn_code": "",
"commercial_invoice_desc": "",
"last_cycle_counted": "0001-01-01T00:00:00Z",
"deleted_flag": false,
"deleted_flag_timestamp": 0,
"primary_binloc": "130",
"sold_in_12_months": 0,
"cycle_count_active": false,
"most_recent_zero_qoh_cached": "0001-01-01T00:00:00Z",
"dirty_bits": false,
"inv_data_cache": "",
"uom_id": 0,
"build_estimate_inflator": 0,
"final_allocation_qty": 0,
"qty_in_boms": 0,
"qty_built_here": 0,
"inv_within_boms_details": "",
"purchase_moq": 0,
"purchase_stdpack": "",
"hts_code": "",
"new_to_mrp": "0001-01-01T00:00:00Z",
"is_imported": false,
"imported_date": "0001-01-01T00:00:00Z",
"mfg_costing_lot_size": 0
},
{
"prcpart": "ARM10001",
"location": "SB",
"qoh": 134859.31,
"description": "ARMAROM# 1",
"commodity_code": "",
"leadtime": 50,
"avg_purchase_leadtime": 0,
And If I remove the % sign on the PRC part I get the same result as you
So it seems something is broken.
//H
1 Like