Error while processing entry to data spreadsheet.

[Niraj]

I am getting error at the stage when it is supposed to write data to Google Spreadsheet which is mentioned in the process task and proper connector has already been attached.
The error is "Expression entry is undefined on line 1, column 3 in write data in spreadsheet." .
I am attaching the screenshots of Google spreadsheet configuration.

[Pankaj Kumar]

Hi,

Please check the variable "entry" you are passing in connector input variable as you are getting "undefined" error on it. In attached file "step_3", you are passing variable:-

entry = ${entry}, please check if this variable is already initialized or not?

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
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/2d302735-b646-4256-99f3-d5857630a5e0%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Amol Redij]

How to check if it is already initialized or not, mean where should I check it out? As mentioned in the step_3.

You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/hDb7ZswKPOc/unsubscribe.
To unsubscribe from this group and all its topics, 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/CADHrCazbxy-R_c0djY%3DGxLcvm4QipYvqcxVp4jx%2BnAUz%3D2W%2Bxg%40mail.gmail.com.

[Pankaj Kumar]

Hi,

Please try any hard coded string like "abc" instead of ${entry} in process variable to check if this is the reason of the error. 

Once you know the reason of the error, you can enhance it.

Please refer to below link on process input variable for reference.

• http://docs.runmyprocess.com/User_Guide/Development_Environment/Toolbox/Processes/Step/Process_Step_Input_Variables
  
• http://docs.runmyprocess.com/User_Guide/Development_Environment/Toolbox/Processes/Process_Input_Tab
  

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAPxRXeYaEk5aCVrKa64FHZRXJKVgt2ozzt5nNffxLTSj6OHTLQ%40mail.gmail.com.

[em...@amolredij.com]

> 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 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/2d302735-b646-4256-99f3-d5857630a5e0%40runmyprocess.com.
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
>
>
> --
>
> Fujitsu - RunMyProcess
>
> ---
>
> You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
>
> To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/hDb7ZswKPOc/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 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/CADHrCazbxy-R_c0djY%3DGxLcvm4QipYvqcxVp4jx%2BnAUz%3D2W%2Bxg%40mail.gmail.com.
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
> --
>
> 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...@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/CAPxRXeYaEk5aCVrKa64FHZRXJKVgt2ozzt5nNffxLTSj6OHTLQ%40mail.gmail.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

Now I got error message as "Task "write data in spreadsheet" (id: 22[0] - status: ABORTED): Error while processing spreadsheet_id
Expression spreadsheet_id is undefined on line 1, column 3 in write data in spreadsheet."
How to get spreadsheet id and worksheet id, as required to write in Spreadsheet.

[Pankaj Kumar]

Hi,

Please use the connectors below connectors from connector library in "Google Sheets v3" provider.

1. Get the id of a spreadsheet

2. Get the id of a worksheet

Please refer to attach screen-print for more details.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

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/eea9c95c-b5a7-4121-bf6d-6089e3e91b76%40runmyprocess.com.

[Amol Redij]

While attaching the connector, after importing it in current project, in the "Task Write data to google spreadsheet", as mentioned in step_11 of screen shots, Call a connector, then we get, choose a provider after selecting "Google Sheet v3", then Search a connector in the directory., But to Choose a provider there is 3 options corresponding to {add a row,spreadsheet id and worksheet id} then how to select from search connector in the directory as there is three separate connector list for each of connector imported, into single task of "write data to google spreadsheet."

To unsubscribe from this group and all its topics, 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/CADHrCaxEqy6MxMBXtZ7v-J%2B0toftfMGy9Hwxh-2UM1XpDK7thg%40mail.gmail.com.

[Pankaj Kumar]

Hi,

In your process, please create three activity and each activity select the connector in below sequence to execute:-

Get spreadsheet id --> get worksheet id -> add a row.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAPxRXeZcMpQHWfgu92Ca1J8pa8wBGniF7L8ygX_prsaZRxNX9w%40mail.gmail.com.

[Amol Redij]

Hi,

I created three activity but now I got the error message as " Task "get spreadsheet id" (id: 33[0] - status: ABORTED): Error while processing access_token

Expression access_token is undefined on line 1, column 3 in get spreadsheet id."

I am attaching the screen shots for corresponding 3 activity:

spreadsheet

worksheet

Add a row

as follows:

Please find Attachment here:

Thanks

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCazWzEoCxNj9acg7XQPAx%2BdGQrQJeNaE8GnZuvDPGeEO%2Bg%40mail.gmail.com.

[em...@amolredij.com]

> To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/eea9c95c-b5a7-4121-bf6d-6089e3e91b76%40runmyprocess.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
>
>
> --
>
> Fujitsu - RunMyProcess
>
> ---
>
> You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
>
> To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/hDb7ZswKPOc/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 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/CADHrCaxEqy6MxMBXtZ7v-J%2B0toftfMGy9Hwxh-2UM1XpDK7thg%40mail.gmail.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
> --
>
> 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...@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/CAPxRXeZcMpQHWfgu92Ca1J8pa8wBGniF7L8ygX_prsaZRxNX9w%40mail.gmail.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

"what and how to set different values like spreadsheet id, worksheet id, access token values , and from where? I am not getting any idea to do such."

[Murali]

Hi,

Please follow below steps to build the example.

Step1:- In this activity, there should be a "Google oAuth 2.0/Refresh Access Token" connector, this connector returns access_token in its result.

Hence, we need to define access_token parameter in the output variables section.

 

Step2:- In this activity, you have specified "add a row" connector. In its Provider,  need to define Authorization Scheme as Custom from drop-down list.

Then in schema name define as Bearer & in password define as ${access_token} & then save the provider(Google Sheet v3).

Note:- No need to specify access_token Parameter in second activity. It will be created automatically.

Please verify that Parameters tab in process instance, to check for the variable values at each step and share the complete process flow, if stuck with any.

Regards,
Murali
Fujitsu RunMyProcess Support

[em...@amolredij.com]

Hi,
I got your solution for step 2 I changed the schema and authorization scheme, but i am stuck with step 1 that you provided, like in which activity I should use Google Oauth, Refresh access token, i am sending you the screenshots.
as mentioned in the attachment, 1> get spreadsheet id, 2> get Worksheet id, 3> write data in spreadsheet.
I have used Google sheet v3 in all the steps as mentioned. as You explained me earlier to break into 3 separate activity. if you can send me the screenshots from your side after the solution.
Thanks and Regards

[Murali]

Hi,

Please implement the Google oAuth step automated as attached and refer to previous resolved post for similar requirement.

We can assist further for the application specific requirement with professional/paid services.

[Amol Redij]

Hi,

I followed your advise, I have already connected my application to developers console at Google but I got stuck at this point :

AS described in the screen shot. And I am still unable to login to the Spreadsheet.

Though I refreshed the token , and retrieved the token right now. still the same problem persist though I am using the licensed version.

Thanks and Regards

[Amol Redij]

Hi,

Today I tried again and again but after changing values for the parameters it displays error message at "Login Spreadsheet " As "Task "Login Spreadsheet" (id: 35[0] - status: ACTIVE): Unauthorized (401) - The request requires user authentication (1 attempt)".

Now do let me know, how to provide user authentication to it.

For convenience i am attaching screen shots.

I have my access token value, refresh token value and spreadsheet as well as worksheet id but still i am stuck with the same step.

On Fri, Nov 4, 2016 at 4:28 PM, Amol Redij <em...@amolredij.com> wrote:

Hi,

I followed your advise, I have already connected my application to developers console at Google but I got stuck at this point :

AS described in the screen shot. And I am still unable to login to the Spreadsheet.

Though I refreshed the token , and retrieved the token right now. still the same problem persist though I am using the licensed version.

Thanks and Regards

[Pankaj Kumar]

Hi Amol,

It seems the issue is with the implementation of the Google OAuth2 as you are getting error 401.

Please refer to below post, it gives you details of step by step implementation of Oauth2.

https://groups.google.com/a/runmyprocess.com/forum/?utm_medium=email&utm_source=footer#!searchin/supportforum/Google$20Oauth2|sort:relevance/supportforum/piuGZtEHWTY/d1CNP5N5AwAJ

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

On Mon, Nov 7, 2016 at 12:49 PM, Amol Redij <em...@amolredij.com> wrote:

Hi,

Today I tried again and again but after changing values for the parameters it displays error message at "Login Spreadsheet " As "Task "Login Spreadsheet" (id: 35[0] - status: ACTIVE): Unauthorized (401) - The request requires user authentication (1 attempt)".

Now do let me know, how to provide user authentication to it.

For convenience i am attaching screen shots.

I have my access token value, refresh token value and spreadsheet as well as worksheet id but still i am stuck with the same step.

On Fri, Nov 4, 2016 at 4:28 PM, Amol Redij <em...@amolredij.com> wrote:

Hi,

I followed your advise, I have already connected my application to developers console at Google but I got stuck at this point :

AS described in the screen shot. And I am still unable to login to the Spreadsheet.

Though I refreshed the token , and retrieved the token right now. still the same problem persist though I am using the licensed version.

Thanks and Regards

On Fri, Nov 4, 2016 at 1:22 PM, Murali <mkumma...@runmyprocess.com> wrote:

Hi,

Please implement the Google oAuth step automated as attached and refer to previous resolved post for similar requirement.

We can assist further for the application specific requirement with professional/paid services.

Regards,
Murali
Fujitsu RunMyProcess Support

--
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/CAPxRXearzd_A0Ur803H8Fi2qgCiqt%3Dx%3DT4rEjdr0d9aTawjeJg%40mail.gmail.com.

[Amol Redij]

Hi,

I tried a lot, but still I am getting the same error message. So I request you to help me in sorting it out. if there is alternate support mechanism , Do let me know and help me to find the perfect solution.

You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/hDb7ZswKPOc/unsubscribe.
To unsubscribe from this group and all its topics, 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/CADHrCayDcL82SyY2Hn2KOUyPvY4hqX1hTFjNGSVW0qhrUKmWGQ%40mail.gmail.com.

[Pankaj Kumar]

Hi Amol,

You can avail RunMyProcess Profession Hour Support and purchase support hours and use those hours to implement the functionality. Our RunMyProcess Team will implement the functionality for you. If you are interested kindly let us know.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAPxRXeZD4opaek%2Bgr81xZq8G4ukSa4si3t_ui8X%2B61B1gbwq1g%40mail.gmail.com.

[Amol Redij]

hi

what is Profession Hour Support and purchase support hours??

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCaxZuzudGTj%2B32%2BrZP4fmcdsBV2X%3D7d8xWxoYzqfejd8fg%40mail.gmail.com.

[Amol Redij]

Hi,

Can I get access to Platform support, because I applied for the same and my request has been approved for the login, but My login attempt is failed, i don't understand why? I need it urgently.

Do let me know the steps because Whatsoever try I have to made, i made to "Write data to google spreadsheet, but still I get the error as" Task "Login to Spreadsheet." (id: 34[0] - status: ACTIVE): Unauthorized (401) - The request requires user authentication (1 attempt)""

Thanks

[Murali]

Hi,

Professional support is a paid support contract hours purchased on your account for any of the support required to resolve your Application issues, wherein a dedicated RMP Consultant will take a deep look at your application code/functionality/issue and help for debug/suggest for the specific requirement.
If you require any additional clarification or interested to purchase the same we can connect you with sales team to assist on it.

Technical query is something about RMP basic functional feature related queries to guide for your application requirements at high level, which should be requested on our Developer Community.

Ref: http://docs.runmyprocess.com/Training/Support

Hope i was clear enough. Please revert for any additional info required.