how to get input json for failed logic app workflow calls

Question

I have made around 18K api calls to a logic app workflow and all of them failed. How can I get the input JSON that went into those 18K calls? I tried to query with proper timeframe in log analytics workspace but it only gives other details, not the input JSON. Does anyone know which table and columns to query to obtain this?

Answer 1

Capturing the input JSON for failed API calls in a Logic App can be challenging since it's not always logged by default. However, you can try using the AzureDiagnostic table in Log Analytics, which holds detailed information about each Logic App run, including inputs—if logging was set up properly.

If you don't find the input JSON there, it might be because input logging wasn't enabled in the Logic App's diagnostic settings at the time of those calls. To avoid this issue in the future, make sure input logging is turned on in the diagnostic settings. This will ensure that all incoming request data is captured in the logs going forward.