jroehl/gsheet.action

cannot use the getData function

Closed this issue · 4 comments

pythonpete32 commented

Firstly, this is an awesome action. and this is not a bug, however, the documentation is a bit opaque with regards to

name address id
Alace 0x1234 1
Bob 0x2345 2

I want to get the Alice and bob row, ive tried

    { "command": "addWorksheet", "args": { "worksheetTitle": "test sheet" }},
    { "command": "getData", "args": { "minRow": 1 }, { "minCol": 1 }, {"maxRow": 2}, {"maxCol": 2}},

    { "command": "addWorksheet", "args": { "worksheetTitle": "test sheet" }},
    { "command": "getData", "args": { "minRow": 1 }, { "minCol": 1 }},

    { "command": "addWorksheet", "args": { "worksheetTitle": "test sheet" }},
    { "command": "getData", "args": { "minRow": 1 }, { "minCol": 1 }, {"range": "a2:c3"}},

    { "command": "addWorksheet", "args": { "worksheetTitle": "test sheet" }},
    { "command": "getData", "args": {"range": "a2:c3"}},

every time i get the same error ##[error]error:0909006C:PEM routines:get_name:no start line

jroehl commented

Hi @pythonpete32, I am glad you like it 🙂

Could it be that you're trying to load the credentials from a file? This sounds to me like a formatting issue of the private key.

About the documentation - I am always open to suggestions - open a PR if you like!

  • ❤️1
pythonpete32 commented

I am passing the credentials in as a GitHub secret, Thanks for pointing me in the direction to look.
given this table what would the syntax be if I want to return Alice and Bobs records?

name address id
Alace 0x1234 1
Bob 0x2345 2

and for sure, I'll open a or when I get it working :)

jroehl commented

You should be able to use either

{ "command": "addWorksheet", "args": { "worksheetTitle": "test sheet" }},
{ "command": "getData", "args": { "range": "'test sheet'!A2:B3" } }

or

{ "command": "addWorksheet", "args": { "worksheetTitle": "test sheet" }},
{ "command": "getData", "args": { "worksheetTitle": "test sheet", "minCol": 1, "minRow": 2, "maxCol": 3, "maxRow": 3} }

You have to specify the worksheetTitle to access the data of a specific worksheet.

I hope this helps.

  • 👍1
mohamed-Dhia commented

hi I'm facing the same error ##[error]error:0909006C:PEM routines:get_name:no start line
can anyone provide a small clarification
thanks in advance❤