Webhook Catch is not parsing JSON

Question

I am using a POST request to a Zapier Webhook Catch Hook. When I receive the JSON, it is not being parsed into each unique field. Any Ideas? Here is the JSON:

{
    "Invoices": [
        {
            "Customer": "ZenWTR",
            "Email": "jq@zenwtr.com",
            "Terms": "Due Upon Receipt",
            "InvoiceDate": "10/5/2020",
            "DueDate": "10/5/2020",
            "InvoiceNbr": "2020-211",
            "RecessPO": "2020-211",
            "Items": [
                {
                    "ProductService": "Event Sponsorship Fee",
                    "Description": "2020-10-06 - Product Sampling - El Toro Flicks - Coachella Valley Drive-In Theater",
                    "Qty": 1808,
                    "Rate": 0.5,
                    "Amount": 540,
                    "Class": "ZenWTR"
                },
                {
                    "ProductService": "Event Sponsorship Fee",
                    "Description": "2020-10-13 - Product Sampling - El Toro Flicks - Coachella Valley Drive-In Theater",
                    "Qty": 1808,
                    "Rate": 0.5,
                    "Amount": 540,
                    "Class": "ZenWTR"
                }
            ]
        },
        {
            "Customer": "Stratus Group Duo llc.",
            "Email": "brooke@stratusgp.com",
            "Terms": "Due Upon Receipt",
            "InvoiceDate": "09/22/2020",
            "DueDate": "09/22/2020",
            "InvoiceNbr": "2020-190",
            "RecessPO": "2020-190",
            "Items": [
                {
                    "ProductService": "Event Sponsorship Fee",
                    "Description": "2020-10-10 - Product Sampling@BIG Kahuna 6-Man Beachfest",
                    "Qty": 200,
                    "Rate": 0.5,
                    "Amount": 100,
                    "Class": "Stratus Group Duo llc."
                },
                {
                    "ProductService": "Event Sponsorship Fee",
                    "Description": "2020-09-26 - Product Sampling - Silverlake Flea Market",
                    "Qty": 500,
                    "Rate": 0.5,
                    "Amount": 250,
                    "Class": "Stratus Group Duo llc."
                }
            ]
        }
    ]
}

Here is the result of the Catch Hook:

nicksimard · Answer

Hi @Mercology!For nested array fields, Zapier flattens the contents of the field into a single string. If you wish to accesseachindividually, you need to do a couple of things:Change your webhook trigger type to "Catch Raw Hook"Setup a code action step to parse the JSON payload from the trigger and extract the fields you need programaticallyCode steps have a built-in library function called JSON.parse that might be able to extract the fields that you need to use in later steps. Here's an example of what I mean:I must point out here that Code steps are an advanced feature so our support for them is limited.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded