Cards Direct have a number of web product category. First thing to check is that it is actually a web_product
SELECT web_product, * FROM vw_Product1 WHERE barcode = '5053349002438'
SELECT * FROM websites.vw_WebProductCategory WHERE product = 50758 EXEC traxs_depends 'websites.web_product_category'
We can find the web processes which reference 'product' using:
We can find what the request and response was using the following:
SELECT * FROM websites.vw_WebsiteInterfaceProducts_ProductListing WHERE product = 50758 SELECT request FROM websites.rest_session WHERE request LIKE '%5053349002438%' AND date_time > '2021-06-22 11:35:07.997' SELECT response FROM websites.rest_session WHERE request LIKE '%5053349002438%' AND date_time > '2021-06-22 11:35:07.997'
The response is I JSON format which can be difficult to read. Therefore an editor can be used however must be careful not to use PID: