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>By default, get_sheet will return a page with 100 rows. Include the flag: <code>includeAll=true</code> to return all rows.</p>

<p>See the <a href="http://smartsheet-platform.github.io/api-docs/?python#paging" rel="nofollow">documentation on paging</a> for more info.</p>

python smartsheet-api