topic Re: API - Keyblocker in Developer

API - Keyblocker

Anonymous — Mon, 30 Sep 2019 12:55:20 GMT

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 the message I am recieving when trying to my script.

Invoke-RestMethod : {"error":{"message":"The request was blocked by KeyBlocker "}}
At line:9 char:1
+ Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
    + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

Has anyone seen this, and is there a workaround?

Re: API - Keyblocker

Jayendran — Tue, 01 Oct 2019 07:17:35 GMT

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

Re: API - Keyblocker

Anonymous — Wed, 09 Oct 2019 08:42:15 GMT

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

Re: API - Keyblocker

Anonymous — Tue, 03 Mar 2020 17:02:04 GMT

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

Re: API - Keyblocker

Anonymous — Wed, 04 Mar 2020 07:35:14 GMT

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?

Re: API - Keyblocker

Seanv — Tue, 19 Jan 2021 12:22:40 GMT

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

Re: API - Keyblocker

villasenorbritt — Fri, 04 Nov 2022 16:13:45 GMT

Do you happen to still have this code and is so, would you be willing to share? I am running into this same issue and am having trouble fixing it.