For a personal project I’m trying to write an AWS Lambda in Python3.9 that will delete a newly created user, if the creator is not myself. For this, the logs in CloudWatch Logs will trigger (via CloudTrail and EventBridge) my Lambda. Therefore, I will receive the JSON request as my event in : But I have…
Tag: json
Iterate in a dictionary inside a list of json and get a dataframe
I have a file with this structure (it comes from a json): I need to iterate through it for getting a dataframe like this: I’m trying to do it with this code: But I’m getting a dataframe with 3 columns: document, highlights and text_match like this: . I guess the solution is not very difficult but …
How to select a value from a JSON dictionary and assign the new selected value as a Key value?
This is the JSON data I have. I want to assign ‘organization’ as the new key and when I call ‘organization’ rest of the field data should appear based on the organization number. I want to load these data into postgresql database in the form of json object in each field. Is that possib…
Unable to scrape jpg images link from json
I’m trying to scrape jpg images from each products, every product url saved in csv. Image links are available in json data so try to access json key value. When I try to run code it’s only getting back with all key value in spite of image url link, and second my code only able to scrape last produ…
azureml score.py not reading additional json file
I have a json file which I am using in score.py however, it is not being found. When making a post request to the endpoint I get the following error “No such file or directory: ‘/var/azureml-app/model_adjustments.json’” json file is in the same folder as score.py and calling it from a script…
I’m getting error when trying to convert Html to JSON using python with beautiful soup
I’m trying to scrap data from this website “https://quranromanurdu.com/chapter/1” , I want only text or content from id-contentpara and return that content in JSON format, this below code gives html content but i want that to convert to JSON. I tried to convert but I’m getting error , …
Iterate and Parse Json with similar values in python
I have this code which iterates and parses data from a json API feed. I am trying to filter out just the Premier League games but some competitions have similar names like ‘Premier League 2 (Division 2)’ and ‘Premier League Cup’ the output for this code is below. As you can see the fir…
How to fix the Python and JSON Delimiter Expected Error?
I’m entering the following code and receiving the delimiter expected error. From what I can gather JSON Decoder wants a ‘,’ automatically inserted between each record I pull from the For Loop. I can’t seem to find any solution. It pulls one record from the URL, then stops. Line 1, Colu…
How can I extract specific value from JSON response?
Hi I am trying to get value from JSON response which Im getting from GitLab API. Code should extract “commiter_name” value but it does not work, already tried several options from internet. Error: Answer This is because you did not include you api token in the header. Also please check that the we…
Parameters are ignored in python web request for JSON data
I try to read JSON-formatted data from the following public URL: http://ws-old.parlament.ch/factions?format=json. Unfortunately, I was not able to convert the response to JSON as I always get the HTML-formatted content back from my request. Somehow the request seems to completely ignore the parameters for JSO…