Podio API Documentation
Items: Get items as Xlsx
Returns the items in the Xlsx format.
- PHP Client
-
PodioItem.php
PodioItem::xlsx( $app_id, $attributes = array() ); - Ruby Gem
-
item.rb
Podio::Item.xlsx( app_id, options = {} )
- 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_on, date, 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_by, last_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
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