API referring to old Column Names after changing them and giving error when loading data

o2d · August 12, 2022, 9:23am

Hi All,

I renamed a column in an existing data source (google sheets) and the API correctly picks up the name of the column, but when I try to run it, it shows it can not locate the old Column and ends up in an error.

Old Name : Machine List
New Name : MachineList

Edit : Things got a lot weirder, When I try to create a completely different API to get data from a different sheet, I’m getting the same “Machine List” not found error - it was never there to begin with. I dont know whats going on anymore.

The Table
Web capture_13-8-2022_04432_docs.google.com

The Error

Need a fix for this?

subratadeypappu · August 15, 2022, 10:07am

Hi @o2d
Thank you very much for reporting this issue. This seems to be a bug. Please refer to the following GitHub issue for the ease of your tracking.

github.com/appsmithorg/appsmith

[Bug]: Old column names continue to exist even after renaming the column in Google Sheet

opened 10:02AM - 15 Aug 22 UTC

subrata71

Bug High Google Sheets BE Coders Pod

### Is there an existing issue for this? - [X] I have searched the existing iss…ues ### Description ### Description ![GS-Bug-Image1](https://user-images.githubusercontent.com/3524599/184616043-ec5d5963-40bf-4498-882e-72981d80806e.jpeg) I renamed a column in an existing data source (google sheets) and the API correctly picks up the name of the column, but when I try to run it, it shows it can not locate the old Column and ends up in an error. Old Name : Machine List New Name : MachineList Edit: Things got a lot weirder, When I try to create a completely different API to get data from a different sheet, I’m getting the same “Machine List” not found error - it was never there, to begin with. I don't know what's going on anymore. ![GS-Bug-Image2](https://user-images.githubusercontent.com/3524599/184616119-6dd73b1a-c73b-4dab-908c-68f28990417f.jpeg) ### Source This issue has been reported first in the community.appsmith.com forum. https://community.appsmith.com/t/api-referring-to-old-column-names-after-changing-them-and-giving-error-when-loading-data/1295 ### Steps To Reproduce 1. Create a Google Sheet (GS) datasource 2. Save and authorize GS datasource 3. Create an API on this GS datasource with operation `Fetch Many` 4. Select one or more columns from the `Columns` drop-down list 5. Now go to your Google Sheet and rename one column 6. Go back to the API that you created in step 3 7. You will see the new column names appearing under the `Columns` drop-down list 8. Now select one or more columns from the `Columns` drop-down list 9. You will see an error like Filtering failure seen: Column "<Old column name>" not found ### Public Sample App _No response_ ### Version Cloud / Self Hosted

We will soon post updates on this. In case it takes a good amount of time to fix this we will try to share a workaround solution to this problem.

We apologize for the trouble.

subratadeypappu · August 15, 2022, 10:34am

Hi @o2d
Please refer to this comment where I demonstrated the current workaround to this problem.

o2d · August 15, 2022, 12:51pm

Hi @subratadeypappu,

Thanks for the reply and I’ll follow the status of this on github and look into the workaround for this.

I have to run the table with the old column name as a place holder column for the query to work.

subratadeypappu · August 16, 2022, 5:06pm

Hi @o2d
You will be glad to hear that the team has already started working on this issue with utmost priority. Soon this fix will be deployed in production. Meanwhile please go with the workaround solution shared earlier. Thanks again for reporting the issue.