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.

Bonjour,

I'm taking the liberty of writing here because I have a small problem in a Zapier scenario.

In the scenario, I have two modules:

  • MySQL → New or Updated Row in MySQL (to check whether a line has been modified)
  • YouTube → API Request Beta (to update the "title" metadata of the YouTube video)

The problem lies in the YouTube module action in the request body :

 

The title property I'm trying to send dynamically is giving me an error:

Question :

How do I send dynamic data from the request body?
I'd like to retrieve the video id from my db, for example...

Thanks in advance,

Best regards,

Mediapole.

@mediapole 

Make sure to reference the YouTube API docs for the endpoint to see the required parameters:

https://developers.google.com/youtube/v3/docs/videos/update

 

 

@mediapole 

You may want to try this Zap action: YouTube - App Extensions

There is an AI assist that can help configure the action.

 

Hello @Troy Tessalone, thanks for the documentation !

When I enter the id by hand and the title, the query executes correctly.

However, if I fetch the data directly from my database, the query doesn't run correctly, as I said in my previous message.

Thanks in advance,

Best regards,

Mediapole.

@mediapole 

Check if the Title has double quotes as that would break the JSON.

 

Hello @Troy Tessalone, 

Resolved but I can't say why unfortunately...
Maybe the (!!) character in the title was causing the error.

Whatever, thanks for your response and have a nice day.

 

Mediapole.

Hello,@Troy Tessalone 

Yes.. It seems to be the special characters that generate this error.
Is there a way around this?

Without special characters its ok ->

 

With special characters →

 

@mediapole 

Options to try:

  • make sure the data input into MySQL has no special characters.
  • encode special characters
    • Formatter
  • use a Zap step to remove special characters:
    • Formatter
    • Code
Terms & Conditions