Missing JSON fields when using Zapier with API webhook

Hi ​@Craiger 

Try using the Code by Zapier app to make the app API request: https://zapier.com/apps/code/help

This is a known limitation, as Zapier's Webhooks can struggle with deeply nested JSON structures.

Incorporate a "Code by Zapier" step as recommended by Troy using JavaScript to manually parse the JSON response and extract the required nested fields. Here's how you can implement this:

• Add a Code Step: After your Webhook step, insert a "Code by Zapier" action.

• Parse the JSON: Use JavaScript to parse the JSON string and extract the necessary data. For example:

  const response = JSON.parse(inputData.response); const subTasks = response.subTasks || []; const stops = subTasks.map(task => task.stops || []); return { stops: JSON.stringify(stops) };

  This script parses the JSON and extracts the stops array from each subTask. The extracted data is then returned as a stringified JSON, which can be used in subsequent Zap steps.

If you're using a "GET" request in your Webhook, ensure that the request headers accept JSON responses. This can be done by setting the "Accept" header to "application/json" in your Webhook configuration. This informs the API to return the response in JSON format, which Zapier can then process.