topic Prisma Insights API in PowerShell in Prisma Cloud Discussions

Prisma Insights API in PowerShell

StephenBuist — Fri, 24 Mar 2023 15:05:28 GMT

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.

Re: Prisma Insights API in PowerShell

MDavis29 — Thu, 06 Apr 2023 20:29:25 GMT

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

Re: Prisma Insights API in PowerShell

StephenBuist — Mon, 17 Apr 2023 08:13:13 GMT

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.

Re: Prisma Insights API in PowerShell

kpopov — Tue, 28 May 2024 08:14:39 GMT

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

Re: Prisma Insights API in PowerShell

kpopov — Fri, 04 Apr 2025 09:23:49 GMT

Hi All,

For anyone out there, having similar to my issue, here is the solution:

curl -X POST https://pa-us01.api.prismaaccess.com/api/sase/v2.0/resource/query/tunnel_status -H "Authorization: Bearer your long key, which you should have generated" -H "Prisma-Tenant:123456789" -H "Content-Type: application/json" -d @c:\temp\input.json > c:\temp\output.json