55sketch / gsx2json Goto Github PK

If a bad id is provided to the server, the whole thing collapses.

For example: Go to this URL: http://gsx2json.com/api?id=blah. Then, notice that you get an Application Error at this URL: http://gsx2json.com/

Even the one mentioned on site.

Can we enter a condition according to the 'sheetName' parameter, such as the 'sheet' parameter?

Like as:
http://gsx2json.com/api?id=**********&columns=false&sheetName=config

Is there a way to find the # of sheets in a document so I can possibly iterate over it to ingest all the sheets as json instead of using a loop and switching out the sheet_number?

Hi Nick, Joao,

Can API by GSX2JSON still work? it seems like an error. Kindly check and review. Thanks.

"An error occurred in the application and your page could not be served. If you are the application owner, check your logs for details. You can do this from the Heroku CLI with the command"

Best Regards,
Mustain

Hello, I'm using your hosted version and we're getting an invalid hostname error since 2023-06-22 (around midday GMT) when we try and use the json file as a feed in Klaviyo (our email email marketing service, we use the the tool to populate sheet content into an email template).

The json feed still opens in the browser.

When I try the URL in an alternative service (https://codebeautify.org/jsonvalidator), this also returns an error with some more details:

Parse error on line 1:
The URL you entered 
^
Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '[', got 'undefined'

These are the URLs I'm testing, one is our own and one is the example from your site. They both return the same error.

https://gsx2json.com/api?id=1EKVHceINR0lxLuSxEyQ8Ws0J043qnjRo1TSojJ7ExpM&sheet=Section1&api_key=AIzaSyBxIOxT-oakGgVBJ3eShluroMRIv3GnCKw
https://gsx2json.com/api?id=1I3tEfgYtWKNYK9vqTmsCGfZfbHckS0-odDIgEilHiOQ&sheet=Sheet1

So will this project die? It seems that v4 API requires a valid API key...

Reference

1. https://developers.google.com/sheets/api/v3#which_version_of_the_api_should_be_used
2. https://developers.google.com/sheets/api/guides/migration?hl=en#retrieve_cell_data

I was using gsx2json for production, hosted in an Heroku app, and the app is not longer getting the sheet entries. I've read that API changed so I updated the files.

1. I've read here that Google API changed, so I made a new project clone and added the API key.
2. My ID is fine, I've test the gsx2json server to compare, and it works fine there but not in my Heroku own serve.

Always getting the same message: "No entries returned. Do you have the right ID?" Same ID works fine at gsx2json server. Please, can you give me some light to fix this issue?

How many rows can it handle? I have a doc with 100k but can't test it with http://gsx2json.com/api cause I'm getting «Application error» message from Heroku.

i used gsx2json. it is very good so thank you for devoloping.

but it can't work.. :(...

Can you check: http://gsx2json.com/api?id=1ooDU8C_EWQ-wkx7PTWyknLd87o3vqTS9T78WEtFPmqg

Hi!

Would be nice if you guys could configure a SSL certificate, can't request resources due to mixed content.

Is there a guide to use this on self hosting?