Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • Troubleshooting
  • Zapier Tables Error code 400: Error found at request.body.record_ids.0: Cannot create ULID from string of length 4 (general:validation_error)
Best answer

Zapier Tables Error code 400: Error found at request.body.record_ids.0: Cannot create ULID from string of length 4 (general:validation_error)

  • April 24, 2024
  • 7 replies
  • 121 views
S

I am trying to create a table from an excel spreadsheet. Importing this table goes fine, but the data source always includes a summed line at the end. I am just tryiing to delete this row in the table.

 

I am using:

New record in Zapier Tables

Find Record in Zapier Tables

Delete Record in Zapier Tables

The error I get is:

“Error code 400: Error found at request.body.record_ids.0: Cannot create ULID from string of length 4 (general:validation_error)”

 

This Action creates the following error

 

 

 

My goal is to troubleshoot. If certain fields are empty, then the record should be deleted. The Find Record works fine.

Best answer by Troy TessaloneBest answer by Troy Tessalone

@syndic8er

Check the field description for more guidance about the expected value, which needs to be a variable that has the Record ID from Step 2.

This is not the correct variable to map from step 2. (A variable with a value of “true” is not a record id)

 

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

7 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @syndic8er 

Check the Record ID field description for guidance.

The Record ID field expects a Zapier Tables Record ID value. (rather than a value of “true”)

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
  • syndic8erBeginner
  • Author
  • Beginner
  • 6 replies
  • April 24, 2024

@Troy Tessalone But, won’t the Zap fail the next time a spreadsheet is imported with an offending record? If I use the exact ID, won’t it then fail to delete any record that doesn’t have that ID?

Troy Tessalone
Forum|alt.badge.img+14

@syndic8er 

In Step 3, map the Record ID dynamic variable from Step 2.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
  • syndic8erBeginner
  • Author
  • Beginner
  • 6 replies
  • April 24, 2024

@Troy Tessalone Isn’t that what I did originally? I mapped it to the step 2 variable in the screenshot.

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31058 replies
  • Answer
  • April 24, 2024

@syndic8er

Check the field description for more guidance about the expected value, which needs to be a variable that has the Record ID from Step 2.

This is not the correct variable to map from step 2. (A variable with a value of “true” is not a record id)

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
ken.a
1 person likes this
  • ken.a
    ken.a
S
  • syndic8erBeginner
  • Author
  • Beginner
  • 6 replies
  • April 24, 2024

thanks… that worked.

ken.a
1 person likes this
  • ken.a
    ken.a
ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6423 replies
  • April 25, 2024

That’s great news @syndic8er! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Reply


Terms & Conditions