Skip to main content
Best answer

How to Save Multiple Records to Zapier Tables from Webhook Data?


Forum|alt.badge.img

Hi everyone,

I’m fairly new to Zapier and could use some guidance on how to properly save multiple records into Zapier Tables from a webhook payload.

My Scenario

  1. I’m catching JSON data via a Webhook, which looks like this:
    {
      "releaseName": "Test Release 04",
      "releaseDescription": "Major Release - Testing API",
      "releaseDate": "2025-02-10",
      "releaseVersionId": "10135",
      "issues": [
        { "key": "Jira-987", "summary": "Test Ticket 03", "releaseNotes": "Continued Testing Ticket 03 for v2" },
        { "key": "Jira-986", "summary": "Test Ticket 1002", "releaseNotes": "Continued Testing Ticket 02 for v2" },
        { "key": "Jira-985", "summary": "Test Ticket 1001", "releaseNotes": "Testing V2 of the Release Notes Integration to Confluence" },
        { "key": "Jira-944", "summary": "Test Story", "releaseNotes": "" },
        { "key": "Jira-918", "summary": "TEST TICKET - PLEASE IGNORE", "releaseNotes": "" }
      ]
    }
     
  2. I want to loop over each issue in the issues array and save it as a separate row in Zapier Tables with the following structure:
    Release Name Release Description Release Date Release Version ID Issue Key Release Note
    Test Release 04 Major Release - Testing API 2025-02-10 10135 Jira-987 Continued Testing Ticket 03 for v2
    Test Release 04 Major Release - Testing API 2025-02-10 10135 Jira-986 Continued Testing Ticket 02 for v2
    Test Release 04 Major Release - Testing API 2025-02-10 10135 Jira-985 Testing V2 of the Release Notes Integration to Confluence
    Test Release 04 Major Release - Testing API 2025-02-10 10135 Jira-944 (empty)
    Test Release 04 Major Release - Testing API 2025-02-10 10135 Jira-918 (empty)

The Problem

  • I tried using Zapier Loops, but when I create a record in Zapier Tables, all the issues end up in a single column (e.g., "Jira-987,Jira-986,Jira-985,Jira-944,Jira-918" in one field instead of separate rows).
  • I also wrote custom JavaScript Code by Zapier to process the dataset, but I can't seem to make Zapier Tables loop through the individual records correctly.

What I Need Help With

How do I iterate over each issue in the dataset and insert them into Zapier Tables as separate rows?

Any guidance would be greatly appreciated! Thanks in advance. 😊

 

Best answer by dawidspamer

Hi ​@Troy Tessalone 

Thank you for your help - very much appreciated!

I will add steps with Screenshots below:

Overview of Zap setup:
 

Overview of Zap setup



 

  1. Webhook Output

     

  2. Code parsing output
    There’s a total of 5 Issue Keys with 5 Release Notes. My code created 5 LineItems as a data output to be Looped over and then the idea is to save each LineItem to its own row in the Table.
    Note: Images below are from the first and last LineItems
     

     

  3. Looping by Zapier
    ​​​

    1. Action event: Create Loop From Text


       

    2. In Configure I map the keys and values, plus I use a “,” as a Text delimiter.

       

    3. My Test Data Out looks good with 5 iterations as expected.
       


       

  4. Zapier Tables - Create Record
    » This is where I’m having issues. Not sure what I’m doing wrong…
     

    1. Action event: Create Record
       


       

    2. In Configure I use the Preview Loop Values to map the values to the Table Fields,, but this creates a 400 Validation Error.
       



      ** THEN I ALSO TRIED MAPPING TO DIFFERENT VALUES IN THE CONFIGURE STEP **

      But this only saves one record to the table :(
       

 


The only other reason I can think of is that my last method is the correct method, but I actually need to run a live test to see all the records populating in the table as the Test only handles one record, but something doesn’t feel right about it.

I really value your help with this issue.
Thank you in advance!

View original
Did this topic help you find an answer to your question?

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@dawidspamer 

Use the Looping Zap app: https://zapier.com/apps/looping/integrations#help

Zap action: Looping - Create Loop from Line Items

If you need help, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

 

 


Forum|alt.badge.img
  • Author
  • New
  • 3 replies
  • Answer
  • February 11, 2025

Hi ​@Troy Tessalone 

Thank you for your help - very much appreciated!

I will add steps with Screenshots below:

Overview of Zap setup:
 

Overview of Zap setup



 

  1. Webhook Output

     

  2. Code parsing output
    There’s a total of 5 Issue Keys with 5 Release Notes. My code created 5 LineItems as a data output to be Looped over and then the idea is to save each LineItem to its own row in the Table.
    Note: Images below are from the first and last LineItems
     

     

  3. Looping by Zapier
    ​​​

    1. Action event: Create Loop From Text


       

    2. In Configure I map the keys and values, plus I use a “,” as a Text delimiter.

       

    3. My Test Data Out looks good with 5 iterations as expected.
       


       

  4. Zapier Tables - Create Record
    » This is where I’m having issues. Not sure what I’m doing wrong…
     

    1. Action event: Create Record
       


       

    2. In Configure I use the Preview Loop Values to map the values to the Table Fields,, but this creates a 400 Validation Error.
       



      ** THEN I ALSO TRIED MAPPING TO DIFFERENT VALUES IN THE CONFIGURE STEP **

      But this only saves one record to the table :(
       

 


The only other reason I can think of is that my last method is the correct method, but I actually need to run a live test to see all the records populating in the table as the Test only handles one record, but something doesn’t feel right about it.

I really value your help with this issue.
Thank you in advance!


Forum|alt.badge.img
  • Author
  • New
  • 3 replies
  • February 11, 2025

@Troy Tessalone 
I think I just answered my own question here…

It turns out that the method was the correct method. The test output is very deceiving as it only saves one record to the Table. After publishing my Zap and dong a few test runs the Zap runs perfect and created all the records in the Table for me. 

Thanks again for your help!


Troy Tessalone
Forum|alt.badge.img+14

@dawidspamer 

Yes, as documented in the Looping help link, only the first Loop iteration will run when testing.

If you want to optimize the Zap, you do NOT need the Code step.

And instead, make sure to use this Zap action: Looping - Create Loop from LINE ITEMS


Forum|alt.badge.img
  • Author
  • New
  • 3 replies
  • February 11, 2025

@Troy Tessalone Thank you, I will do that.

Cheers!