Appsheet should naturally get tied with G Suite services and product as the time goes by, which is basically โNo Doubtโ. I believe you app creators would agree with it.
Google Chat should be one of the service G Suite users are broadly adopting to their day to day jobs on the enterprise basis. It should be common needs โHow to integrate Appsheet app with Google Chatโ?
Bunch of people should have been implemented this integration, but I tried it out with my app, and found it was super simple and easy. To share my experiences for those who would seek a solution toward the future. (this is also my own memorandamโฆ)
1. Get the โEnd pointโ URL from your Google Chat Rooms.
Beatifully simple. Go to your Chat room and copy the URL.
Go to your chat rooms you want to submit messages. And hit the Manage Webhook
2. Just copy the URL
3. Go to Appsheet editor, workflow and past the URL you copied.
Note
Workflow settings.
Simple JSON!
{
โtextโ: โ<<[FieldNameYourWantToPassFromaRowToGoogleChatRoom!]>>โ
}
โ
Beside that, you simple set up workflow as usual, when and how to โfireโ the workflow as you wish.
Thank you Appsheet team, to make it and our life super simple and easier!!!
According to Google API documentation, we could do lots, sending message to chat room with card view etc. Should be a fun.
https://developers.google.com/hangouts/chat/concepts/cards
Please try it out and kindly share your own experiences and tips you find.
We have had native connector on webhook set up for Slack even before Appsheet become google cloud team, so I suspect this integration should be come much more simpler, but until then we just set up in this way, but still easy.
And great post documenting the setup.
Like for those pro engineers and pro appsheet handler like you, you probabaly can set this up with your eyes closedโฆ
Hereโs an easy Google Meet integration I found:
Thanks for this, shamely I overlooked it.
The problem in terms of google calendar as data source, is how to change the โorganizerโโฆ I discussed privately with Appsheet team, but still can not find a solution. And the google meet settion is auto generated, but unless โorganizerโ is to join the session, we can not invite others, which is a problem, as far as I clearly remember the issues.
Koichi, if I remember the case it was that if the organizer is not joining the event, nobody is able to join because with the normal gSuite they need to ask the permission to join.
Too many topics I discussed with you, friend, I will wrap up things !
Yes, you should be right!
I do the same as you but what is the error like this?
Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request.
See my original post.
JSON must be in this schema, so you are getting error.
I have tried but still error:
Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request.
Help me!
What you json body currently looking like.
body:
{
โTรชn HHโ: โ<<[Tรชn HH]>>โ
}
Error:
Failed: Action not performed because 1 errors are present. Error: Failed to parse JSON due to Invalid property identifier character: โ. Path โโ, line 1, position 1โฆ Invalid JSON value starts with: โTรชn HHโ: โMรกy xแปt rแปญa Model KHG-1410A - Kowonโ}.
It should be
{
โtextโ: โ<<[Tรชn HH]>>โ
}
Hi
I have tried but still error:
then try
{
โtextโ: โ<<encodeurl([Tรชn HH])>>โ
}
tรดi ฤรฃ thแปญ nhฦฐng vแบซn lแปi:
ailed: Action not performed because 1 errors are present. Error: Failed to parse JSON due to Invalid property identifier character: โ. Path โโ, line 1, position 1โฆ Invalid JSON value starts with: โtextโ: โM%C3%A1y%20x%E1%BB%8Bt%20r%E1%BB%ADa%20Model%20KHG-1410A%20-%20Kowonโ}.
Unfortunately, I run out of my idea, and it is beyond my skill.
Suggest you go to support appsheet to call for a help.
I only guess your [Tรชn HH] field may contain the value which can not be used in HTTP request.
Thanks you very much!
I discovered the error is due to the mode not enabled:
Run asynchronously?
Should AppSheet run this webhook asynchronously (in the background) and let the rule return immediately ?.
But the data is not sent to google chat?
Help me!
Async seting is nothing to do with your problem.
I strongly suspect the problem is from JSON.
I decoded your text and passed to my sample app for google chat and it did work without error.
Mรกy xแปt rแปญa Model KHG-1410A - Kowon
Placed JSON to JSON validator, also returns no errorโฆ
Not sure why you see error.
I do not understand why?
Can anyone help me with this problem?
re type JSON from scratch.
apostrophes inside JSON payload may be typed wrongly, this is only a guess I have
and then test your json
to see if you see no error.
I have tried and tested as you said but with no error
[image]
As i said JSON body need to be above format!
The syntax is correct but the current data is not passed to google chat. I really donโt know why and what to do.
What the current json looks like๏ผ
Itโs looks like:
{
โSTTโ: โ<<[STT]>>โ,
โNgร y KKโ: โ<<[Ngร y KK]>>โ,
โMรฃ HHโ: โ<<[Mรฃ HH]>>โ,
โTรชn HHโ: โ<<[Tรชn HH]>>โ,
โฤvtโ: โ<<[ฤvt]>>โ
}
Please refer to previous message and advice to yoi
I did everything as you said but couldnโt.
I do not know why.
This creation of you will keep me from using zapie, but I canโt use it now.
I am so sad
Please ask for support from support@appsheet.com
Thanks you so much!
Let me know once the problem is cleared by the support team.
Good luck!
Yes sir.
They are doing help me!
I am sorry , i get the same error (โFailed to parse JSON due to Invalid property identifier character: โ. Path โโ, line 1, position 1โฆ Invalid JSON value starts with: โtextโ: โtext automat trimisโ}โ,) , by only using :
{
โtextโ: โtext automat trimisโ
}
Can anyone point me in the right direction please ?
Thank you
{
โtextโ:โtext automat trimisโ
}
Not exactly sure where this problem coming from but possibly double quote?
Copy above JSON and past to the JSON body as it is.
Try it out.
Thanks for your input. I was just trying that. I typed it all , instead of copying , and it worked.
My typed double quote is : " " " " , and it works
The pasted one is : โ โ โ , and i get that error
They look different. Both written and pasted code is succesful in the recommended Json formatter page. Maybe it has something to do with regional settings.
@Le_Van_Luyen , maybe this works for you too.
Yes, exactly, that is the root cause of issue.
But not sure why people is getting different type of format for DOUBLE QUOTEโฆ
Just because of difference betwee straight and curly quotes.
We have to be bear in mind,upon constructing JSON to pass.