Prisma Insights API in PowerShell

[StephenBuist]

Hi all - I am looking for some help. I have been asked if I can extract data using the Prisma Insights API, I have used PowerShell for this in the past for a similar thing in AppDynamics so I think it would be a good starting point for this work.

I have managed to get the access token and use this in the next part of the code to make the API call but I am getting the following error:

Invoke-RestMethod : {"errorCode":"REST10001","message":"Unexpected server error","details":"Failed to process request"}

Has anyone used PowerShell with the API or come across this error ?

Any advise appreciated.

[MDavis29]

StephenBuist, I need a little more context in regards to what you mean by Prisma Insights API.  Please use the below links to start or send me a link to the product you are referring to.

Prisma Access Insights APIs 

Access an API with powershell 

[StephenBuist · Accepted solution]

Hi - I managed to get past the error message. The issue was that PS was not accepting the JSON payload in directly in the code. I put it in a text file and read it in to the script - this solved the issue. 

Thanks for responding though.

[kpopov]

Hi Stephen,

I am trying to achieve somewhat the same, but using curl. Can you please give an example of the command line, which you used to get the data? I am stuck at the same issue, as you were. Here is my curl command, that I am using. I have put the payload in a .josn file and load it in the command:

curl -X POST https://pa-staging02.api.prismaaccess.com/api/sase/v2.0/resource/query/tunnel_status -H "Authorization: Bearer eyJ0eXAiOiJKV1QiLCJraWQiOiJyc2Etc2lnbi1wa2NzMS0yMDQ4LXNoYTI1Ni8xIiwiYWxnIjoiUlMyNTYifQ.eyJzdWIiOiJmMGU1NjQzMi1iODkxLTRiOTItYWZmNS0xOWI5YTc3YmY0NGQiLCJjdHMiOiJPQVVUSDJfU1RBVEVMRVNTX0dSQU5UIiwiYXVkaXRUcmFja2luZ0lkIjoiOWJkMGQ1ODgtNDU4OC00ZTI0LWIxNDktNDA1YjAxNTY4YzY0LTEyNjc4OTE5Iiwic3VibmFtZSI6ImYwZTU2NDMyLWI4OTEtNGI5Mi1hZmY1LTE5YjlhNzdiZjQ0ZCIsImlzcyI6Imh0dHBzOi8vYXV0aC5hcHBzLnBhbG9hbHRvbmV0d29ya3MuY29tOjQ0My9hbS9vYXV0aDIiLCJ0b2tlbk5hbWUiOiJhY2Nlc3NfdG9rZW4iLCJ0b2tlbl90eXBlIjoiQmVhcmVyIiwiYXV0aEdyYW50SWQiOiJFQU5TRkZaSFQzOC1TcW5qckVwdXZkQXNqMTgiLCJhdWQiOiJwcmlzbWEtc2VydmljZWFjY291bnQtd2JnQDE1NDcwMTE5MzcuaWFtLnBhbnNlcnZpY2VhY2NvdW50LmNvbSIsIm5iZiI6MTcxNjg4MzMyMywiZ3JhbnRfdHlwZSI6ImNsaWVudF9jcmVkZW50aWFscyIsInNjb3BlIjpbInByb2ZpbGUiLCJ0c2dfaWQ6MTU0NzAxMTkzNyIsImVtYWlsIl0sImF1dGhfdGltZSI6MTcxNjg4MzMyMywicmVhbG0iOiIvIiwiZXhwIjoxNzE2ODg0MjIzLCJpYXQiOjE3MTY4ODMzMjMsImV4cGlyZXNfaW4iOjkwMCwianRpIjoibTJ0VEN4VVNobzZpUzByX2tpTElteXh4Nmg4IiwidHNnX2lkIjoiMTU0NzAxMTkzNyIsImFjY2VzcyI6eyJwcm46MTU0NzAxMTkzNzo6OjoiOlsidmlld19vbmx5X2FkbWluIl19fQ.d0N3ovRS1bjjYHmDkc_ccM-oSN4Y6PXkflWtbkfUJ-31wuODghFaTsdA1_R0h2cg3EeC7clL58tln040YBnHkYpp1k4gm9y_jtRn6wJCO8_Uo1mpj7XuusBumK0V6v044yBJR7dYU3KCGQgjQztwAhZGaLOSVvfnPVpgooxCDluhAEKOr7WfZH6Hm6DKpKa4fS2Fd9G-ZiLXWv3qeVGI9NfanLJZ3Tj_h10jPG6ae1UP5FE5aSHIJEXmJxQRerRu9oAkMrBoZk5MXOvIC5u1mZ4lCoNPkYCxIghHY840FQ5w6Gqh1dT1IVRWkvsfPH8fCdE7G4asy0J0P9NcIEt5Cw" -H "Prisma-Tenant:1547011937" -H "Content-Type: application/json" --data-binary @c:\temp\input.json >c:\temp\output.json
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 666 100 99 100 567 138 791 --:--:-- --:--:-- --:--:-- 936

Below is the output, which I put in the output.json file:
{"errorCode":"REST10001","message":"Unexpected server error","details":"Failed to process request"}

Do I understand correctly, that instead of .json file, you use .txt? How do you feed the .txt in the command? Or are you saying, that you tried putting the .json load directly in the command, and then did that as me, putting it in a .json file? Your help will be much appreciated. 

Kind Regards,

KPopov