Iterate through all rows Smartsheet API Python
<p>I am trying to iterate through all the rows in a sheet, but it seems that simply using .rows is limited to returning 100 items.</p>

<pre><code>for temp_row in inventory.rows:
    x += 1
print x #X will always return &lt;= 100
</code></pre>

<p>No matter how many items I have in there.</p>

<p>What am I doing wrong?</p>

<p>Edit: Just to clarify, I am trying to do something to every row, not count them, that is just an example of how i noticed it is only grabbing 100 rows.</p>

<p>Sounds like perhaps the SDK is utilizing <em>paging</em> when executing the <strong>Get Sheet</strong> operation -- i.e., it's only returning the first page of results in the response, which defaults to 100 rows. As described in the <a href="http://smartsheet-platform.github.io/api-docs/?python#get-sheet" rel="nofollow">API docs</a>, page size defaults to 100 rows in the <strong>Get Sheet</strong> response, unless specified otherwise by the request. (In the docs, see the description for the <strong>pageSize</strong> and <strong>page</strong> parameters.)  </p>

<p>I'd suggest that you review the SDK for the ability to specify <strong>pageSize</strong> and/or <strong>page</strong> when calling the <strong>Get Sheet</strong> operation.</p>

python smartsheet-api