Google Sheets - Read and update

[arman_...@icloud.com]

Hi Team,

I'm creating an RMP app to log conformance issues. The goal is to:
1. Allow a user to enter a new conformance issue.
2. Allow a user to update information on a conformance issue.
3. Provide a report on all logged issues.

To do achieve this I need some assistance in understanding how to do the below:
1. Connect to a private Google Sheet (it will be stored on a single google account but needs to be accessible by multiple RMP user accounts).

2. Add a new row to the sheet mentioned in the previous step using inputs from web interface widgets.

3. Read all of the data in the sheet. This needs to happen on loading a web interface from the home screen. This needs to happen on the page load so that I can allow a user to modify and save data for each issue (sheet row) logged.

4. How to update a row in a Google Sheet using inputs from web interface widgets.

Using a collection would be good, but given the requirements of the business I'm going to run out of my limited amount too quickly, thus I need to be able to store and access this data in a Google Sheet.

Regards,

Ben Jones

[arman_...@icloud.com]

Hi Team,

Any luck with this one yet?

[Pankaj Kumar]

Hi Ben,

To integrate the Google Sheet, first you need to authenticate using the Google OAuth2. Please refer to below link for reference:- 

• https://developers.google.com/identity/protocols/OAuth2
  
• http://docs.runmyprocess.com/Integration_Guide/Google/Authentication
  

RunMyProcess had provided the connectors in connectors library, that you can use for integration:-

Provider:- Google Oauth2 authentication

Connectors:- 

1. Retrieve refresh token
   
2. Refresh access token
   

and 

Provider:- Google Sheets v3

This provider contain 15 connectors for the sheet API.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

On Tue, Jul 24, 2018 at 6:01 AM, arman_chaser via Fujitsu RunMyProcess Developer Community <suppor...@runmyprocess.com> wrote:

Hi Team,

Any luck with this one yet?

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/63342e43-ac73-4c24-96f5-8bf30d2d493a%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Dipen Raval]

Hi Ben,

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

Fujitsu - RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCazrCqJAeC4oG4FHvsOeG_c%3D%3DqNg7u%3DK5rZ%2Bu0mxC0AGtw%40mail.gmail.com.

[arman_...@icloud.com]

Hi Dipen,

I'll be able to test this out next week (or early the week after). If it doesn't work I'll reply to this thread.

Thank you for your help, much appreciated.

Regards,

Ben Jones