Json Error when sending POST request to https://api.prismacloud.io/search/config

PPrabhakar — Wed, 21 Apr 2021 13:55:38 GMT

Hello,

I am getting the below error when sending the POST request to "https://api.prismacloud.io/search/config",

Error:

{ "errorMessage": "Expecting value: line 1 column 1 (char 0)", "errorType": "JSONDecodeError", "stackTrace": [ " File \"/var/task/lambda_function.py\", line 49, in lambda_handler\n queryRQL(REQ_HEADER,url,requestbodyAWS)\n", " File \"/var/task/lambda_function.py\", line 14, in queryRQL\n json_string = json.dumps(response.json())\n", " File \"/opt/python/requests/models.py\", line 900, in json\n return complexjson.loads(self.text, **kwargs)\n", " File \"/var/lang/lib/python3.8/json/__init__.py\", line 357, in loads\n return _default_decoder.decode(s)\n", " File \"/var/lang/lib/python3.8/json/decoder.py\", line 337, in decode\n obj, end = self.raw_decode(s, idx=_w(s, 0).end())\n", " File \"/var/lang/lib/python3.8/json/decoder.py\", line 355, in raw_decode\n raise JSONDecodeError(\"Expecting value\", s, err.value) from None\n" ] }

Here is my python code:

import requests import json import csv import re import sys Query_ACM = "{\"timeRange\":{\"value\":{\"unit\":\"hour\",\"amount\":24},\"type\":\"relative\"},\"withResourceJson\":true,\"query\":\"config from cloud.resource where cloud.type = 'aws' AND api.name = 'aws-acm-describe-certificate'\"}" def login(): header = {'Content-Type':'application/json'} payload = {"username":"AccessKey","password":"SecretAccessKey"} API = "https://api.prismacloud.io" response = requests.request('POST', '{}/login'.format(API), json=payload, headers=header) json_response = response.json() return json_response['token'] JWT_TOKEN = login() url = "https://api.prismacloud.io/search/config" REQ_HEADER = {'Content-Type':'application/json','x-redlock-auth':JWT_TOKEN} def queryRQL(REQ_HEADER,url,RQLquery): response = requests.request("POST", url, data=RQLquery, headers=REQ_HEADER) json_string = json.dumps(response.json()) json_data = json.loads(json_string) return json_data json_output = queryRQL(REQ_HEADER,url,Query_ACM)

Note: When this script is run locally it perfectly runs fine, but when deployed to a lambda function it gives the error mentioned in the beginning.

Can anyone suggest why the lambda function fails to run this?

Thanks & Regards,

Pavan

Re: Json Error when sending POST request to https://api.prismacloud.io/search/config

AKing9 — Fri, 12 Aug 2022 14:24:34 GMT

Greetings PPrabhakar,

I hope that this note finds you well! I know that it has been a while since you had posted this question but I wanted to see if you still potentially needed any help. Thank you for your time and I hope that you have a good remainder of your day.

Kind Regards,

J. Avery King

topic Re: Json Error when sending POST request to https://api.prismacloud.io/search/config in Prisma Cloud Discussions

Json Error when sending POST request to https://api.prismacloud.io/search/config

Re: Json Error when sending POST request to https://api.prismacloud.io/search/config