My team has a large Google Doc Spreadsheet (thousands of rows).
Before appending a new row to the bottom, I want to search if an existing
row
already contains a certain string in the first column.
We are currently using Java API com.google.api.services.sheets.v4
APIs from our server to communicate with Google Docs Spreadsheet Service
I am able to append using Values.append
and update using Values.update
I am having trouble getting Values.batchGetByDataFilter
to work, as I am not sure how to create the DataFilter.
dataFilter.set("data", searchText) does not work and I am not sure
what field name to use instead of "data"
I also saw that there is
a com.google.api.services.sheets.v4.model.FindReplaceRequest
but I am not clear on how to use that API in combination with a
com.google.api.services.sheets.v4.Sheets object
The documentation is not very clear for this use case.
I've seen some people on StackOverflow or older messages here claiming
that V4 API does not support search / query. Is this still true ?
Should we use V3 Java API instead ?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
