Worksheet ID is causing an error when data is fetched on a schedule

  • Resolved edgepro

    (@edgepro)


    1 year, 5 months ago

    We have a scheduled Google Sheet on a project that keeps improperly fetching the Google Sheet. After we save the project, the Worksheet ID changes to -1 (which is invalid). If we leave that blank or set it to 0, it will work fine for a “Now” fetch but when this is set to “Hourly” it reverts the Worksheet ID to -1, right after clicking the Save button on the project. Our project worked fine until the most recent update. Please help!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter edgepro

    (@edgepro)

    Also, is it possible to download the previous version so that we can implement a temporary fix? What is the link for that?

    Plugin Support Stefan Cotitosu

    (@stefancotitosu)

    Hi @edgepro,

    Thank you for using MPG. It’s unfortunate to hear about this issue, as the latest releases didn’t imply changes in the sheet ID or project updating schedule.

    As a temporary solution, yes, you can roll the plugin back to a previous version by following these steps. In case the issue doesn’t occur with an older version, please let us know which one is working correctly so we can compare the changes.

    Regarding the description of the issue, is the problem that the worksheet ID field is reverted to 0 only if the periodicity parameter is set to Hourly? I’m not able to replicate it; however, I can register an enhancement for the Worksheet ID not to allow values lower than 0.

    Regards,
    Stefan

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Worksheet ID is causing an error when data is fetched on a schedule’ is closed to new replies.