Reporting API in Azure Data Factory

Officially Answered

Follow

New post

Tomasz Pajdoos

• December 31, 2019 12:18
• Edited

Hello.

I am trying to extract data by using Azure Data Factry (reporting API) but i can't reach to TimeExport function in ODATA source. The last object I see is TimeExportEntry, when I tried to override it to 'TimeExport(StartDate='2019-11-01',EndDate='2019-12-31',PopulateTopParentColumns=null,GroupTimeByDateByUser=null,IncludeBillable=null)'. Is there any way to extract the data by using ADF?

Best regards,
Tomasz

0

• 

  Maxim Shestakov

  • January 24, 2020 09:27

  Hi Tomasz!

  Sorry for delayed reply, we've checked OData with Azure Data Factory and found out that Azure Data Factory could not work with OData functions, so it is not possible to use API2.1 there, but you could use APIv3.0 - it works correctly in Azure Data Factory.

  

  Please let me know if this can help you.

  Regards,
  Maxim

  0

  Comment actions Permalink

Please sign in to leave a comment.