appsmith fix: datasource switching issue for Google sheets

When Google sheets datasource is switched, The dynamic trigger values are not refetched i.e. The google sheets does not refetch spreadsheet urls, sheet names or columns.

While this might look like a google sheets specific issue, The solution here can be extended to every future plugins that need to fetch dynamic values when datasource context is switched.

Fixes #17498

Type of change

Please delete options that are not relevant.

Bug fix (non-breaking change which fixes an issue)
Manual

Issues raised during DP testing

Link issues raised during DP testing for better visiblity and tracking (copy link from comments dropped on this PR)

Checklist:

Dev activity

[x] My code follows the style guidelines of this project
[x] I have performed a self-review of my own code
[x] I have commented my code, particularly in hard-to-understand areas
[ ] I have made corresponding changes to the documentation
[ ] My changes generate no new warnings
[ ] I have added tests that prove my fix is effective or that my feature works
[ ] New and existing unit tests pass locally with my changes
[ ] PR is being merged under a feature flag

QA activity:

[ ] Test plan has been approved by relevant developers
[ ] Test plan has been peer reviewed by QA
[ ] Cypress test cases have been added and approved by either SDET or manual QA
[ ] Organized project review call with relevant stakeholders after Round 1/2 of QA
[ ] Added Test Plan Approved label after reveiwing all Cypress test

Nov 23 '22 15:11 Irongade

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Updated
appsmith	✅ Ready (Inspect)	Visit Preview	Dec 2, 2022 at 0:14AM (UTC)