Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

API - Keyblocker

Hello,   I am trying to run a powershell script to call the API for our ticket system, and then post hit to PowerBI with a foreach loop for every ticket, total is about 17k tickets.    This is th...
Need Help
Jayendran's avatar
Jayendran
Solution Sage
6 years ago

Hi Anonymous ,

 

Are you invoking this behind any corporate firewall ?

 

Also make sure that you have run this using TLS 1.2 in your script

 

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sorry for the late reply, I solved this by putting every ticket into one foreach loop. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Can you please share with us a little bit more details on the workaround you've used?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous!

         

        Ofcourse, what I do have today is a powershell script that runs a api call to our ticket system, collecting all tickets into a PowerShell variable, from here I wanted to post one and one ticket to a PowerBI dataset trough the API - thats where I got rate limited by Microsoft and got the Keyblocker error message.

         

        What I did from here was to instead of posting each ticket with a api call I added a append to variable inside the foreach loop, and then posted everything inside this variable to the PowerBI dataset. This can only contain 10 000 objects, so I had to split it into two api calls. Does this help a bit?