Weird bug with API

Weird bug with API

Good afternoon,

I may have found a very strange bug.

On a blank sheet named "test", I create 3 columns with headers in the first row : "type", "color" and "check".
I input values for 2 rows : "car", "blue" for the first row, "car", "yellow" for the second row - so I intentionally leave blank the last column "check".

Then, from an external Zoho service (here, Subscriptions), I execute the following code :

options_map = Map();
criteria_map = "\"type\"=\"car\" and \"check\"!=\"OK\"";
update = Map();
update .put("check","OK");
response = zoho.sheet.updateRecords("xxx","test",criteria_map,update );

I get an empty response in return, and no modification is applied to the worksheet.
You might think that this is due to:
1) not specifying a connection
2) not escaping the double quotes, although https://www.zoho.com/deluge/help/sheet/update-records.html specifically indicates to do so

Well, not at all (and, for the record, correcting 1) and 2) does not solve anything: empty response and no change).
And this is where things start getting weird.

If I copy-paste 10 times my second row, so that I now have 12 rows, and then execute the code above, I get the following response: 

{"no_of_affected_rows":11,"method":"worksheet.records.update","status":"success"}

And, accordingly, the values get updated in the worksheet.

I have tested it back and forth extensively, and as surprising as it may read, it seems that zoho.sheet.updateRecords does not work if the number of records (i.e. rows) to update is lower than 10.

I find this extremely surprising, and I had to reproduce it several times to be certain I was not daydreaming.

    • Sticky Posts

    • Introducing Forms in Zoho Sheet

      We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you

    • What's new in Zoho Sheet: Simplify data entry and collaboration

      Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally

    • Slicers are now available in Zoho Sheet—filter your data interactively

      At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

    • Introducing Data Bars: Graphically represent changes in data within the cells

      Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

    • Feature enhancement: Highlight rows based on a cell value

      Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw