Report API errors in SSIS

Officially Answered

Follow

New post

Jose Guaring

• May 02, 2017 18:10

Hi, were trying to access the Report API within SSIS and were getting a 406 not acceptable.

then we tried accessing it thru SOAP UI and got 401- Unauthorized. We used Basic and NTLM authentication but did not work.

 

Has anyone tried using the API in SSIS as ODataSource?

 

 

 

 

 

 

0

• Official comment

  

  Marc Schaeffler

  • March 19, 2018 17:03

  This thread is descibing the same issue from another perspective. We close this, please continue to reply on the linked thread here: https://support.7pace.com/hc/en-us/community/posts/115009021126-Can-t-use-service-API-from-PowerApps-MS-Flow-?page=1#community_comment_360000293783

  Marc 

  Comment actions Permalink
• 

  Permanently deleted user

  • May 02, 2017 21:18

  Hi Jose,

  We are investigating your issue now and we will contact you directly as it can require some details from you. 

  Maxim

  0

  Comment actions Permalink
• 

  Permanently deleted user

  • June 21, 2017 16:07

  Hi Jose,

  We identified issues with API compatibility with SSIS when you connect to Timetracker for VSTS. We plan to fix this issues in one of the upcoming sprints, we apologize for inconveniences. 

  I can suggest you to use our sample application to grab data from API and save it into the e.g. JSON file (or CSV) and use this file as source in your SSIS package. I hope this workaround will help you.

  Sample code you can find here: https://github.com/7pace/timetracker-api-samplecode 

  Maxim

   

  0

  Comment actions Permalink

Please sign in to leave a comment.