How can I query the database of users that interacted with my site and linked their metamask?

[moonboi9001]

Hi I want to send a query to my moralis server to see the details of the users who have interacted with my website, such as their ethereum account addresses, I was looking through the docs and found this

Parse

import json,httplib
connection = httplib.HTTPSConnection('YOUR.PARSE-SERVER.HERE', 443)
connection.connect()
connection.request('GET', '/parse/classes/GameScore', '', {
       "X-Parse-Application-Id": "${APPLICATION_ID}",
       "X-Parse-REST-API-Key": "${REST_API_KEY}"
     })
result = json.loads(connection.getresponse().read())
print result

I tried to follow that code example, pip install httplib returned an error:

Note: you may need to restart the kernel to use updated packages.
ERROR: Could not find a version that satisfies the requirement httplib (from versions: none)
ERROR: No matching distribution found for httplib

and when I tried to run it without pip I got the following error:

ModuleNotFoundError: No module named ‘httplib’

Whats the problem here? Am I doing the right thing? Are the docs out of date? As stated, I want to query the moralis server to return the database for the users that interacted with my website (then I will use pandas to process the data).

[Yomoo]

Hi @moonboi9001

You can do this using Moralis cloud functions. Here is an example of cloud function. You can call it from the frontend, UI dashboard, backend etc.

Take a look at :

Querying User table/class - Do I need Cloud Function?

Hey Guys, Trying to get a list of users from the user class table. I can’t seem to do this from the front end (as it just gives me the currently logged-in user). I tried to do it as a cloud function but no joy either. Here’s my code: Front end: loadUsers = async () => { const allusers = await Moralis.Cloud.run("loadUsers"); console.log(allusers); } …and here’s the cloud function: Moralis.Cloud.define("loadUsers", async (request) => { const query = new Moralis.Query("User"); …

Hope this will help you

[moonboi9001]

How do you do this in python? Seems like all the solutions only give examples in javascript

[Yomoo]

Cloud functions supports currently only JS.

You can create this function in JS in cloud functions and call it directly using a simple GET request

https://docs.moralis.io/moralis-server/cloud-code/cloud-functions#calling-via-rest-api