Hi there,
I’m getting back 200 responses when I do either a Find
or Add
action, but there seem to be problems. On the Find
post request the content of the result is empty, and the Add
action doesn’t change the sheet’s data.
The only thing I can think could be causing problems is that the appsheet isn’t deployed, I’m just trying things out for the moment. Is that the problem? Can anyone else advise?
below is the code that I’ve been using to make the POST requests.
import requests as rq
id_value =### left out of post ###
api_key =### left out of post ##
sheet_name = "clean_start"
header ={"applicationAccessKey":api_key}
body = {
"Action": "Find",
"Rows": [
]
}
link =f"https://api.appsheet.com/api/v2/apps/{id_value}/tables/{sheet_name}/Action"
link
res = rq.post(link,data=body,headers=header)
res ## returns 200
res.content ## is empty
body = {
"Action": "Add",
"Rows": [
{"names":"sam"},
{"values":30}
]
}
res = rq.post(link,data=body,headers=header)
## again 200
res
## no changes to the google sheet though...
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |