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? 

      • Seanv's avatar
        Seanv
        New Member
        5 years ago

        HI
        Im new to powershell and I keep on getting the key Blocker message.
        Please could you assist in sending your sample code please.

        Data is extracted from SQL server. Ho do you add all the records and pass the result once.

         

        section of the code that im bateling with


        while ($dataset.Read()) {
        $payload = @{
        "PLR_Description" =$dataset['PLR_Description']
        "Snap" =$dataset['Snap']
        "LastCreated" =$dataset['LastCreated']
        "Total" =$dataset['Total']
        "Success" =$dataset['Success']
        "Failure" =$dataset['Failure']
        "e Disconnect" =$dataset['e Disconnect']
        "e CRC Failed" =$dataset['e CRC Failed']
        "e Resent count exceeded" =$dataset['e Resent count exceeded']
        "e Invalid Tag" =$dataset['e Invalid Tag']
        "e PLR: no space for message" =$dataset['e PLR: no space for message']
        "e PLR: old pocsag timestamp" =$dataset['e PLR: old pocsag timestamp']
        "e PLR: RTC Invalid" =$dataset['e PLR: RTC Invalid']
        "e GW: ReceivedByteCount" =$dataset['e GW: ReceivedByteCount']
        "Type" =$dataset['Type']
        "Diff" =$dataset['Diff']
        }

        Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
        }
        $connection.Close();
        $connection.Dispose();

         

         

         

        Thank you