• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Error using trading view webhook to excel

Mattnz

Member
Hi, I have a macro enabled excel which is connected to Pabbly.

I have successfully added the provided webhook so that alerts generated by Trading View are used as the trigger to create a new excel row with that alert as the text.

Everything looks to be set up perfectly, but it isn't creating the new row in excel at all.

Instead I am getting this error "Bad Request - Error in query syntax."

Res3 Error InnerError Request-id 0b18c995-2ba2-41fb-a3e7-e8bdd31b811f

The test message that I am sending is
US30, 1 Greater Than Volume Weighted Average Price (Session, hlc3, 0, 1, 2, 3),23|test

Please advise:
1. Why it isn't working correctly, as everything looks to be set up perfectly
2. What I should use as a delimiter for the output to be separated into different columns

Thanks!
Matt
 
P

Pabblymember11

Guest
Hey @Mattnz

It appears that in your MS excel sheet, you haven't mentioned any column header in it, and because of that the data you are passing is not working accordingly.

So, kindly add headers in your MS excel sheet and then try again.

(Watch the second part of the video)
 
Top