Post

4 followers Follow
0
Avatar

Export all items with item_id

Good day,

Is it possible to export all items from an application (for example through: https://developers.podio.com/doc/items/export-items-4235696 ) and getting the item-id's? An excel export now just exports the fields and values, however I would like to have the ID per item too, so I can use it as an backup. (The id's I need to connect them to another web-service).

I can manually fetch all items but that would take allot more of requests to your servers when there are many of them. So I was hoping it is possible to 'export' an application with the item-id's.

Kind regards,

Matthijn Dijkstra

pluscloud Answered

Please sign in to leave a comment.

6 comments

0
Avatar

The Excel export does not include item ids, as you say.

The best way to "export" an application would be to use the Filter items call, setting the limit to 500, which is the highest permitted per call. That will allow you to export up to 125.000 items per hour before you run into the rate limit, so that should be enough for most apps.

Casper Fabricius 0 votes
Comment actions Permalink
0
Avatar

Thanks for the reply, than that is the way I will do it :-) Currently there are 5000 items in the 'biggest application' so 125.000 should be sufficient for some time to come :-)

pluscloud 0 votes
Comment actions Permalink
0
Avatar

Hey Casper,

nice to meet you in Copechague :), I'm Bruno from Brazil!

I have a problem with the limit of export items, my app already has 151.000 items and I need export all of them.

What did you recomend for me?

Best Regards,

Bruno Lima

Bruno Soares Lima 0 votes
Comment actions Permalink
0
Avatar

Hi Bruno,

Use the Filter Items calls Casper linked to, but throttle your requests so you don't hit the rate limit. Your export job will just run a little longer than an hour.

/Andreas

Andreas Haugstrup Pedersen 0 votes
Comment actions Permalink
0
Avatar

Hi Andreas, thank you for your reply! So, there's no way to export all items in background, right?

Bruno Soares Lima 0 votes
Comment actions Permalink
0
Avatar

SO... the Podio development team could easily make a function to backup all apps or workspaces into excel files in a ZIP that is emailed to the admin of an organization, or individual user?

One of the main weaknesses I've seen in Podio is that my data is in an obscure form on your servers, and if someone broke in to an account with privileges, they could wreak havoc and it would be difficult for me to do anything about it without daily/weekly backups.

Hope this is a soon-to-come feature, I think the community needs it!

 

Pete

Pete Likins 0 votes
Comment actions Permalink