Appsheet API is kicking my butt

So I’ve been trying to get this thing working all day with no luck. I’m using integromat to hit the API, here is my JSON

{
"Action": "Edit",
"Properties": {
   "Locale": "en-US"
   }
},
"Rows": [
{
 "UID": "4d9bf884",
 "Rep 1 Position": "Fake",
 "Name": "Sally"
}
]
}

When I check my Audit Log I have this.

REST API:
{
  "Action": "Edit",
  "Properties": {},
  "Rows": []
}

Properties:
 {
  "RestAPIVersion": 2,
  "TableName": "User_Information",
  "AppTemplateVersion": "1.000082",
  "Action": "Edit",
  "Errors": "No rows are present.",
  "AppTemplateName": "23d2858a-bb0a-4dd8-9c65-b150a9c50c05",
  "Operation": "REST API invoke",
  "RecordType": "Start",
  "Result": "Failure"
}

What the heck does it mean no rows are present? I am at a loss.
If anyone has any idea on what I might try, I’d really appreciate it.

thanks

I’ve sunk not-a-few hours into troubleshooting the API. I feel your pain.

Can you get it working with Postman? What about adding a row fake row?

1 Like

Seems like there may be an extra closing brace in your JSON…

{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-US”
} < --- THIS SEEMS EXTRA
},
“Rows”: [
{
“UID”: “4d9bf884”,
“Rep 1 Position”: “Fake”,
“Name”: “Sally”
}
]
}
3 Likes

Yay… Sort of… removing the bracket got it to work… sort of… now I have a 500 error. Is this related to the google sheet?

2 Likes

fixed it!!! thanks for the help

3 Likes