Retrieving single json object from python requests results as list

Question

I'm trying to retrieve only requestId object from json results after querying my API.

my code:

def findRequests(group, token, user):
    headers = { 'accept': 'application/json', 
        'Content-Type': 'application/json', 
        'token': token,
        'user': user}
    endpoint = 'requests/find'
    body = {'groupIDs': [group], "createdDate": {'operator': "BETWEEN", 'fromDate': "01-APR-2020 00:00:00", 'toDate': "21-APR-2020 00:00:00"}} 
    r = requests.post(url = host + endpoint, headers = headers, json=body, verify=False)
    data = json.loads(r.text)
    print (data[0]['requestId'])

json data:

[{'requestId': 2567887, 'requestName': 'Here is a sample name', 'requestSubject': 'sample subject', 'createdDate': '01-APR-2020 14:06:03'}, {'requestId': 7665432,...}]

then I would like to save all the values for requestId object found in results as a list:

 myRequestsList = print(findRequests(group, token, user))

However the above will only return a single requestId and not all of the ones that were returned in data variable in def findRequests(group, token, user). What am I doing wrong?

Output:

2567887
None

Desired output:

2567887,
7665432

Could someone help me with this? thanks in advance!

just changed to return (data[0]['requestId']) but when trying myList = print(findRequests(group, token, user)) afterwards it still returns only a single Id and not all of the Ids found in json data. Is there something else Im doing wrong? — Baobab1988
– Baobab1988, Commented Apr 20, 2020 at 16:31

andreis11 · Accepted Answer · 2020-04-20 17:05:35Z

1

First, you should modify your func:

Then, assign the variable to the func, not the print:

myRequestsList = list(findRequests(group, token, user)))

(!) However, I assume that group,token, user are replaced by other variables.

And finally, to get the output:

for req in myRequestsList:
 print(req)

Later edit:

def findRequests(group, token, user):
    headers = { 'accept': 'application/json', 
        'Content-Type': 'application/json', 
        'token': token,
        'user': user}
    endpoint = 'requests/find'
    body = {'groupIDs': [group], "createdDate": {'operator': "BETWEEN", 'fromDate': "01-APR-2020 00:00:00", 'toDate': "21-APR-2020 00:00:00"}} 
    r = requests.post(url = host + endpoint, headers = headers, json=body, verify=False)
    data = json.loads(r.text)
    final_list = []
    for each_req in data:
      final_list.append(each_req['requestId'])
    return final_list

myRequestsList = findRequests(group, token, user)

for each in myRequestsList:
 print(each)

edited Apr 20, 2020 at 17:05

answered Apr 20, 2020 at 16:27

andreis11

1,1611 gold badge6 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Baobab1988 Over a year ago

I've tried the above and when running this bit myRequestsList = list(findRequests(group, token, user)) it says TypeError: 'int' object is not iterable. Any idea what am I doing wrong here? thanks!

andreis11 Over a year ago

It is because findRequests(group, token, user)) retrieves a integer; do you mind sharing the json or just a small part of it (containing a12bd-fr145-52dg, b67da-pl132-53dg, c78aa-de111-890)

andreis11 Over a year ago

Np about the questions :) My bad, used with` instead of for. modified the func. for each_req in data: instead of with each_req in data. Updated the answer. Sorry again.

Baobab1988 Over a year ago

It worked now! thanks a lot for helping me with this!

andreis11 Over a year ago

Hi @Baobab1988 Included some samples in repl.it/repls/IdolizedEducatedDecompiler

|

Collectives™ on Stack Overflow

Retrieving single json object from python requests results as list

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related