Sending nested data from google sheet to API

Question

I am trying to implement following REST in google script

Code I have used is as below

function whatsapp() {
  //https://www.gupshup.io/developer/docs/bot-platform/guide/whatsapp-api-documentation#SendText

  var payload = {"channel":"whatsapp", 
                  "source":"917834811114", 
                  "destination":"91999990**34",//I have * done it on purpose  
                  "src.name":"googlerishisheet", 
                 "message.payload" : {
                   "isHSM":"true",
                   "type": "text",
                   "text": "Hi John, your order is confirmed and will be delivered to you by 15 Feb"
                 }
                }
                 
                           
  var url = 'https://api.gupshup.io/sm/api/v1/msg?apikey=0*8e4a487d6d4d3ccd2d52e7f0ffb78f'; // I have done * on purpose
  var options = {"method" : "post",
                 "payload" : payload};
   UrlFetchApp.fetch(url, options);
}

Result I am getting is

I have tried following ways also.

"payload":JSON.stringify(payload) Result - {text=Hi John, your order is confirmed and will be delivered to you by 15 Feb, type=text, isHSM=false}
"message":{"payload" : { "isHSM":"false", "type": "text", "text": "Hi I am testing whatsapp" }}}; and set contentType to x-www.....urlencoded..

Result - {payload={type=text,text=Hi I am testing whatsapp, isHSM=false}}

"src.name":"googlerishisheet", "message.payload.isHSM":"false", "message.payload.type": "text", "message.payload.text": "Hi I am testing whatsapp" }; Result - Same issue

Tried that too, not working getting same following result _{text=Hi John, your order is confirmed and will be delivered to you by 15 Feb, type=text, isHSM=false}_ — Rishi Mittal, Apr 15 '20 at 01:17
Now it is showing _{payload={type=text,text=Hi I am testing whatsapp, isHSM=false}}_ — Rishi Mittal, Apr 15 '20 at 08:52
How about `var payload = {"channel":"whatsapp", "source":"917834811114", "destination":"91999990**34",//I have * done it on purpose "src.name":"googlerishisheet", "message.payload" : JSON.stringify({ "isHSM":"true", "type": "text", "text": "Hi John, your order is confirmed and will be delivered to you by 15 Feb" }) }` and `contentType:"application/x-www-form-urlencoded"` in options? — TheMaster, Apr 26 '20 at 08:59
writing message.payload as follows done the trick. ` "message.payload":"{\"isHSM\":\"false\",\"text\":\"Testing message\",\"type\":\"text\"}" ` Taken this from [https://curl.trillworks.com/] which converts curl to json ALSO Just checked `contentType:"application/x-www-form-urlencoded" ` is default in google script [https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app] — Rishi Mittal, Apr 26 '20 at 10:01
JSON.stringify({ "isHSM":"true", "type": "text", "text": "Hi John, your order is confirmed and will be delivered to you by 15 Feb" }) **also worked** — Rishi Mittal, Apr 26 '20 at 10:10

score 2 · Accepted Answer · answered Apr 26 '20 at 10:54

2

Documentation states that message.payload value is of type object. However, it seems you should send it as plain string, while maintaining the payload contentType as "application/x-www-form-urlencoded"

    "message.payload" : JSON.stringify({
                   "isHSM":"true",
                   "type": "text",
                   "text": "Hi John, your order is confirmed and will be delivered to you by 15 Feb"
                 })

answered Apr 26 '20 at 10:54

TheMaster

45,448
6
62
85

1

I implemented this in Python using ```json.dumps``` thanks for the help @TheMaster – JenilDave Apr 30 '20 at 06:26

score 0 · Answer 2 · answered Apr 14 '20 at 12:49

0

You may need to add content type as well.

var options = {
                "method" : "post",
                "headers": {
                  "Content-Type": "application/json"
                 },
                 "payload" : payload
             };
UrlFetchApp.fetch(url, options);

answered Apr 14 '20 at 12:49

Anees Hameed

5,916
1
39
43

Without headers also this thing i working, issue is not accepting nested data in this format. – Rishi Mittal Apr 14 '20 at 12:55

score 0 · Answer 3 · answered May 26 '20 at 04:36

If you are sending this message as a template message, be sure that your template is approved by WhatsApp or the same template that you're using ("Hi {1}, your order is confirmed and will be delivered to you by {2}") is pre-approved by GupShup. You can check it in your Dashboard.

Sending nested data from google sheet to API

3 Answers3