Inventory Upload Functions

Owned by Megan Stanage
Mar 26, 2024
3 min read

SCC Version 57 - 2024.4.22.0

As of the version 57 release, calls to On-Hand Inventory upload and Vendor Inventory upload do not require an Azure Function Key for authentication.

They do still require the API keys in the header for authentication.


Functionality

 On-Hand Inventory

On-Hand Inventory displays all on-hand inventory in your system.

This allows you to view data flowing between Supply Chain Cloud and your host system.

Note

This inventory list does not automatically update as items are used; it is only updated through a new API request.

Example Request

  1. Post a connection to https://qa-inventoryupload.thesccloud.com/api/OnHandInventoryUpload?version=1.0.

  2. Use "scc-api-key" with your tenant's API key as the value. 

  3. Use the following file structure in the body:

    [
    {
        "hostItem":"A0001",
        "quantity": 50,
        "quantityUom": "ea",
        "onHandInventoryAttributes":[{
                "attributeName": "string",
                "value": "string";
            },
            {
                "attributeName": "string",
                "value": "string"
            }],
        "asOfDate": "2024-01-01T00:00:00.000Z"
    },
        {
        "hostItem":"A0002",
        "quantity": 50,
        "quantityUom": "ea",
        "onHandInventoryAttributes":[{
                "attributeName": "Num",
                "value": "14"
            },
            {
                "attributeName": "Note",
                "value": "Hello World2"
            }],
        "asOfDate": "2024-01-01T00:00:00.000Z"
    }
]


 Vendor Inventory

Vendor Inventory displays which vendors have on-hand inventory for an item, and the amount.

Note

This vendor inventory list does not automatically update as items are used; it is only updated through a new API request.

Example Request

  1. Post a connection to https://qa-inventoryupload.thesccloud.com/api/VenInventoryUpload?version=1.0.

  2. Use "scc-vendor-api-key" with your tenant's secondary API key as the value. 

  3. Use "scc-trading-partner-api-key" with your vendor's API key as the value. 

    To obtain this API key:

    1. Navigate to Trading Partners > Vendors.
    2. Select your vendor.
    3. Click API Key.
    4. Click Generate.


  4. Use the following file structure in the body:

    [
{
    "hostItem": "A0001",
    "lotNumber": "",
    "warehouse": "WHS-001",
    "quantity": 50,
    "quantityUom": "ea",
    "asOfDate": "2023-01-01T00:00:00.000Z"  ,
    "onHandInventoryAttributes": [{
                "attributeName": "string",
                "value": "string";
            }
    ]
  }
]