Skip to main content
  • EN

Hello everyone,

I am reading a google sheet with Google Sheets v4. The reader runs but it does not read some of the columns. I do not get any errors. how is that possible? I thought maybe because those columns cells are empty they can be read and then I added values in some cells but that was not the case. it still does not read them. in the workbench when I view the source data they are there in the sheet. 

 

That’s really odd. If you can view the source data in Workbench it means the connection to the sheet is good and FME understands the data.

Can you try “Rerun entire workspace” first (sometimes, if you make changes to a reader, caches can act a little bit weird) and if that doesn’t help, removing the reader and adding it again?

Thanks @redgeographics. I deleted it several times and added it again but still I get the same result. This is the first step and I just added the google sheet v4 reader to my workbench. 

Reply


Community Stats

30,149
Posts
114,445
Replies
37,795
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.