Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
format json outputs !
#1
hello all ...
iam trying to get json data from a website ... this is my code :
import requests
import json
import time

file1 = open('/home/evilcode1/Desktop/list.txt', 'r')
Lines = file1.readlines()
try:
    
    for i in Lines:
        i = (i.strip())
    
        
        time.sleep(3)
        burp0_url = "https://site.com/public_certificate_ajax"
        burp0_cookies = {"XSRF-TOKEN": "eyJpdiI6Im9sSHA1N3hiYlhob1ZqTVVsVU44RlE9PSIsInZhbHVlIjoicTV3cUgwS3lnY2tjaHJnb3NaeHYxZHNoYytEa0ZMRHgrcWQ4czZWR3BHc1BLOTBsckpMZ3BOODJuaU9DSWZlTlU0aWpMdVN1a3BIWHBrYTJtc3AyTTZnRHNVME13RkR2MHdRWWxlc2NRSW9NRVJBc1BQNmVOeDNnSDZ3WFdCZ1EiLCJtYWMiOiI2NTJiMjU5MTkwZjFjYTRmMTlhMzRjMTk3OTA0NDY1YWRiMmI2YzdkNjg5ZGZkMDRmNTgxNGMyMmNiNThiNjgyIn0%3D", "covid_19_vaccine_session": "eyJpdiI6IlVGQzVoUDRLaGJRRUhxcDJVcHdGQmc9PSIsInZhbHVlIjoiZkZvUHUrK2JjVEx5NHJLR2pPZWdaek5kcnl4SVo1M0dnK0o4dFp0NDVSUmpCcHZ1NW5VTHhSbjlxeG5FMUpUS1Q1OVhzUVdMVGFvVWZHL3pBTXhhMUJ5NDFBNlFsakVqeDhMblhaUmx5SS85Sy9kSmpFeGdnS1VONWZiREZCaDgiLCJtYWMiOiI4YmQxMTExOGFmOTQyODZlNTkxZmM4NGFjZGU5MjlhNWYyMzM5YjMxNzM2Yjg4ODc4NDU0MWI1MTY4OTJmNDE1In0%3D"}
        burp0_headers = {"User-Agent": "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0", "Accept": "*/*", "Accept-Language": "en-US,en;q=0.5", "Accept-Encoding": "gzip, deflate", "X-Csrf-Token": "C220Ih2j3xuYgfrL0LHdiAWU6Jyk1hVVkpIHj7UK", "X-Requested-With": "XMLHttpRequest", , "Referer": "https://site.com/certificate", "Te": "trailers", "Connection": "close", "Content-Type": "application/x-www-form-urlencoded"}
        burp0_data = {"id_no": i}
        q = requests.post(burp0_url, headers=burp0_headers, cookies=burp0_cookies, data=burp0_data)
        #q = q.encoding('utf-8') 
        d = q.text
        d = json.loads(d)
        print(d)
except:
    pass
[
Reply
#2
json.loads() returns a dictionary. Just print the fields you are interested in.
d = {
    'state': 'success',
    'user': {
        'name': 'قسام عبد الناصر عارف محمود',
        'id_no': '852470000',
        'dob': '1989-00-00',
        'sex': 'ذكر',
        'mobile': '0599000000',
        'district_name': 'رام الله و البيره',
        'clinic_name': 'مجمع رام الله الترويحي'
    },
    'appointments': [
        {'clinic_name': 'مديرية صحة رام الله والبيرة', 'app_date': '22/06', 'date_year': '2021'}
    ],
    'doses': [
        {'clinic_name': 'مديرية صحة رام الله والبيرة', 'vaccine_type': 'Pfizer', 'dose_sequence': 1, 'dose_date': '01/06', 'date_year': '2021'},
        {'clinic_name': 'مديرية صحة رام الله والبيرة', 'vaccine_type': 'Pfizer', 'dose_sequence': 2, 'dose_date': '22/06', 'date_year': '2021'}
    ],
    'print': 1
}

for key, value in d['user'].items():
    if key in ('name', 'id_no', 'dob', 'mobile'):
        print(f"{key:10} : {value}")
Output:
name : قسام عبد الناصر عارف محمود id_no : 852470000 dob : 1989-00-00 mobile : 0599000000
evilcode1 likes this post
Reply
#3
(Nov-21-2021, 08:21 PM)deanhystad Wrote: json.loads() returns a dictionary. Just print the fields you are interested in.
d = {
    'state': 'success',
    'user': {
        'name': 'قسام عبد الناصر عارف محمود',
        'id_no': '852470000',
        'dob': '1989-00-00',
        'sex': 'ذكر',
        'mobile': '0599000000',
        'district_name': 'رام الله و البيره',
        'clinic_name': 'مجمع رام الله الترويحي'
    },
    'appointments': [
        {'clinic_name': 'مديرية صحة رام الله والبيرة', 'app_date': '22/06', 'date_year': '2021'}
    ],
    'doses': [
        {'clinic_name': 'مديرية صحة رام الله والبيرة', 'vaccine_type': 'Pfizer', 'dose_sequence': 1, 'dose_date': '01/06', 'date_year': '2021'},
        {'clinic_name': 'مديرية صحة رام الله والبيرة', 'vaccine_type': 'Pfizer', 'dose_sequence': 2, 'dose_date': '22/06', 'date_year': '2021'}
    ],
    'print': 1
}

for key, value in d['user'].items():
    if key in ('name', 'id_no', 'dob', 'mobile'):
        print(f"{key:10} : {value}")
Output:
name : قسام عبد الناصر عارف محمود id_no : 852470000 dob : 1989-00-00 mobile : 0599000000

thank u very much it's working :)
Reply
#4
My friend, how can I contact you?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Formatting outputs created with .join command klairel 2 639 Aug-23-2023, 08:52 AM
Last Post: perfringo
  Convert Json to table format python_student 2 5,570 Sep-28-2022, 12:48 PM
Last Post: python_student
  I have written a program that outputs data based on GPS signal kalle 1 1,184 Jul-22-2022, 12:10 AM
Last Post: mcmxl22
  Converting cells in excel to JSON format desmondtay 4 1,760 May-23-2022, 10:31 AM
Last Post: Larz60+
  json format Bubu93200 6 1,947 Apr-23-2022, 08:59 AM
Last Post: Bubu93200
  Why does absence of print command outputs quotes in function? Mark17 2 1,393 Jan-04-2022, 07:08 PM
Last Post: ndc85430
  Thoughts on interfacing with a QR code reader that outputs keystrokes? wrybread 1 1,487 Oct-08-2021, 03:44 PM
Last Post: bowlofred
  Combining outputs into a dataframe rybina 0 1,688 Mar-15-2021, 02:43 PM
Last Post: rybina
  ONE input => THREE outputs Tricia279 6 2,651 Jan-14-2021, 08:52 AM
Last Post: perfringo
  Multi set string inputs/outputs kwmcgreal 2 2,087 Sep-26-2020, 10:44 PM
Last Post: kwmcgreal

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020