Go to your Clay table and click on the column where the API response is stored.
Click "Add Column" and select "Formula."
Use the following formula to check for empty values..
IF(NOT({API Response Column}), "No Data Found", {API Response Column})
Click "Save & Test" to verify.