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>It is important to note that when making the request to the Smartsheet API directly rather than via the Python SDK the default response is to include all rows of the sheet without needing to include <code>page</code> or <code>pageSize</code> parameters.</p>

python smartsheet-api