Microsoft TFS2018 data via APIs

Six Stars

Microsoft TFS2018 data via APIs

Morning Talend Community!  I'm working on a new project wherein I'm trying to use Talend Big Data Platform v7.1 to call several Microsoft Team Foundation Server2018 APIs.  Ultimately, the JSON responses will be stored in Redshift tables for analytics down the road.  I've been successfully calling (GET) several of the APIs but can't figure out how to pull ALL of the 'work items' on a 'board' in TFS at once.  I can use the 'workitems' API, but you have to know which ID(s) you want to pull information about.


Has anyone designed a job yet that can pull all work items at once?  Or perhaps a job that can get a list of work item IDs that exist and then a sub-job that can loop through each of them one by one?


Any insight is greatly appreciated!


UPDATE:  I was able to use the Query API delivered with TFS and I think I'm on to something!  I navigated to a board in TFS and created a query under "My Queries".  I included no filters whatsoever...the result was every workitem on the board.  I then used the following Query API syntax successfully.  My thought is that if I modify the TFS query to return only the WorkItem ID column, I can then use that to loop through the "workitem revisions" API since it requires one ID at a time.  This would then return all of the information for each workitem ID.  More soon....



I was able to get the queryid value from the URL in TFS





Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences


Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now