Visual Builder Excel Add-in: Download and Update Specific Supplier Sites by Site ID Only
We have a requirement to update Supplier Site Inactive Dates in bulk using the Visual Builder Excel Add-in. For this purpose, we are using the Suppliers REST API:
/fscmRestApi/resources/11.13.18.05/suppliers/
We have a list of specific Supplier Site IDs that need to be updated. However, when we pass the Site IDs as download parameters, the Excel Add-in retrieves all sites associated with the supplier, rather than only the Site IDs provided in the parameter.
From a technical perspective, this behavior appears to be expected because the Supplier Site REST resource is a child of the Supplier resource. When a Supplier Site ID is provided, the system first identifies the parent supplier and then retrieves all sites belonging to that supplier.
0