Podio API Documentation

Items: Get items as Xlsx

GET /item/app/{app_id}/xlsx/

Returns the items in the Xlsx format.

Usage
PHP Client
PodioItem.php
PodioItem::xlsx( $app_id, $attributes = array() );
Ruby Gem
item.rb
Podio::Item.xlsx( app_id, options = {} )
Parameters
app_id*
Required.
{key}

The key with corresponding value to use for filtering the results. For the valid keys and values see the filter area. 

For list filtering (state, app, member), the value is given as a semi-colon-separated list, f.ex. "1;2" or "active;deleted". To include items with a field not set to any value use "null" in the lists, f.ex. "1;null" or "null;active".

For range filtering (created_on, last_edit_ondate, progress, number) the value is given as "x-y", f.ex. "20-100" or "2010-12-01-2011-01-01". Date filtering also supports relative filtering, see the filter area for details.

For auth filtering (created_bylast_edit_by) the value should be given as a semi-colon-separated list on the form "type:id", f.ex. "user:1".

To f.ex. get all items with a state field either not set or set to "active" would look like /item/app/123/?876=null;active, with 123 being the id of the app and 876 the id of the state field.

deleted_columns

Default value: false
limit

The number of items to return, maximum is 1000


Default value: 20
offset

The offset from the start of the items returned

remember

If true the given view is remembered for the user, otherwise it is not.


Default value: true
sort_by

How the items should be sorted. For the possible options, see the filter area.

sort_desc

Use true to sort descending, use false to sort ascending


Default value: true
view_id

Applies the given view, if set to 0, the last used view will be used

Response

The resulting Xlsx file

Sandbox

Try the operation "/item/app/{app_id}/xlsx/"

You can simulate the API request by filling out the arguments below, and press the submit button to see the response.

You need to be logged in to Podio to use the Sandbox. Login here