How to write a query in Hasura Data Api to give output based on input by user

Question

How to write the postgres sql body in Hasura data api to get some result by taking input from user. The sql query is like"Select moviedetails from table name where movie_name='name enterd by user'.I want to know the structure to accept data from user

url = "https://data.incipiently69.hasura-app.io/v1/query"

This is the json payload for the query

requestPayload = { "type": "select", "args": { "table": "collect", "columns": [ "overview" ] } }

Setting headers

headers = { "Content-Type": "application/json" }

Make the query and store response in resp

resp = requests.request("POST", url, data=json.dumps(requestPayload), headers=headers)

resp.content contains the json response.

print(resp.content)

This isn't an appropriate site for your question. I recommend that you seek a site with the word "forum" in the name. — SaganRitual, Mar 10 '18 at 03:53

score 1 · Answer 1 · answered Feb 19 '18 at 16:53

You would just need to substitute data retrieved from the user input in the where clause of the API query.

user_input = req.body.user_input

requestPayload = {
  "type": "select",
  "args": {
    "table": "collect",
    "columns": ["overview", "movie_name"],
    "where": {
        "movie_name": user_input
    }
  }
}

How to write a query in Hasura Data Api to give output based on input by user

This is the json payload for the query

Setting headers

Make the query and store response in resp

resp.content contains the json response.

1 Answers1