Item Inquiry Transaction

The Item Inquiry is used to get pricing and availability information for display in the web catalog. The request and response JSON strings are defined below. The response that is returned may be for any of the following part types which are defined on the target system.

• Requested Part (0): This is required to be returned for the requested parts.
• Alternate Part (1): This part generally indicates that it is an alternate for the requested part.
• Equivalent Part (2): This part generally indicates that it is an equivalent replacement for the requested part.
• Superseded Part (3): This part indicates that the requested part has been Superseded or replaced by this part.

Request JSON Example (Version 3.0)

The following is an example of the JSON string that will be posted.

{
   "item_inquiry": {
      "version": "3.0",
      "integration_type": "FLK",
      "member_id": "###",
      "account_id": "######",
      "user_name": "",
      "password": "",
      "locations": [
         {
            "location_id": "Branch1",
            "sort_order": 0,
            "location_type": "store",
            "can_order": true
         },
         {
            "location_id": "Branch2",
            "sort_order": 1,
            "location_type": "store",
            "can_order": false
         }
      ],
      "items": [
         {
            "index": 1,
            "mfr_code": "HAS",
            "part_number": "LF115",
            "qty_requested": 1
         },
         {
            "index": 2,
            "mfr_code": "FEF",
            "part_number": "LF115F",
            "qty_requested": 1
         }
      ]
   }
}

Response JSON Example (Version 3.0)

The following is an example of the JSON string to be returned

{
   "item_inquiry_response": {
      "version": "3.0",
      "integration_type": "FLK",
      "member_id": "###",
      "account_id": "######",
      "status": "success",
      "error_description": "",
      "items": [
         {
            "id": 1,
            "status": "success",
            "errormessage": "",
            "mfr_code": "HAS",
            "mfr_description": "",
            "part_number": "LF115",
            "part_description": "",
            "parttype": "",
            "comment": "0",
            "bulk_pricing": [
               {
                  "break": 10,
                  "price": 2.99
               },
               {
                  "break": 20,
                  "price": 2.79
               },
               {
                  "break": 30,
                  "price": 2.59
               }
            ],
            "locations": [
               {
                  "location_id": "Branch1",
                  "sort_order": 0,
                  "location_type": "store",
                  "can_order": true,
                  "location_desc": "",
                  "qty_available": 3,
                  "list": 7.8,
                  "cost": 3.25,
                  "core": 0,
                  "bundle_cost": 0,
                  "multiplier": 1,
                  "unit_of_measure": "",
                  "out_of_stockmsg": "",
                  "route_times": [
                     {
                        "cutoff_time": "2020-07-31 11:00:00",
                        "arrival_time": "2020-07-31 12:08:00",
                        "pickup_time": "2020-07-31 12:08:00",
                        "origin": "050"
                     }
                  ]
               },
               {
                  "location_id": "Branch2",
                  "sort_order": 1,
                  "location_type": "store",
                  "can_order": false,
                  "location_desc": "",
                  "qty_available": 51,
                  "list": 7.8,
                  "cost": 3.25,
                  "core": 0,
                  "bundle_cost": 0,
                  "multiplier": 1,
                  "unit_of_measure": "",
                  "out_of_stockmsg": "",
                  "route_times": [
                     {
                        "cutoff_time": "2020-07-31 11:00:00",
                        "arrival_time": "2020-07-31 12:08:00",
                        "pickup_time": "2020-07-31 12:08:00",
                        "origin": "050"
                     }
                  ]
               }
            ],
            "alternates": [
               {
                  "id": "ALT_<UniqueNumber-or-SKU>",
                  "status": "success",
                  "mfr_code": "DOR",
                  "mfr_description": "",
                  "part_number": "M76162",
                  "part_description": "",
                  "parttype": "1",
                  "comment": "",
                  "bulk_pricing": [],
                  "locations": [
                     {
                        "location_id": "Branch1",
                        "locationdesc": "",
                        "sort_order": 1,
                        "location_type": "store",
                        "can_order": true,
                        "qty_available": 0,
                        "list": 0,
                        "cost": 0,
                        "core": 0,
                        "bundle_cost": 0,
                        "multiplier": 1,
                        "unit_of_measure": "each",
                        "out_of_stockmsg": ""
                     },
                     {
                        "location_id": "Branch2",
                        "locationdesc": "",
                        "sort_order": 2,
                        "location_type": "store",
                        "can_order": true,
                        "qty_available": 0,
                        "list": 0,
                        "cost": 0,
                        "core": 0,
                        "bundle_cost": 0,
                        "multiplier": 1,
                        "unit_of_measure": "each",
                        "out_of_stockmsg": ""
                     }
                  ]
               }
            ]
         },
         {
            "id": 2,
            "status": "success",
            "mfr_code": "FEF",
            "mfr_description": "",
            "part_number": "LF115F",
            "part_description": "",
            "parttype": "",
            "comment": "",
            "bulk_pricing": [],
            "locations": [
               {
                  "location_id": "Branch1",
                  "sort_order": 0,
                  "location_type": "store",
                  "can_order": true,
                  "location_desc": "",
                  "qty_available": 12,
                  "list": 5,
                  "cost": 1.77,
                  "core": 0,
                  "bundle_cost": 0,
                  "multiplier": 1,
                  "unit_of_measure": "",
                  "out_of_stockmsg": "",
                  "route_times": [
                     {
                        "cutoff_time": "2020-07-31 11:00:00",
                        "arrival_time": "2020-07-31 12:08:00",
                        "pickup_time": "2020-07-31 12:08:00",
                        "origin": "050"
                     }
                  ]
               },
               {
                  "location_id": "Branch2",
                  "sort_order": 1,
                  "location_type": "store",
                  "can_order": false,
                  "location_desc": "",
                  "qty_available": 108,
                  "list": 5,
                  "cost": 1.77,
                  "core": 0,
                  "bundle_cost": 0,
                  "multiplier": 1,
                  "unit_of_measure": "",
                  "out_of_stockmsg": "",
                  "route_times": [
                     {
                        "cutoff_time": "2020-07-31 11:00:00",
                        "arrival_time": "2020-07-31 12:08:00",
                        "pickup_time": "2020-07-31 12:08:00",
                        "origin": "050"
                     }
                  ]
               }
            ]
         }
      ]
   }
}