can I use " (double-quotation) in call a webhook body ?

[matt2]

I want to use　 "　 in webhook body.

but , it Automatic escaped.

"     is changed     \"

 

Please let me know if you know something about this matter.

 

[SkrOYC]

---

@matt2 wrote:

I want to use　 "　 in webhook body. 

---

Why?

[matt2]

tool ls want it.

exsample

"payload" : "body" : "this is text area"

I write   "body" : "this is text area"

then it changed

"\"body\" : \"this is text area\""

😵

[SkrOYC]

It seems like you are not creating the body correctly {}

Check:
Scheduled chart report via Telegram Bot API and Qu... - Google Cloud Community

[matt2]

Thank you very much!!　ありがとう！

I will try it😉

[matt2]

I tried, but I can't solve it

"name": "john"
Can I output such a syntax via Appsheet?
If you know, please give me some additional tips.

It always changes like this
"name \": \ "john",

I tried followings

• Put " in: Column
• substitute
• body template

but I can't solve it

please help me 😩

[SkrOYC]

It's a JSON body I guess, so use JSON

[matt2]

Thank you very much! ありがと！感謝！

I see, it I should start from JSON learning before appsheet 😉

[SkrOYC]

For your specific scenario, it seems like it's needed

[matt2]

I'm beginner. and I'm not good at English.

Thank you for guessing the situation and for suggesting what I need.

It takes time to learn Json and how Json and Appsheet work together, so this time I'll try using zapier or iffft first.

And I also start study json.

[dbaum]

Try escaping each embedded quotation mark with another quotation mark. In the help article about webhooks, that's the instruction when a header must include quotation marks. Maybe it would also work for the payload. 

[matt2]

@dbaum  @SkrOYC 

Thank you very much for new advice.

but, I can't contoroll  " quotation mark😩

I will study json. 

 

[SkrOYC]

The exact problem I see in your problem is that you forgot curly bracket.
The basics of JSON are not difficult, quite simple actually

[Marc_Dillon]

Yes, Appsheet automatically inserts the backward slashes into your JSON payload body. This is standard behavior, as all JSON data is "stringified" when sent through a webhook. Here is a screenshot from one of my webhooks:

I've never had this cause any issues. What exactly is your issue here? Is the system receiving the webhook throwing an error? (maybe it expects a different format besides JSON?)

If you're wanting to include a literal double quote, you'll need to include it in another set of single quotes, like this:

{ "field" : ' 12" Skillet ' }

When you do that, and inspect the payload text, you should notice that there are actually 3 backslashes in front of the double quote: \\\"

[matt2]

Thank you very much!!

error is following

Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request.

Of course, my purpose is to use the API, not the double quotes.
but, I'm a beginner and I don't understand if this error is due to improper use of double quotes.　So, first I thought about writing it according to the manual and testing it.

The biggest problem is that the information on the cooperation between this tool and APPSHEET does not exist on the web.The tool is chatwork. This is the chat APP with the largest market share in Japan.I want to solve this problem and share the information with everyone in Japan.

https://developer.chatwork.com/docs

[Marc_Dillon]

"400 Bad Request" is a generic error. It just means something is wrong with your request format or something. Why are you assuming the issue is with the back slashes? I highly doubt the issue is with the escaped quotes. More likely, as it looks like others have already suggested, you simply aren't building the request body correctly. Read their API docs more thoroughly (can't really help you there because of the language). Always start with the simplest case and build from there. I also suggest using Postman to test API requests like this, it'll be much faster and easier than doing it within Appsheet.

[matt2]

I think,
maybe it need following format

"body":"text" is okay

"body\":\"text" is can't work

[jdtyler-dev]

This actually helped me with my active QA Question. I realized pretty quickly the \ are not something to stress over because after messing around with the order i noticed the syntax errors had been resolved even though the error report for a different exception still had all the request stringified. i then thought about all my App Script functions that use JSON.stringify/parse and it all clicked. I am still having issues with my Start: [Related FooBar] causing my request body to register as an empty webhook body but at least i found understanding in the raw syntax of the webhooks architecture. THANK YOU!