📦 TCC Inventory Cloud Diagnostic

Script URL

Test A: Is the backend alive?

Basic GET to see what version of the script is running.

Test B: Does the "inventory" tab exist?

GET ?tab=inventory — checks if the sheet tab is there.

Test C: Write a test inventory submission

Sends a POST matching the exact format your inventory app uses.

Test D: Read back and verify

Reads the inventory tab to confirm the test row was saved.

Test E: Check what your inventory app actually sends

This sends a payload structured EXACTLY like your inventory app's invCloudPost() function does.

Test F: Check the compliance tab too

Confirms compliance still works alongside inventory.

⚠️ Troubleshooting Guide

Test A says "Unknown action" or version 1.0: Old script is still deployed. Replace code → Save → Deploy → Manage deployments → Edit → New version → Deploy.

Test B says "Tab not found": Run initSheets in Apps Script editor.

Test C fails but Test A passes: The handleDataWrite function isn't in your deployed code. You need to create a NEW version deployment.

Test E returns success but nothing in sheet: Check if the inventory tab headers match what the script expects. Open the sheet and check row 1.