Google API Login

[J.M.]

Hi,

I'm trying to make a simple process to add a single event on a Google Calendar.

So, I've created two only activities: the first one is a connector type activity, that I've linked with the "Google API Login > Login Calendar" connector. As the description says, it has two input variables (login, password) and one output variable (Auth), whose value is ${P_result.Auth}.

However, I'm getting the following error:
Task "<my_name_task>" (id: 1[0] - status: ACTIVE): Forbidden (403) - Forbidden (1 attempt).

My first idea was, I wrote a wrong login or password, but they are correct.

I need some help, please.

Regards.

[Sweta Suman]

Hi,

You have to change the Google Calendar API's with latest version (API v3). The Connectors in our library is still V-2 and we are working to update them. You can create a custom connector for your application.

Please find attached document herewith for creating Google Calendar connectors using API V3.

Hope this helps you.

Regards,

Sweta

[J.M.]

Hi again,

Firstly, Thanks Sweta for the fast reply.
Secondly, I'm having some problems following the document attached.

In section "Configure the RunMyProcess connectors > Generate the refresh_token", I have created the provider and the connector, but when I click on Launch Test, the results I get are completely different. I get the code of an html error page with "Error Not Found. The requested URL was not found on this server. That’s all we know."

I've noticed that the screenshot's not the same as mine. When I call the connector I see more variables, but they are not variables, they are de values written on the content field in the connector configuration.

How could I get the refresh_token? Where is my error?
I need a little more help, please.

Regards.

[Sweta Suman]

Hi,

Please find attached screenshot and remove fields mentioned in screenshot.Try  launching  it again.

If problem persist ,please revert back.

Thanks,

Sweta

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://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/86ab8ed4-8032-4528-9912-ddfda60d19a0%40runmyprocess.com.

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

[javiermm...@gmail.com]

Hi,

I've already tried it, but I got the same result.

I've also noticed that the URL used for filling the Authorized JS origins while configuring the consent screen on Google Developers Console is not working. Can it promote the error?

Sorry for the inconvenience,
Regards.

[Sweta Suman]

Hi,

Make sure in Google Credentials Redirect URIS is your web interface URL and js origin is https://live.runmyprocess.com

Could you please share screenshot of connector configuration and exact error you are getting in result.

Thanks,

Sweta

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/c439c2bc-0e1f-4950-91cf-851869b53f57%40runmyprocess.com.

[J.M.]

Hi,

After a deep review, I've seen that my URL Test (I'm on test mode), in the provider configuration, was http instead of https. Now, this field is correct, but I'm getting a new error, most likely to the solution, I think, but an error.

I attach screenshots of Provider, connector, and launch test (Where the error is visible).

Thank you so much for the support, Sweta.
Regards.

[Sweta Suman]

Hi,

It seems that you have blank space after &grant_type=authorization_code in content of connector.Try after eliminating white space.

Let me know if  you still have any problem.

Thanks,

Sweta

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/4e7fdbe2-d405-4e62-b599-5122811a06e4%40runmyprocess.com.

[jess...@gmail.com]

Hi,

I'm trying to use connector login spreadsheet, and it shows an error. Could be because after I should to create a new provider and new connector, like in after case??

Attach images with my configuration and with error.

Thanks and regards,

Jessica

[J.M.]

Hi,

Thank you so much, Sweta.

Now, I can login on the Google API, and complete the example. However, I need to Add an event to a calendar, and I don't know how to send the parameters I need to add the event (start time, end time, where is the event...)

I've seen a parameters list in the Google Documentation, and I think, I would have to put them on the content field of the connector, after selecting POST method, but I don't know how to do that.

I need some more information about that, please.

Regards.

[Sweta Suman]

Hi,

Yes,you are correct.

Follow below steps to -

1) You have to create a provider with URL https://www.googleapis.com/ and configure it as  (screenshot 1) to access Google API's.

Authentication Scheme -> Custom

Scheme name -> Bearer

Credentials -> ${access_token}

2) For creating an Event you need to go to the Google’s calendar and go to the specific calendar settings -> Calendar Id (screenshot 2).

3) Configure connector as -(screenshot 3)

Provider url : https://www.googleapis.com/

Connector url : calendar/v3/calendars/${calendarId}/events

Content: 

{

 "end": {

  "date": "${end_date}"  

 },

 "start": {

  "date": "${start_date}"

 },

 "summary": "${summary}"

}

Note: Date should be in “yyyy-mm-dd” format.

4) Once you launch the connector you need to fill param’s see screenshot 4.

Similarly, you can create connector for Delete Event,Get Event etc under same provider(configuration).

For more information refer this link:  https://developers.google.com/google-apps/calendar/v3/reference/

Hope this helps you.

Thanks,

Sweta

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1743707f-35a8-4c58-993a-21f6836fe2b8%40runmyprocess.com.

[jessi mj]

Hi,

but my problem is with connector login spreadsheet. It´s not working.

Before I attached my configutation. 

Attach images with results.

Regards

You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/JSM7xLaheTw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://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/CAEibfQ-Ae2Y_ra8jCeDJMRiEsZQ17iDD5HknrmnHT1NZ7_iL0g%40mail.gmail.com.

[J.M.]

Hi,

Thank you very much, Sweta. It works! I'm doing follies with the calendar :-)

But the issue of jessi mj, is just my next problem.
I'm trying to log in many Google services, and I'm having some difficulties to log in them.
Is there any problem with the login API Google?
In spreadsheet case, de connectors list shows "V3" in many of them...

So... What services need the approval in a way like Calendar?
How can I Log in Google spreadsheet login?

Regards.

[Bidisha Das]

Hi J.M,

The login api for different Google connectors are different as you can check in Goolge API Login connectors available on RMP and there is no problem with any of the Login APIs though you may find issue with other google connectors if they are deprecated. In that case you need to create your own custom connectors.

As for Google Spreadsheet, the login api would be Login Spreadsheet connector. The other Google Spreadsheets connectors available in library are working fine as of now.But you need to test each connector by impoting them to process and if they don't work,you need create your own apis to perform the activities you want.

As per the Google Login apis are concerned,you need to use different ones for different Connectors.

For eg: For Google Calendar,you need to use Login Calendar api, for Google Contact,you need to use Login Contact api etc.

For creating your own providers and connectors,you can refer to: http://docs.runmyprocess.com/Integration_Guide/Connector_Design and as for the apis, you need to search for that in the particular sites(Google Contact,Goolge Calendar etc).

Hope you are clear.In case you have any other queries,please feel free to ask.

Thanks & Regards

Bidisha

[Bidisha Das]

Hi,

If still facing error,you can refer to similar Case on Support: [supportforum:4979] Problem with Add to Spreadsheet. It has already been answered there.

Thanks & Regards

Bidisha

[javiermm...@gmail.com]

Hi,

...and yes, I've found my solution on that post.

Thank you anyway.

Regards

[Tejas Laddha]

Hi Jessica,

I have tested and I found that If I am passing app-password it is running successfully.

In order to generate app-password please refer below urls - 

https://support.google.com/accounts/answer/185833

https://support.google.com/mail/answer/78754?hl=en

Pass this app-password as password to the connector.

Hope this will solve your problem.

Thanks and Regards,

Tejas Laddha

Fujitsu RunMyProcess

--

Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://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/CAMGV9zs-j3RX8%2Bd0A24R-k-GoRxJ_zzvrpBkOMCp7fv8aamCGw%40mail.gmail.com.