Creating a new Spreadsheet Error

[J.M.]

Hi,


I'm trying to build a simple process, that is able to create a new spreadsheet. I'm using the following connectors:
1.- Google API Login > Login Documents
2.- Google Documents > Create an empty spreadsheet [v3.0]

The first one, is working fine, but the second one throws me this error:

2015-03-05T10:00:13+0000 - Task "Create new spreadsheet" (id: 2[0] - status: ABORTED): Unauthorized (401) - Token invalid (1 attempt)
-------
2015-03-05T10:00:13+0000 - Task "Create new spreadsheet" (id: 2[0] - status: ABORTED): Error while processing <spreadsheet_id>{entry.id?substring(entry.id?index_of('%3A')+3)}</spreadsheet_id>
Expression entry is undefined on line 1, column 19 in temp.

The documentation of this connector says it's only necessary one input parameter () and one output parameter (), but this sounds weird to me, so I've tried too, adding another input parameter: the auth which is output from the "Login Documents", but it didn't work neither.

I should say too, that my credentials, login and password(better said app-password), are correct (the login activitty is working fine), so...

How can I create a new spreadsheet? Where is my error?

Thanks and regards.

[Shobhit Tripathi]

Hi,

Sometimes this problem occurs while you are giving the same name during the creation of another worksheet in a specific Spreadsheet. That is Google wont allow you to create another worksheet with the same name.

Could you please try with different worksheet name and let us know.

Hope this will help you.

Thanks & Regards,

Shobhit

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/8d3a645f-f2bd-4712-94d4-2e4d7cc0a1c2%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[javiermm...@gmail.com]

Hi,

I guess whe you say "worksheet name" you want to say "spreadsheet_name", because I don't have any parameter called "worksheet name".

If this is the case, I've tried to change it, and firstly I've got no error message but It didn't work (Orange dot in "Create new spreadsheet" without error message). Then I tried again, and I got the same result I explained on my previous post.
Anyway, I only have another spreadsheet document on my drive, and its name is completely deifferent.

Any other idea?
I need some more help, please.

Regards.

[Bidisha Das]

Hi,

I guess you are using wrong output parameter in "Create an empty spreadsheet [v3.0]" activity.You need to pass the Auth token and spreadsheet name in input variables and the output variable should be ${P_result.spreadsheet_id} which will give you the id of the empty spreadsheet you created.

Please let me know if still facing issue.

Thanks & Regards

Bidisha

[J.M.]

Hi Bidisha,

You're right, my output variable were incorrect. However, after aplying the change you suggest, the result I get is the same (...Token invalid...)

So, I'm still having this error.

Regards,

[Bidisha Das]

Hi,

In the output parameter of Login Documents pass Auth: ${P_result.Auth}. In the input parameters of "Create an empty spreadsheet [v3.0]" , pass Auth: ${Auth} and spreadsheet_name: any name you want to and  in the output variables, pass spreadsheet id :${P_result.spreadsheet_id} and check if you still face the same error.

Thanks & Regards

Bidisha

[J.M.]

Hi,

Yes. If I'm not losing any detail, that's what I have, but my error persists.

I attach screenshots for more info.

Regards.

[Bidisha Das]

Hi,

Go to Result Transformation of the Connector  "Create an empty spreadsheet [v3.0]" and put <spreadsheet_id>${entry.id?substring(entry.id?index_of('%3A')+3)}</spreadsheet_id> . You have missed $ in it.

Thanks & Regards

Bidisha

[Javier Martín]

Hi Bidisha,

Thanks for the reply, however something's happening, and I don't understand it.

the line:

<spreadsheet_id>${entry.id?substring(entry.id?index_of('%3A')+3)}</spreadsheet_id>

is already in the Result Transformation field of the connector "Create an empty spreadsheet [v3.0]", but the error showed in the error area on the report tab, eliminate the first $. It's not missed, It's omitted.

Anyway, I have re-copied the line, just in case, but the error persists.

I attach the screenshot with the evidence.

What should I do?

Regards.

--
Fujitsu - RunMyProcess
---
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/dri2sNCuQTs/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/CAMGV9zvueVgwbj%2BDJEmYVEm1qZRXTkr%2Bpc4FScsWF_XjcYQGkA%40mail.gmail.com.