Question

Failed to create an HTTP request in YouTube: Raw request failed.

  • 4 September 2023
  • 7 replies
  • 221 views

Userlevel 1
Badge +1

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.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7
Badge +14

@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

 

 

Userlevel 7
Badge +14

@mediapole 

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

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

 

Userlevel 1
Badge +1

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.

Userlevel 7
Badge +14

@mediapole 

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

 

Userlevel 1
Badge +1

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.

Userlevel 1
Badge +1

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 →

 

Userlevel 7
Badge +14

@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