API - Keyblocker

Question

Hello,&nbsp;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.&nbsp;&nbsp;This is the message I am recieving when trying to my script.&nbsp;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.InvokeRestMethodCommandHas anyone seen this, and is there a workaround?

anonymous · Answer

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

jayendran · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Are you invoking this behind any corporate firewall ?&nbsp;Also make sure that you have run this using TLS 1.2 in your script&nbsp;[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

anonymous · Answer

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

anonymous · Answer

Hi&nbsp;Anonymous!&nbsp;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.&nbsp;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?&nbsp;

seanv · Answer

HIIm 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.&nbsp;section of the code that im bateling withwhile ($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();&nbsp;&nbsp;&nbsp;Thank you

Forum Discussion

API - Keyblocker

6 Replies

Related content

Refresh dataset api

Rest API Informations

Fabric Create report API

Power BI REST API's

Fabric Rest Api