Post

1 follower Follow
2
Avatar

Import to MySQL, how to?

I want to update items in an app with information from another database and from other apps. I've got a (example) workspace with Customers, Projects and Issues and I want a filter on all issues from a certain Customer. And if I mail to the Issue-app, I want to fetch the Project number from the e-mail subject: '[1234] This is an issue from project 1234'.

I would like to import all the items from a workspace to a MySQL-database, so I can find the Customer from each Issue.

My issue list has about 15.000 records, so importing takes a lot of time (and memory on my server). What's the best way to import all items to MySQL? Is there a way to only grab the new or recently changed items from an app?

Stephan Vierkant Answered

Please sign in to leave a comment.

2 comments

0
Avatar

I'd recommend you do a one-time export where you get 500 items at a time - that's only 30 calls in total, so that will keep you well under the rate limits. Once you've done that, you can set up webhooks listening to item.create and item.update, and create/update your MySQL data accordingly.

Casper Fabricius 0 votes
Comment actions Permalink
0
Avatar

Sorry, didn't thought of webhooks! That's exactly what I want.

Stephan Vierkant 0 votes
Comment actions Permalink