https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11387#M6373 <P>in that case you can use <A href="https://docs.microsoft.com/en-us/azure/devops/boards/queries/using-queries?view=azure-devops&amp;tabs=browser" alt="https://docs.microsoft.com/en-us/azure/devops/boards/queries/using-queries?view=azure-devops&amp;tabs=browser" target="_blank">Queries</A> and Azure DevOps API :</P><UL><LI> <A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-7.1#authenticate" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-7.1#authenticate" target="_blank">Authentication</A></LI><LI><A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/work/boards/list?view=azure-devops-rest-6.0" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/work/boards/list?view=azure-devops-rest-6.0" target="_blank">Boards - List</A></LI><LI><A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/queries/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/queries/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" target="_blank">Queries - Get</A></LI><LI><A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" target="_blank">Wiql - Get</A></LI></UL><P></P><P></P> Wed, 03 Aug 2022 15:54:06 GMT artsheiko 2022-08-03T15:54:06Z https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11384#M6370 <P>Looking for best practises/examples on how to pull data (epics, features, PBIs) from Azure Boards into databricks for analysis.</P><P></P><P>Any ideas/help appreciated!</P> Wed, 03 Aug 2022 15:20:38 GMT https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11384#M6370 Jeade 2022-08-03T15:20:38Z https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11385#M6371 <P>you can use export to csv (<A href="https://docs.microsoft.com/en-us/azure/devops/boards/work-items/email-work-items?view=azure-devops&amp;tabs=browser#export-list-as-csv" alt="https://docs.microsoft.com/en-us/azure/devops/boards/work-items/email-work-items?view=azure-devops&amp;tabs=browser#export-list-as-csv" target="_blank">link</A>), push the file to the storage mounted to Databricks or just import the file obtained to dbfs</P> Wed, 03 Aug 2022 15:38:36 GMT https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11385#M6371 artsheiko 2022-08-03T15:38:36Z https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11386#M6372 <P>yup, .csv export/import is OK for a one-time load, but I was looking for a more automated method - that could be scheduled to sync daily.</P> Wed, 03 Aug 2022 15:42:50 GMT https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11386#M6372 Jeade 2022-08-03T15:42:50Z https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11387#M6373 <P>in that case you can use <A href="https://docs.microsoft.com/en-us/azure/devops/boards/queries/using-queries?view=azure-devops&amp;tabs=browser" alt="https://docs.microsoft.com/en-us/azure/devops/boards/queries/using-queries?view=azure-devops&amp;tabs=browser" target="_blank">Queries</A> and Azure DevOps API :</P><UL><LI> <A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-7.1#authenticate" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/?view=azure-devops-rest-7.1#authenticate" target="_blank">Authentication</A></LI><LI><A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/work/boards/list?view=azure-devops-rest-6.0" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/work/boards/list?view=azure-devops-rest-6.0" target="_blank">Boards - List</A></LI><LI><A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/queries/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/queries/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" target="_blank">Queries - Get</A></LI><LI><A href="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" alt="https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/get?view=azure-devops-rest-6.0&amp;tabs=HTTP" target="_blank">Wiql - Get</A></LI></UL><P></P><P></P> Wed, 03 Aug 2022 15:54:06 GMT https://community.databricks.com/t5/data-engineering/pulling-data-from-azure-boards-into-databricks/m-p/11387#M6373 artsheiko 2022-08-03T15:54:06Z